Search results for query: *

I'm using Pervasive SQL 2000i as the back end for a 3rd party leasing program. I've been writing crystal reports to replace some old reports written against the transactional engine. The problem were having is when querying some large tables, (7 million rows) Crystal hangs. Normally I would...

You should be able to do this no problem. Pervasive has ODBC drivers that you can use to link tables to Access. As far as I know you shouldn't have any licensing issues either. One warning though, when we upgraded to Pervasive SQL2000 our existing Access queries got so slow they were...

The biggest difference is $$$$. If SQL Server wasn't so expensive Pervasive would not exist. We have both here and SQL Server is more reliable and easier to use the Pervasive. I hate to say it cause MSFT is so evil, but that's the truth.

Do yourself a favor and stay away from Pervasive. I'm forced to use it because another product used Pvs2000i as it's backend and it's been nothing but headaches. I know the Btrieve API is fast, but isn't the point of a database to use SQL?!?! I don't want to learn a new API to get at my data...

You need to set the recordset equal to the command.execute method i.e. Set rs=cmd.execute

You might want to try setting the Mode property of your connection object to Read/Write---> objConn.Mode=adModeReadWrite I've run into similar problems with other databases. Not sure if this will fix your Access problem, but if it defaults to ReadOnly you can't do inserts.

The .exe file is just your complied code. It doesn't include any code from ActiveX controls or DLL's you might have referenced. If you're using ADO or other libraries the Wizard will include the entire MDAC in your setup program, thus bloating it. It also will include the VB runtime DLL...

Thanks for the tip. We downloaded the DataDirect ODBC Connect 4.1 driver and it worked fine right away. I told the Pervasive tech support people about it, but since we're using Access to run the query they said they couldn't help. You'd think they'd test out their own driver with a product as...

My firm recently migrated from Pervasive SQL7 to 2000. Some of our user use Access 97 to run ad-hoc queries against the DB. With SQL 7 we were using the DataDirect(Merant) v.3.5 ODBC driver. With 2000 we are using the Pervasive 32-bit Client Interface. A query that would take 5 minutes...