DSN Help

[dsk525]

Hi All,

I have set up a particular system DSN, which does not seem to be working. I've checked the spelling, pointing of the database, etc. and I still seem to be getting the following error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
/graonline/OnlineLoginPageProcess.asp, line 22

Line 22 of the code is:
Conn.Open "DSN=OnlineNMCDatabase"

I've also checked for permissions and everything looks okay.
Additionally, I've tried to reboot a few times but no luck.

Any pointers would be much appreciated!

 

[foxbox]

Check the DSN configuration with the ODBC manager: (W2K)

Programs | Administrative Tools | Data Sources (ODBC)
[Configure] button
4 x [Next] button
[Test Data Source] button

hth,
Foxbox

 

[dsk525]

Hi,

I think you can only test SQL Server DSN. I have an access MDB DSN and there does not seem to be any test button for that.

Thanks for trying to help!

 

[foxbox]

http://support.microsoft.com/defaul...port/kb/articles/q197/4/59.asp&NoWebContent=1

?

hth,
Foxbox