Search results for query: *

Yes I've got ALTER table to work now with SP3 installed. You can't use UPDATE on a system table it seems.

jbrowne: You're ahead of me, I'll let you know.

If you've got Pervasive.SQL 2000 then you can download the SDK developer kit from www.pervasive.com (or http://developer.novell.com/ndk/psqlsdk.htm - scroll down page) which installs ADO capability, and you can now download the SP3(80MB) which also provides ADO capability without the SDK. The...

I'm wanting to link tables from various DBs to one combined DB without using the PCC. I tried using an SQL statement via an ADO connection through an ODBC DSN, but this caused an error which said "you are not authorised to perform this operation". The SQL syntax was: UPDATE X$File SET...

I'm wanting to link tables from various DBs to one combined DB without using the PCC. I tried using an SQL statement via an ADO connection through an ODBC DSN, but this caused an error which said "you are not authorised to perform this operation". The SQL syntax was: UPDATE X$File SET...

Solved with the Release version of SP3

Correction: The error message appears when a table is selected for linking, or when I try to open a previously linked table.

I've installed SP3 for Pervasive.SQL 2000 so that I can use ADO with VB6. The ADO connection was successful; linking .mkd files eg from the Demodata DB, to an Access mdb file via ODBC is OK; but and linking Btrieve .dat files to an mdb is ok until I try to open a table, Access says "The MS...

I've now installed Pervasive's SP3 Beta which has given me ADO capabilities, however it has upset my ODBC connection to .dat files. I guess the ActiveX comes with the SDK.

Where do I get the Pervasive ActiveX file do it come with the standard Pervasive installation, and do you know what its called? Thanks for responding.

I can access the Pervasive/Betrieve databases from Visual Basic by using the Pervasive ODBC driver. But if I want to use a direct connection using ADO is the only option to install the SDK?

We have a customer who requires Crystal Reports for general reporting for which the Standard edition would be appropriate, probably 1 license required. However we are developers and our application for the same customer is required to interface with CR using Visual Basic.<br><br>Should we by one...