Results 1 to 2 of 2

Thread: ADO

  1. #1
    Rich Pena Guest

    Default ADO

    I have a file called db011.dbf path c:inetpubwwwgiddingsgascontroldb011.dbf first column heading name "ADDRESS" last "MISC_9"<BR><BR>Can someone send over the source to connect using ADO OLE db. I am trying not to us ODBC or DSN-Less. I keep trying and get errors. PLEASE HELP

  2. #2
    steve balmer Guest

    Default is this what you are after?

    notice the ";" after the db name.<BR>&#060;%<BR>Dim strSQL<BR>Dim rs<BR>Dim strSrc<BR><BR>strSQL = "SELECT * FROM Table1" <BR>strSrc = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"<BR>strSrc = strSrc & "DATA SOURCE=" & server.mappath("db.mdb") & ";"<BR>Set rs = Server.CreateObject("ADODB.Recordset") <BR>rs.Open strSQL, strSc<BR>%&#062;

Posting Permissions

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