DSN-less connection

Results 1 to 3 of 3

Thread: DSN-less connection

  1. #1
    Join Date
    Dec 1969

    Default DSN-less connection

    Can someone please help? I have an asp page that contains the following code for a DSN-less connection:<BR><BR>******<BR>set objConn = server.CreateObject("ADODB.connection")<BR>objConn .ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};" & _"DBQ=\Ausnhicf06datagroupSYSTEMSSTATEstrep.mdb " <BR><BR>objConn.Open<BR>*********<BR>I then get the following error when accessing the page:<BR><BR>"Microsoft][ODBC Microsoft Access 97 Driver] &#039;(unknown)&#039; isn&#039;t a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. "<BR><BR>however, when i used the complete path to my database as a link, it would open up my database, which proves that the path is correct. This leads me to think that something is wrong with the DSN part. <BR><BR><BR><BR>

  2. #2
    prakash Guest

    Default RE: DSN-less connection

    look in this site...http://www.eggheadcafe.com<BR>you get a better idea I guess<BR><BR>its on this link<BR>http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=94<BR><BR>Hope it will serve your purpose

  3. #3
    Join Date
    Dec 1969

    Default With Access....

    You can&#039;t use the network path....It needs to be a mapped drive.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts