dBase IV

Results 1 to 2 of 2

Thread: dBase IV

  1. #1
    Join Date
    Dec 1969

    Default dBase IV

    I am trying to make a DSN-less connection to a dbase IV database, can you assist? The following is the code and the error message...<BR><BR>Here is where I am now: <BR><BR>Code: <BR> &#060;!--#include File="adovbs.inc"--&#062; <BR>&#060;% <BR>dim oConn <BR>dim oRSp <BR>Set oConn=Server.CreateObject("ADODB.connection") <BR>Set oRSp=server.createobject("ADODB.recordset") <BR>oConn.ConnectionString="Driver={Microsoft dBASE Driver (*.dbf)};DriveID=277;Dbq=c:sasixpdatafileastu0021. dbf;" <BR>oConn.Open <BR>oRSp.Open "Select * From astu0021.dbf", oConn, , ,adCmdText <BR>response.write "!" <BR>response.write "&#060;table border=0&#062;" <BR>do while NOT oRSp.EOF <BR>response.write "&#060;tr&#062;&#060;td&#062;" & oRSp("lastname") & "&#060;/td&#062;&#060;/tr&#062;" <BR>oRSp.MoveNext <BR>Loop <BR>response.write "&#060;/table&#062;" <BR>oRSp.close <BR>set oRSp=nothing <BR>oConn.close <BR>set oConn=nothing <BR>%&#062; <BR><BR>Error: <BR><BR>Technical Information (for support personnel) <BR>ยท Error Type: <BR>Microsoft OLE DB Provider for ODBC Drivers (0x80004005) <BR>[Microsoft][ODBC dBase Driver]General error Unable to open registry key &#039;Temporary (volatile) Jet DSN for process 0x7d4 Thread 0x888 DBC 0x2287024 Xbase&#039;. <BR>/Announcements.asp, line 20 <BR>

  2. #2
    J. Paul Schmidt Guest

    Default Connections Resource

    Here is a connections resource:<BR><BR>Connections<BR>http://www.able-consulting.com/ADO_Conn.htm<BR>"This page contains sample ADO connection strings for ODBC DSN, ODBC DSN-Less, OLE DB Provider, and MS Remote. These sample connection strings are from the Microsoft ADO Newsgroups and are compiled by Carl Prothman, a Microsoft Visual Basic MVP."<BR><BR>Best regards,<BR>-Paul<BR><BR>J. Paul Schmidt, MBA<BR>Databases on the Web<BR>http://www.Bullschmidt.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