Pervasive

I am facing a problem for couple of days. I am using Windows Service for .Net 2.0. The service is using Pervasive v.10 to get the data from third party application database Sage Timberline Office Service Management. 

I was initially perfectly able to connect to Pervsive database using OLEDB provider on X86 operating system. But when the code compiled and Pervasive SQL connection call is made, then error thrown on opening connection "PervasiveOLEDB provider is not registered on the local machine".

After quite an effort, i finally used Pervasive.Data.SqlClient.PsqlConnection and Pervasive.Data.SqlClient.dll version(3.0; which was supplied alongwith Pervasive v.10 installation) to able to open connection.

 The PervasiveOLEDB driver is 32 bit only.  Sounds like you were compiling your .NET application using the AnyCPU platform.   In that case, .NET looks for a 64 bit driver.  You would need to change the application to "x86" for the platform type.

Once you change the platform type to "x86", you'll be able to use the PervasiveOLEDB.  That being said, you'll probably have better performance using the Pervasive.Data.SqlClient.  

Thanx very much.

You saved my whole day effort which was about to go in the vain...;)