I have been trying to establish a linked server on my sql server 2012 to pervasive sql v11 this way:
EXEC sp_addlinkedserver @server = 'kslap208', @provider = 'MSDASQL', @datasrc = 'C003', @srvproduct = 'Pervasive' GO
i am getting this error:
here's how I set up the DSN on the pervasive server:
what am I doing wrong? How can i get sql server to add pervasive as a linked server?
both servers are 64 bit.