DSN Error

Results 1 to 3 of 3

Thread: DSN Error

  1. #1
    chad1 Guest

    Default DSN Error

    Can anyone translate the error message:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80004005&#039; <BR><BR>[Microsoft][ODBC Microsoft Access 97 Driver] Can&#039;t open database &#039;(unknown)&#039;. It may not be a database that your application recognizes, or the file may be corrupt. <BR><BR><BR>Here&#039;s the code it referred to...<BR><BR>&#060;%@ LANGUAGE="VBSCRIPT" %&#062;<BR>&#060;% <BR>dim conn, retemp<BR>dim sql<BR>dim myname, mypassword<BR>myname=request.form("username")<BR>m ypassword=request.form("userpassword")<BR><BR>Set Conn = Server.CreateObject("ADODB.Connection") <BR>Conn.open("login")<BR>SQL="SELECT * FROM users WHERE user= myname AND password= mypassword "<BR>set rstemp=conn.execute(SQL)

  2. #2
    Array Freak Guest

    Default RE: DSN Error

    You are telling ADO to open something called Login and providing no information in the connection string about where this is, what it is, or what driver to use.

  3. #3
    Join Date
    Dec 1969

    Default RE: DSN Error

    dude replace the sql with<BR><BR>conn.Open "DSNName"<BR>SQL="SELECT * FROM users WHERE user=&#039;"& myname&"&#039;"<BR>SQL= SQL & " AND password =&#039;"&password&"&#039;"<BR>conn.execute(SQL)<BR ><BR>and bob will be your uncle

Posting Permissions

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