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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Btrieve 6.15 to SQL Server - ODBC

Author  Topic 

jsiedliski
Yak Posting Veteran

61 Posts

Posted - 2004-02-12 : 15:34:35
I am trying to import data (using DTS) from Btrieve 6.15 to MS SQL Server 2k.

I saw another positng on this where someone had sucess with the acutal import. I have a bad feeling though, that the Btreive version they were dealing with is much newer and has a driver.

I tried using the Paradox driver - can see the tables, but nothing else.

http://support.microsoft.com/default.aspx?scid=kb;en-us;139328

Does anyone know what Driver / Data Source type I should be selecting?

Also, please tell me what you think abou this page - looks like Micosoft does not support ODBC to Btrieve?

Thanks in advance,

Jack

Rome was not built overnight.

jsiedliski
Yak Posting Veteran

61 Posts

Posted - 2004-02-12 : 18:36:42
Man........tasks like this one make me appreciate SQL Server.

Anyway, I wanted to share with the rest of you who may be interested:

Accessing Btrieve Data From ODBC or Other Applications:
http://www.goldstarsoftware.com/btrvodbc.asp#DatabaseEngines

--Jack

Rome was not built overnight.
Go to Top of Page
   

- Advertisement -