Problem with SQL (MS-Access) and ASP

DaPrince · August 11th, 2004, 04:49 AM

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:

Code:

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?

Steven · August 11th, 2004, 06:43 PM

Are you sure that there's a field called STARTDATO in the table?

I am a loud man with a very large hat. This means I am in charge

DaPrince · August 12th, 2004, 01:22 AM

Yes, the exact same files work execellent on another server.

happygv · August 13th, 2004, 05:27 PM

Check out this link - 80040e14

BTW, what are the other column names in that table? Can you list out those names here.

Cheers!

_________________________
- Vijay G
Strive for Perfection

DaPrince · August 14th, 2004, 08:11 AM

I believe there is something wrong with the driver for MDB-files. MS Access 2000 SP3 doesn't work either, so I'll try at reinstall the Office 2000 package and hope for the best.