Solved

ODBC driver for btrieve

Posted on 2004-11-01
19,060 Views
Last Modified: 2013-12-25
I need an ODBC driver for a btrieve database, I only have the .DAT files, and need to convert them to MSSQL server (I use the MSDE2000). But first I want to access the data, and for that I need an driver, and some instructions how to set it up. Can anyone help me ?
0
Question by:win32
    5 Comments
     
    LVL 18

    Expert Comment

    by:mirtheil
    Check out Goldstar Software's white paper on the topic:
    http://www.goldstar-sw.com/btrvodbc.asp
    0
     

    Author Comment

    by:win32
    I only got the .DAT files  from the customer, and need to do the rest. How can I determine the version of the database if I only have the .DAT files ? (It seems I need 6.xx to get an ODBC driver)
    0
     
    LVL 18

    Expert Comment

    by:mirtheil
    You're going to need an engine to read the DAT files.  What version of Btrieve is the customer using?  You can always download the trial version of Pervasive.SQL V8.6, which is the current version from http:/www.pervasive.com.
    0
     

    Author Comment

    by:win32
    I downloaded Pervasive.SQL V8.6, but since there is not DDR file I can only see raw data with it. I also have a .DAT to .TXT file converter and that does the same job for me, so is there a benifit by using the Pervasive.SQL V8.6 compared with the dat->text file converter ?
    0
     
    LVL 18

    Accepted Solution

    by:
    The whitepaper mentioned above talks about creating DDFs.  You will need to know the record layout.  
    As far as the converter, if it does the job you need, then use it.  If not, then you'll need DDFs to read the data files through ODBC.
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Cisco Complete Network Certification Training

    If you’re an IT engineer or technician, it's time you take your career to the next level. This elite training bundle is brimming with all of the information you need to learn to sit for Cisco CNNA, CCNP, and CCENT certification exams.

    Suggested Solutions

    Introduction: Often, when running a query with joins, the results show up "duplicates", and often, those duplicates can be "eliminated" in the results using DISTINCT, for example. Using DISTINCT is simple: just add it after the SELECT keyword, an…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    884 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

    17 Experts available now in Live!

    Get 1:1 Help Now