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

ODBC driver for btrieve

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
win32
Asked:
win32
  • 3
  • 2
1 Solution
 
mirtheilCommented:
Check out Goldstar Software's white paper on the topic:
http://www.goldstar-sw.com/btrvodbc.asp
0
 
win32Author Commented:
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
 
mirtheilCommented:
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
 
win32Author Commented:
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
 
mirtheilCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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