Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am having the same problem as this question.

I installed Pervasive v11 (which does have 64bit ODBC drivers) and I still do not see Pervasive listed as a provider when trying to create a linked server in SQL Server Express 2008 R2. Does anyone have any ideas what to try?

share|improve this question
add comment

1 Answer

You will need to set up a System DSN in order to connect to it using the ODBC drivers from SSMS/SQL Server - simple installing the drivers is not enough. I had to do the same in order to connect to an older instance that our company uses. Here is an excellent link that will help guide you through the process:

http://discoverysoftware.com/support/kb/acorn-docs/bridges-acorn-docs/odbc-bridges/odbc-set-up-pervasive-sql/

Once you have set up the DSN within the System Data Sources you will be able to create a linked server to it.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.