Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
WindChaser
Posting Yak Master
225 Posts |
 Posted - 2012-04-03 : 20:53:37
|
| Hi folks,I need to access the data contained in some Btrieve data files (Pervasive). For this, I would need to get a BTrieve OLEDB driver somewhere. Does anybody know where I could get this? I'm not sure that Pervasive actually offers this (at least, I didn't see anything on their web site).Any advice would be welcome. Thanks! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
mirtheil
Starting Member
1 Post |
Posted - 2012-04-04 : 11:34:43
|
| You will need a few things in order to read Btrieve / Pervasive data. First, you need a PSQL engine. If you are working with existing data, you may already have one. Depending on the version you may also already have an ODBC and OLEDB provider. Check your system for W3BTRV7.DLL and W3DBSMGR.EXE. Those are a couple of good starting points for finding Btrieve / Pervasive on your system. Second, you'll need DDFs as well as the data files. Btrieve databases are file based and do not store metadata in the data file. Each table, usually, has its own data file. The metadata (fields, indexes, tables) are stored in the DDF files. Specifically, you'll need FILE.DDF, FIELD.DDF, and INDEX.DDF at a minimum. These files will either have table / field / index information in them or you'll need to add the information using DDF Builder, SQL statements, or other tools. If you don't have a PSQL engine, you can download the trial at http://pervasivedb.com/psqlv11/Pages/Default.aspx. The current version (v11) includes both ODBC drives and OLEDB providers. Hope this helps. |
 |
|
|
|
|
|
|
|
Importing BTrieve Pervasive data