Pervasive OLEDB

[not24]

I have Btrieve 6.15 Database and I saw an example how to use Pervasive OLEDB in Visual Baisc on Pervasive website but I couldn't find where to download it. Anyone know where can I get Pervasive OLEDB?

Please advice,

 

[mirtheil]

To use the PervasiveOLEDB, you need to be running Pervasive.SQL 2000i SP3 or SP4. The Btrieve v6.15 didn't, and doesn't, support the PervasiveOLEDB provider. You'll need to download the Pervasive.SQL 2000i engine (Workgroup or server) and then the SDK to get full documentation on the PervasiveOLEDB. mirtheil@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[not24]

Any other OLEDB that Btireve 6.5 support? I have a problem try to re-create DDF. I have read from this forum that if using OLEDB, I don't need DDF.

Please advice.

 

[mirtheil]

Actually, any OLEDB provider will still need DDFs. The only method for accessing Btrieve data without using DDFs would be to use the Btrieve API.
mirtheil@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[not24]

Hi mirtheil,

I fixed a problem with create DDF. If you don't mind me asking, I having a problem try to create DSN to connect Btrieve using Pervasive ODBC driver.

I filled in everything beside login script. I copied a code from Pervasive ODBC Help following this:
SET BINARYNULL = 255;SET DECIMALNULL = ' '

When I clicked OK, I've this error:
Login must succeed before data source entry can be written. (Status code: 2103)

I look at the status code detail but I do not know what they talking about. Please advice

 

[mirtheil]

Status 2103 means that the Scalable SQL engine (used by the 6.15 ODBC) is not running. Are you using Windows NT/2000/XP or Win9x? If you're on NT/2000/XP, make sure the Target Engine Settings are correct for your environment (it'll depend on the data location, the engine location, and whether you're using a workstation or server engine). If you're on Win9x, make sure the ODBC is installed correctly and that the DLLs are in the system path (this applies to NT/2000/XP too).
mirtheil@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[wliumzeng]

Hi I've got error 'Login must succeed before data source entry can be written. (Status code 20 or 802). I installed on windowsXP platform. I did not see this on Window Me. How to fix? Thanks.

 

[mirtheil]

The problem with the status 20 or the status 802 is most likely that the Btrieve ODBC thinks you've installed the server engine and can't find it. Look for a "Target Engine" setting in the HKEY_LOCAL_Machine\Software\Btrieve Technologies or HKEY_LOCAL_MACHINE\Software\Pervasive Software registry keys. The Target Engine will depend on the engine location and the data location.
If everything is local (Btrieve engine, ODBC Driver, data) and you're using the WOrkstation engine, then the Target Engine should be 0 (zero) for all entries.
Unless you're using a client server version of Btrieve or Scalable SQL, that should work. If you are using a client server Btrieve engine and you're at the server, then set the Btrieve Target Engine to 1. Set the Scalable SQL Target Engine to 0 unless you're using Scalable SQL Server engine on the same machine as the ODBC. info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician