Just builded a new IIS6-server and now moving some of the websites on this one. But now I'm running into problems
The old server is a IIS6 aswell, which is why I'm confused.
When I try to do this:
set rsWeek = server.createobject("adodb.recordset")
SQLGetWeek = "SELECT * FROM TblUger ORDER BY STARTDATO"
rsWeek.open SQLGetWeek, conn, 3,3
I'm getting this error :
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Unknown
But when I remove the ORDER BY STARTDATO it runs fine. The same problem goes for my WHERE-clause?
Any idea why?