Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: DSN Connection - Access 2000/Windows 2000 Server


Message #1 by "Curtis F. Barnett" <cfb@s...> on Wed, 15 Aug 2001 16:33:27 -0500
Are there any ADO issues with Access2000? On NT4/IIS4/Access98 the

connection was:



          oConn.Open "DSN=myDB1; UserId=abcdef; pwd=ghijk"



I'm being told that Access2000/Windows2000 does not support UserId and

Password and that the DSN and connection should be:



          oConn.Open ("myDB1_999999")



The "_999999" is a unique number added by the provider to whatever I name my

DSN.



Problem: When I try and access  the DB, regardless of the connection string,

I get this error:



Microsoft OLE DB Provider for ODBC Drivers Error 80004005



[Microsoft][ODBC Microsoft Access Driver]Cannot open database '(unknown)'.



It may not be a database that your application recognizes, or the file may

be corrupt.



They claim to have a highly custom/proprietary installation of Windows. My

feeling is that if you can't run a text book example, then it's not much use

to the programming public.



Thanks for any ideas or information?



CFB




  Return to Index