I am currently using SQL Server 2008 R2 (64bit) on Windows 2008 server. I try to access a Pervasive database as linked server. I have created the DSN on the odbc control (32 bit). The odbc itself can access the pervasive database.
However, the connection through SQL sever failed when I create the linked server by odbc option. I am a newbie on the linked server through odbc. Could anyone indicate me the steps to create linked server for pervasive database through ODBC?
[Pervasive application has been installed on the same server] Thanks you!
View Complete Post