Connection string SQL2005 StoredProcedure to Pervasive 8.5

[hlet]

Can someone help me with creating a Connection string to connect from a SQL2005 StoredProcedure to Pervasive 8.5?
Serveral tries do not lead to any succes.

ODBC parameters are:
ODBC;DSN=Ridder_Read;ServerName=nt-server.1583;ServerDSN=ridder_read;ArrayFetchOn=1;ArrayBufferSize=8;TransportHint=TCP;DecimalSymbol=.;ClientVersion=8.50.189.000;CodePageConvert=1252;AutoDoubleQuote=0;TABLE=ARTIKEL

 

[mirtheil]

What error are you getting? The most simple ODBC COnnection string is:
DSN=<dsnname>
Another one is:
Driver={Pervasive ODBC Client Interface};ServerName=myServerAddress;dbq=@dbname;

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[hlet]

Thanks for your reply!
I tried your connection string:
('Provider=MSDASQL','Driver={Pervasive ODBC Client Interface};DSN=Ridder_Read',
Now I am getting the Error:
OLE DB provider "Provider=MSDASQL" has not been registered

 

[hlet]

I searched SQL Server Manager and saw as Linked Server Provider: "PervasiveOLEDB.8.50".

STATEMENT:
'PervasiveOLEDB.8.50','DSN=Ridder_Read;ServerName=NT-SERVER.1583;ServerDSN=Ridder_Read',

ERROR:
OLE DB provider "PervasiveOLEDB.8.50" for linked server "(null)" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
OLE DB provider "PervasiveOLEDB.8.50" for linked server "(null)" returned message "Mode, Protection Level, or an unknown parameter has been set (incorrectly) in the connection string".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "PervasiveOLEDB.8.50" for linked server "(null)".

Above Statement gives above error: what's wrong?

 

[mirtheil]

Using the PervasiveOLEDB provider, the connection string is different. It would be something like:
"Provider=PervasiveOLEDB;Data Source=<dbName>;Location=<server>"


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[hlet]

Mirtheil,

Thanks for your inputs.
I solved my problem by using linked tables in an Access Database and connect to it.
This solutions gives suitable results!