Anyone know a fix for....

Results 1 to 2 of 2

Thread: Anyone know a fix for....

  1. #1
    D. Guest

    Default Anyone know a fix for....

    Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR>[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified <BR><BR>The code i&#039m using to connect to the database is:<BR><BR>Dim Conn<BR>Set Conn = Server.CreateObject("ADODB.Connection") <BR>Conn.ConnectionString = "DSN=mydb" <BR>Conn.Open "mydb"<BR><BR>The System DSN has been setup and is working fine...<BR>The code appears to be okay...<BR><BR>Anyone know what is causing this and how i might fix it?<BR>

  2. #2
    Mark Guest

    Default RE: Anyone know a fix for....

    Try:<BR>Dim Conn<BR>Set Conn = Server.CreateObject("ADODB.Connection") <BR>Conn.Open "DSN=mydb"<BR><BR>Make sure that your DSN is setup as a "System DSN", not as a "File DSN" or a "User DSN". Also, make sure that the proper driver is selected for your database.

Posting Permissions

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