[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 681
  • Last Modified:

ODBC Connection Between Access and Btrieve Data Dictionary

I have an Access database that I want to be able to read Btrieve tables.  We're running Pervasive SQL 8.  I'm new at this, and believe I have to set up an ODBC connection, but don't have much idea about all the steps I'll need to complete to create a DSN and name the data source, which I believe is a .DDF file.  Any help would be appreciated.
2 Solutions
This has helped me with connection strings in the past:

 1. In Notepad, or any other text editor, create a file named Temp.udl  

 2. Leave the file empty and save it to the Desktop

 3. Double-click the Temp.udl file

 4. The Data Link Properties dialog box appears

 5. In the Data Link Properties dialog box, click Provider. Select the appropriate provider from the list

 6. Click Connection and select the corresponding name of the server and the database
    Type the User Name and the Password
 7. Click Test Connection to test the connection

 8. Click OK

 9. Right-click Temp.udl and click 'Open With'
    If Notepad shows up as an option, click it, otherwise click 'Choose Program' and navigate
    through the list to notepad and select it

10. Copy the connection string to your application
Bill BachPresidentCommented:
I would recommend starting with the Pervasive Control Center on the server (or on the workstation, if you have the Workgroup Engine).  

In the PCC, open the computer name, then databases.  You should see DEMODATA and possibly other databases there.  Somewhere on your hard disk you will find the database files for your application.  These can have any extension, but commonly will be DAT, MKD, BTR, DTA, etc.  Check this directory to see if there is ALSO a set of data dictionary files (including FILE.DDF, FIELD.DDF, etc.).  These files must have been provided by the application developer, and they may or may not be in the same directory as the database files.

When you have the DDF and the data file locations, right-click on the Databases icon in the PCC tree view, and select New Database.  Provide a database name, as well as the path to the DDF's, and click Next/Finish.  

Now, try to open the new database from the PCC and see if you see tables in there.  If you can, then life is good.  If you see only system tables (those with the checkmarks), then this is an EMPTY set of DDF's, and not the ones provided by the app developer.  Find good ones and start over again.  If you need to create DDF's, then things are a LOT more complicated, and you should check out www.goldstarsoftware.com/press.asp for the paper on ODBC access for more information before continuing.

Once you have the PCC working, then you can access it from Access.  If you are on the same system as the engine, then just point it to the ODBC DSN you just created and you should be able to access it directly.  If you are on a client workstation, then you can go to the ODBC Administrator and create a new System DSN using the Pervasive Client connector.  Specify the server's name and communication method (probably TCP), and then click "Get Databases" and select your server-side DSN in the drop-down box.  

From there, it works like any other ODBC datasource in Access.

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now