Interface SQL Server 2000 w/ Pervasive 2000i 1

[smeyer56]

Is it somehow possible to interface data in SQL server database with data in a Pervasive DB?
We have Great Plains using SQL and we need to data such as customer balances into the Pervasive DB.

 

[mirtheil]

You can use a Linked Server in SQL Server to access the Pervasive database through ODBC. There is another way that is something like "openrowset" but I'm not exactly sure.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[smeyer56]

Thanks, I had never heard about this option. I will look into it.

 

[mirtheil]

One thing to note about Linked Servers. With 2000i, you have to use the ODBC driver. You can't use the OLEDB provider. I don't use Linked Servers so I can't give you any more information on why it doesn't work.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com