Pervasive Table -> MS Access 2000 -> Make table query!!!

[twoeyes]

Hello.

I'm trying to grab some data from a Pervasive database (Accpac 4.2, to be exact).

I have linked to a Pervasive table from Access, and I can run select queries just fine. I can create a Make Table query, and preview it too (the destination being a new table INSIDE the Access database). BUT whenever I try to run the Make Table query (i.e. actually make a table!) I get the following error:

"ODBC--call failed.
[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernel or Btrieve Requester is inactive(Btrieve Error 20)(#-4979)"

At which point opening ANY linked Pervasive tables will fail.

The same error occurs when trying to Append to an Access local table from a Pervasive source.

I'm not particularly familiar with Pervasive, and all things considered, I'm lost. =) What I don't understand is why I can run (presumably) the same query in the preview, but then get an error on update/append/make table.

Lets see... I've also tried using a simple passthrough query to get all records from a table, then having a second query query the first query as the source for a make-table query. No luck either (passthrough works fine).

Some other notes: Using Workstation Pervasive 2000 everywhere, including "server". DB is remote. Access 2000. Win XP Pro. Pervasive database is in good shape, AccPac works fine. So does Access, though I haven't used it much against Pervasive db's. Generally have NOT applied service packs.

I would try applying service packs randomly, but I can't understand why there is the difference between the Preview and Run modes...

HELP! =)

Thanks in advance for any sage advice sent my way.

Check out my irrelevant personal website:

http://www.lc.yi.org

 

[TomKane]

Could it be permissions? We got that status 20 error with a different problem but the cause was that we didn't have enough access rights. What kind of files make up your pervasive database is it *.btr files? If you want to create a table there is a dos command butil -create that allows you to do this.

 

[twoeyes]

Hmm... I doubt it's permissions, but it's worth checking.
All I see are .DAT files.

I'm not trying to create a table in the Pervasive database. Really, all I'm trying to do is pull some data from the database INTO MS-Access so that I can mix it with other data sources.

Although at this point, I might have to do some stupid intermediary task like Excel, Crystal Reports, or maybe MS SQL. Maybe even parse the .dat myself if it's a text file...

I just don't understand why I can read the data, but not read the data with the intention of writing it to an internal Access table. Perhaps I'm barking up the wrong tree and this is really an Access bug...

BTW. What's the 1 sentence relationship between btreieve and Pervasive?

Check out my irrelevant personal website:

http://www.lc.yi.org

 

[TomKane]

Btrieve is the original novell version of the software and since it broke free from novell it's been rebadged as Pervasive.

There are utilities available to export date from Pervasive tables. Depending on the version you're using there are various windows utilities that are bundled in as well as some dos ones such as BUTIL. There is also a piece of shareware called btsearch - you will find the website if you search for btsearch in this forum

 

[twoeyes]

Just a followup to clean this thread up. My problem eventually cleared up. I ended up upgrading the Pervasive service pack on all the workstations, though I think the real problem was that one copy of the program was a service pack BEHIND the others. From some of the other posts on Tek-Tips, I've learned that Pervasive is VERY picky about having all concurrent users using the same SP level - probably the safe thing to do really...

Anyway, thanks again to TomKane for trying to help me out.

----------------------------------------
Check out my irrelevant personal website:

http://www.lc.yi.org

 

[mirtheil]

PRevious to Pervasive.SQL 2000i SP4, Pervasive was picky about clients and servers being at the same level but with SP4 and forward, it's not as picky.


info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[zedsded]

hello all,
currently using psql 2000i sp3, should I upgrade/update to SP4?
sorry if i sound dumb, just been very skeptic since my last upgrade.
thanx!