How to connect to Btrieve using ODBC

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
akrzy
Participant
Posts: 121
Joined: Wed Dec 08, 2004 4:46 am

How to connect to Btrieve using ODBC

Post by akrzy »

Hi,
Do you have any knowladge about: "How to connect to Btrieve using ODBC".
I have some files with *.btr extension and I would like to use DS to extract data from them.

I am not sure what I need to do that.
I don't know what version of Btrieve I have :).


I suppose that I should have some client version of Btrieve...
Can you give me some advice?

Is it possible?
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

A quick use of google shows that there are ODBC drivers out there for BTrieve. I didn't check whether there are freeware ones out there or not. If you have an instance of Btrieve you could always export the data into a csv or similar format from the database.

You are going to need either BTrieve or a driver no matter what.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
Hoping I'm guessing right, are you talking about magic files?
Last time I thought I need to do it they were just about to replace them with Oracle tables instead, So I ended up handling tables instead :).
I don't have any such file to try and test this so the only thing I can sugest is that you try to see if you can get them in an ascii format or in a DB table.

Sorry I'm not much help this time :(

Good Luck :),
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Post Reply