Unanswered: Pervasive - SQL Server (Linked Server)
I've created and ODBC Connection to an old BTreive database using the "Pervasive ODBC Engine Interface" driver. I purchased the Pervasive Workgroup Engine to connect.
Thereafter I create a Linked Server in SQL Server using the following information (this was mostly guess work, but the tables do get listed after the connection) ;
Product Name: Pervasive ODBC Client Interface Data Source: <DSN Created as mentioned above> Provider String: MSDASQL Location: <blank> Catalog: <blank>
When I run the query below:
select * from openquery(<LINKED_SERVER_NAME>, 'select * from <TABLENAME>')
I get this error:
OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'MSDASQL' ICommandPrepare::Prepare returned 0x80004005: The provider did not give any information about the error.].
Can anyone provide any insight as to why OR tell me if there's a better way to link to these tables.