Change vom Pervasive ODBC to OLEDB Provider -
07-29-2003
, 06:50 AM
Hello !
I want to write Pervasive SQL V8 Data into a MS SQL Server 2000 Table.
I am using Pass-Through-Queries:
Example:
SELECT *
FROM OpenRowSet
('MSDASQL', 'Driver={Pervasive ODBC Client
Interface};DBQ=@VITKUNDE8', 'SELECT kdnr,kcode, bereich FROM Kunde')
Who can change my ODBC Parameters (???..???) to OLEDB
SELECT *
FROM OpenRowSet
('???PervasiveOLEDB???MSDASQL', '???Driver={Pervasive ODBC Client
Interface};DBQ=@VITKUNDE8; initial catalog etc.???', 'SELECT
kdnr,kcode, bereich FROM Kunde')
Thanks
paul |