DSN-less connection

Results 1 to 2 of 2

Thread: DSN-less connection

  1. #1
    Serg Guest

    Default DSN-less connection

    Hi everybody!<BR>I try to execute this code and it gives me error like: file unknown<BR><BR> Set MyConn = Server.CreateObject("ADODB.Connection")<BR>MdbFile Path = "C:Inetpubwwwrootsergsample.mdb"<BR>MyConn.Ope n "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"<BR>SQL_query = "SELECT * FROM language"<BR>Set RS = MyConn.Execute(SQL_query)<BR><BR>Where is problem?<BR>Thanks in advance.

  2. #2
    Jason Buck Guest

    Default RE: DSN-less connection

    strConnect2 = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:databasespartan.mdb"<BR><BR>dim objconn2, objrec2, mysql2<BR>set objconn2 = server.createobject("ADODB.Connection")<BR><BR>obj Conn2.open strConnect2<BR><BR>mysql2 = "SELECT tblDocCat.SortOrder, tblDocCat.DocCategory from tblDocCat"<BR><BR>set rstemp2=objConn2.execute(mysql2)<BR><BR>Respectful ly,<BR><BR>Jason Buck<BR>webmaster@wnj.com<BR>

Posting Permissions

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