Kbase 20375: ODBC Driver Error 80004005 with ASP
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
Progress 9.1D
SYMPTOM(s):
Error connecting from ASP Page.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and
no default driver specified
/work91a/test.asp, line 10
The following piece of code, when calling a User DSN, will fail with the above error message:
myDSN = "DSN=myDSN;uid=myUSerName;pwd=myPassword"
set conntemp = server.createobject("ADODB.connection")
conntemp.open myDSN
CAUSE:
The error occurs when a User Data Source Name (DSN) has been specified in the ASP connection code.
FIX:
Use a System Data Source Name (DSN) instead.