I have developed a website that connected to sql2000 db
Now that I have upgraded to SQLserver2005, I always get the follwing message after launching the website:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/iisHelp/common/500-100.asp, line 11 Dim objASPError, blnErrorWritten, strServername, strServerIP, strRemoteIP Dim strMethod, lngPos, datNow, strQueryString, strURL --^
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][Gestionnaire de pilotes ODBC] Source de donnes introuvable et nom de pilote non spcifi
/FMCQ_Web/Include/Modules/modADO.asp, line 18
I have tried different things (security access, DSN, etc...)but seems that nothing is working,
Can someone out there suggest a move to get this going..
The error is so obvious:
Dim objASPError, blnErrorWritten, strServername, strServerIP, strRemoteIP Dim strMethod, lngPos, datNow, strQueryString, strURL
Change to two lines:
Dim objASPError, blnErrorWritten, strServername, strServerIP, strRemoteIP
Dim strMethod, lngPos, datNow, strQueryString, strURL
Hope this helps!
Joe
