Unanswered: MS SQL Server, Linked Server to Pervasive
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?