ODBC Connection Between Access and Btrieve Data Dictionary

Posted on 2007-10-16
Last Modified: 2013-12-25
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.
Question by:pgearle
    LVL 29

    Accepted Solution

    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
    LVL 28

    Assisted Solution

    by:Bill Bach
    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 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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    Creating and Managing Databases with phpMyAdmin in cPanel.
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now