PDA

View Full Version : MS SQL Server, Linked Server to Pervasive


rdcoll
06-04-03, 15:41
Hello all,

I am new to the forums and I have a question regarding linked servers. I am searching for the method of adding a Linked Server from MS SQL Server to a Pervasive database (specifically, the DEMODATA database that one gets after installing the Pervasive trial).

Specifically, I am looking for

1. What (if any) special drivers do I need?

2. What DSNs (if any) are necessary, besides DEMODATA with the Pervasive ODBC Engine Interface driver?

3. What parameters need I provide to sp_addlinkedserver?

Any input would be very much appreciated. Thanks.

Rob

Emmon
06-16-03, 06:26
Hi

Do you have an ODBC connection to yoru Pervasive database already?