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 have a provider for a linked server called PervasiveOLEDB.11.0 installed on a sql server 2005 machine. It always me to have a connection to a pervasive sql database.

I would like to use this same provider on a sql server 2012 machine.

Is there a way to transfer this provider from the 2005 to the 2012 machine?

share|improve this question
add comment

1 Answer 1

The 'provider' is the driver required to allow SQL Server to talk to the remote server. These are normally installed pieces of software, so can't simply be copied between machines.

While not being overly familiar with PervasiveDB, I would assume that like most other manufacturers drivers, it will be included in their client release, which is available for download here - http://www.pervasivedb.com/psqlv11/pages/default.aspx

Once you've installed this, then you can build your linked server connection. Within SSMS you can right click on your existing Linked Server and make a create script which you can use on your SQL2012 instance. Though be warned that this won't copy all the security details (passwords in particular), so you may need to look this up in the documentation, or have a new user created in the target database.

Sometimes you can have issues with different versions of client software, differing client setup or not getting the permissions identical on the rebuild. You can avoid this in future (or make someone's life a lot easier in the future) by documenting everything as you set it up.

share|improve this answer
    
thank you so much for this detailed answer +1. unfortunately i did install the client and it did not add the appropriate provider. i also installed the server with the same results. pervasive needs to be kicked in the nuts. –  Yuck Feb 8 '13 at 17:13
    
Make sure that you are installing the 64bit version of the driver if you have the 64bit version of SQL Server installed (which you probably do). If they only provide a 32bit driver it isn't going to work without SQL Server also being 32bit. –  mrdenny Feb 8 '13 at 17:52
    
@mrdenny thanks so much for your reply. yes i do have both 64 bit versions –  Yuck Feb 8 '13 at 18:16
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.