I have been trying to pull data from a Pervasive Scalable SQL database using Pervasive`s 32 ODBC driver (either v. 2.02 or v. 2.04)into SQL Server 7. I am using DTS and I can see my table names and column names, the query parses fine but then when I try to actually run the query to load the tables my system hangs. Does anyone know if the Pervasive 32 ODBC driver is compatible with MS SQL Server 7.
Pervasive has been no help, they say they have done no testing against SQL 7.


TIA

Patricia Cole