INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

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

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

(OP)
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

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

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.  

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

(OP)
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

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

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

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

(OP)
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

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

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

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

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!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close