Pervasive connection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

has anyone tried to connect to a Pervasive database using ADO.Net?

I get a message saying cannot use an OLE DB providerfor ODBC drivers

or if I try and use SQL adapter I get "The connection you have created does not work with this adpater"

What am I doing wrong?

(Other than using a NON-Microsoft database)
 
N3WJL said:
has anyone tried to connect to a Pervasive database using ADO.Net?
Click to expand...

What version of Pervasive are you trying to talk to?

I have been unsuccessful in using either ODBC to talk to a P.SQL 7 or
earlier database server (get the same errors you did). I would guess
things work correctly if you upgrade to the latest version of their
databases and SDK, but I haven't had the chance to do that (not that our
software supports anything post-P.SQL7).

I would check out www.pervasive.com and do some research for yourself...

HTHs...

John
 
John
It looks like Pervasive will only work in VB.NET if you are using version 8
Too bad I am running version 7 (2000i) It would cost me something like $4,50
to upgraded to 8, and more like $25,000 to switch to SQL

I guess we will just stick with VB 6.0.
 
N3WJL said:
John,
It looks like Pervasive will only work in VB.NET if you are using version 8.
Too bad I am running version 7 (2000i) It would cost me something like $4,500
to upgraded to 8, and more like $25,000 to switch to SQL

I guess we will just stick with VB 6.0.
Click to expand...

If you can live with just the Btrieve interface, there is a Japanese company
that sells a .Net wrapper around that... I tried their demo briefly and it
seemed to work ok going to a P.SQL 7 database. You just lose any
resemblance to ADO.Net doing that tho... More details are on the Pervasive
web site.

For communicating with our P.SQL 7 legacy databases, I was just going to
make a web service (probably using the Delphi/Titan combination we normally
use) that allows for the specific database operations I need. We have
abandoned support for Pervasive database in our main application suite in
favor of Oracle and SQL Server backends... but we would still need to
support existing P.SQL customers with our new product tho, I need to figure
out some solution as well...

John
 
Back
Top