how to connect to pervasive sql through odbc?
6,924
Check one of provided solutions explained here or the following configuration:
Linked Server: ksalap208
Provider Name: Microsoft OLE DB Provider for ODBC Drivers
Product Name: Pervasive
Data Source: C003
Provider String: blank
Location: YOUR_SQLSERVER_NAM
Catalog: blank
Related videos on Youtube
Author by
Alex Gordon
Check out my YouTube channel with videos on Azure development.
Updated on September 18, 2022Comments
-
Alex Gordon over 1 year
I am trying to add a linked server to a sql server 2012 database using ssms 2012.
the linked server is pervasive sql. here's how i am trying to do it:
EXEC sp_addlinkedserver @server = 'kslap208', @provider = 'MSDASQL', @datasrc = 'C003', @srvproduct = 'Pervasive' GO
however when i test the connection i am getting this error msg:
what am i doing wrong? how can i link to an instance of a pervasive sql database?
here is some additional information regarding the DSN to which I am trying to connect:
-
BlueBerry - Vignesh4303 over 10 yearscould u summarize it as answer over here redirecting to link is good,but summarized answer would be great