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.

Thanks!!

First, what error are you seeing if you use the Pervasive Control Center to access the table?
Second, are the SQL Server and Pervasive.SQL on the same server?