Database connection error...

Results 1 to 3 of 3

Thread: Database connection error...

  1. #1
    Charles Guest

    Default Database connection error...

    Hi, I&#039;m trying to just simply connect to a DB using asp, but I keep getting this error message, and cant find any documentation on how to correct this problem...<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80004005&#039; <BR><BR>[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified <BR><BR>Is the error i get, this is the line it refers to !<BR>Dim objConn, objRS, strSQL<BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR>objConn .Open "PJC"<BR><BR>What could be the problem ! ??? <BR>

  2. #2
    ZeenGoone Guest

    Default RE: Database connection error...

    Found the problem...<BR><BR>In VBScript when accessing a DB, use objRS.Open = "PJC","userid","password"<BR><BR>this should clear you&#039;re problem out

  3. #3
    Charles Guest

    Default RE: Database connection error...

    Heh... it actually did, thanks alot

Posting Permissions

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