Easy way to access a Pervasive database?

[Guest]

Does anybody have a sample I could see of a simple way to access Pervasive in Visual Studio?

 

[William Ryan eMVP]

If your goal is to access a Pervasive DB with ADO.NET you can definitely do
it.

You can access it through either OleDb or Odbc.
http://www.connectionstrings.com/ has an example of using both under the
'Pervasive' section.

You can also install the drivers and then just set up a DSN.

However, from the wording of your question, I think you may be asking how to
get a pervasive DB to appear in visual Studio's server explorer.

I believe that if you aren't using Standard Edition of VS that you can do
it, but I haven't done it personally. To the best of my knowledge, the ODBC
for Pervasive drivers aren't installed on a machine by default but once you
load them you can definitely set up a DSN and you can definitely access a
pervasive db (I've done this personally so I know it's doable) through
ADO.NET. And from the way server explorer works I'd be shocked if you
couldn't add a pervasive DB to it once you have the drivers/dsn installed.

HTH,

Bill

Does anybody have a sample I could see of a simple way to access Pervasive

in Visual Studio?

 

[John Beyer]

If your goal is to access a Pervasive DB with ADO.NET you can definitely do
it.

You can access it through either OleDb or Odbc.
http://www.connectionstrings.com/ has an example of using both under the
'Pervasive' section.

You can also install the drivers and then just set up a DSN.

However, from the wording of your question, I think you may be asking how to
get a pervasive DB to appear in visual Studio's server explorer.

I believe that if you aren't using Standard Edition of VS that you can do
it, but I haven't done it personally. To the best of my knowledge, the ODBC
for Pervasive drivers aren't installed on a machine by default but once you
load them you can definitely set up a DSN and you can definitely access a
pervasive db (I've done this personally so I know it's doable) through
ADO.NET. And from the way server explorer works I'd be shocked if you
couldn't add a pervasive DB to it once you have the drivers/dsn installed.

You need to qualify this by stating "If you are using a fairly recent
version of Pervasive"...

You are pretty much out of luck using ADO.Net if you are attempting to
access a P.SQL v7 or earlier server/database... There is no OLEDB driver and
their ODBC driver for those versions do not support everything that is
needed for the Odbc mechanism of ADO.Net (it gives an error immediately).

I have not tried importing the ADO COM object and using that method of
accessing Pervasive yet tho... That is probably about the only mechanism
that might still work for the older versions...

If you are using P.SQL2000 or later, I'm sure there are examples of using it
with .Net on Pervasive's web site...

HTHs,

John Beyer

 

[William Ryan eMVP]

John:

Thanks for the clarification. My experience with Pervasive is limited to
2000 and I shouldn't have assumed other versions would work too. Thanks for
the heads up.

Bill

 

[Frans Bouma]

Does anybody have a sample I could see of a simple way to access
Pervasive in Visual Studio?

You can use OleDb of course, or wait for their .NET provider which
goes in beta soon.

FB

 

[Guest]

You can use OleDb of course, or wait for their .NET provider which
goes in beta soon.

Hi Frans,

do you have any more information about the pervasive .Net provider, like

who develops it?

is it open source or actually a commercial project?

can I download the beta?

any plans to write an application block for this. I have read about
application blocks being made for the firebird database.

cheers

martin.

 

[Frans Bouma]

Hi Frans,

do you have any more information about the pervasive .Net provider, like
who develops it?
is it open source or actually a commercial project?
can I download the beta?

All I can say is that it will go in beta soon.

any plans to write an application block for this. I have read about
application blocks being made for the firebird database.

When the beta is released we've planned to support Pervasive in our
O/R mapper. I haven't heard of any other tools who're going to support it.

FB