I moved my webserver from one server to another. My operating system on my old server was Windows NT. My new server has windows 2000 server. I have visual interdev 6.0. My problem is when I try to run an application, I get an error.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------
----------
----------
----------
----------
----------
----
Technical Information (for support personnel)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error
/contactinfoapp/_ScriptLib
rary/Recor
dset.ASP, line 636
I have installed the Front Page extension, I have updated to the latest MDAC.
I'm using a statement select * from table where field = ? and I am using a recordset to pass a paramenter into the question mark. If I hard code it select * from table where field = 'yellow' then the application works just fine. I have a feeling it has something to do with my data connection, but I just can't seem to figure it out.
Thanks in advance.
Start Free Trial