
January 12th, 2005, 01:05 PM
|
|
Registered User
|
|
Join Date: Jan 2005
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Help - Connecction Error!
Hi,
I'm using window server 2003 as a test server. I have Access 2003 as the database. I set up a DSN for db connection and try to access the data with ASP. Here are my codes:
set dbConn = Server.CreateObject("ADODB.Connection")
dbConn.Open "DSN=test"
if dbConn.Errors.Count <> 0 then
for each objErr in dbConn.Errors
response.write objErr.Number & "<br>" & objErr.Description & "<br>"
next
else
response.write "OK"
end if
All I got is this error message:
0
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
Can anyone tell me how to correct the problem? Thanks.
|