ODBC connectivity problem

Results 1 to 2 of 2

Thread: ODBC connectivity problem

  1. #1
    mujib Choudhury Guest

    Default ODBC connectivity problem

    get message in browser<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Could not find file &#039(unknown)&#039. <BR><BR>//global.asa, line 54 <BR><BR>the code in global.asa reads<BR><BR><BR>dbDSN = "gettha"<BR>&#039dbUSR = "Admin"<BR>&#039dbPWD = ""<BR>SQL = "SELECT * FROM Params WHERE pkID = 1"<BR><BR>Set cn = Server.CreateObject("ADODB.Connection")<BR>cn.Open dbDSN, &#039dbUSR, dbPWD<BR><BR>Set rsParams = Server.CreateObject("ADODB.RecordSet")<BR>With rsParams<BR>.Open SQL, cn, adOpenDynamic ,adLockPessimistic<BR>End With<BR><BR>can anyone help please<BR>email mujibc@hotmail.com

  2. #2
    Leungas Guest

    Default RE: ODBC connectivity problem

    You cannot use single quote before anything in VBScript.... it will recognise it as comment instead of code

Posting Permissions

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