5

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:

enter image description here

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:

enter image description here

Improve this question

1 Answer 1

Reset to default
2

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

Improve this answer
1
  • could u summarize it as answer over here redirecting to link is good,but summarized answer would be great
    – BlueBerry - Vignesh4303
    Oct 30, 2013 at 12:48

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .