Hi,

I'm completely new to pervasive/btrieve. My client asked me to develop an
application to export his btrieve 6.15 database every night to a mysql
database online.

I've installed Pervasive SQL v8.5 and have been able to look in my tables.
I've also seen all needed ddf files exist, so that's no problem at all.

Now I want to install an odbc driver to acces my data via vb.net. Can
someone help me find this driver pls ? I've been looking around and it
doesn't seem to be in the Pervasive SQL install !?


Thx in advance !

Tom

First you may want to see the other thread running around this
newsgroup: Subject: Btrieve 5.x, Novell 5.1, Pervasive, access
restricted question

While it discusses some do's and don'ts it does not really explain the
why.
If you have a Btrieve 6.15 engine (which particular version)?

The problem is that the commonly distributed 6.15 engine is
"btrieve.exe" which uses a "multi engine file sharing" arrangement to
share the data files. Basically everybody runs their own database
engine and they know how to share. That works fine for a few clients
but does not scale well. Starting with Pervasive.SQL 7 the engine no
longer knows how share in that manner. The current Pervasive
"workgroup" products are actually fully client / server under the hood
and only a single database engine actually has the database file open.

If you mix the new engine and the old engine the old engine will try
to share. If the new engine access is read only it probably will not
cause any grief, but... if the new engine does database writes, it
will not lock the file and will probably cause all kinds of problems
including locking and even more likely data file corruption.

So first, don't mix engines.

Second, the Pervasive.SQL ODBC requester is installed by default. The
only thing that should have to be done is to create the data source
for it in the Windows ODBC control panel. Just select the
"Pervasive.SQL Engine Interface". The next step would be to create
the named database that points to the DDF files.

This is of course assuming a Pervasive.SQL for Windows install.

Leonard

On Tue, 25 May 2004 08:10:59 GMT, "Tom Vervoort"
<vervoort.tom (AT) pandora (DOT) be> wrote:

Tom Vervoort wrote:

I thought P.SQL V8.5 has ADO.NET access.

I'll know for sure in a couple of days when we install P.SQL V8.5 on
our dev box!

Guy
-- --------------------------------------------------------------------
Guy Dawson I.T. Manager Crossflight Ltd
gnues (AT) crossflight (DOT) co.uk

Guy Dawson wrote:

Looking around the pervasive WWW site in the developer zone I see that
the P.SQL V8 and V8.5 update SDKs are available for download...

Guy
-- --------------------------------------------------------------------
Guy Dawson I.T. Manager Crossflight Ltd
gnues (AT) crossflight (DOT) co.uk