Contact US

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.

Students Click Here

Btrieve Error #21

Btrieve Error #21

Btrieve Error #21

We are getting a btrieve error #21 on a workstation trying to run a dos accounting app.  It has worked fine until we switched to pervasive SQL 2000.  We have the app on the netware 5.1 server with patch 2a on it.  Have SQL 2000 on the server and pervasive on the client.  We get the error when trying to close month end on an accounting app called AMSI.  Can the client or server be adjusted to alleviate this error?  I have BTRBox95 loaded also.  Also use Bdosstub loaded on the client and not BTrieve or Brequest loaded.  

RE: Btrieve Error #21

Basically Pervasive.SQL 2000 SP2a and 3 (i) enforce what's been in the developers manuals for years - that you have to set up your buffers (in this case the key buffer) correctly - but never enforced by the requesters.

21: The key buffer parameter is too short
The key buffer parameter is not long enough to accommodate the key field for the requested index path. Verify that the length of the key buffer equals the defined length of the key specified in the key number parameter.

This was necessary to address other reported issues and so the application needs to be updated by the vendor to address this. In the meantime you can probably use the Pervasive.SQL 2000 SP1 requesters which don't enforce proper key buffers until the app vendor gets you and update. Please contact Pervasive Support or Sales and explain the situation and that you need SP1 requesters for the status 21 problem and they will give you a link where you can download them to resolve this temporarily. Also please have the application vendor contact Pervasive Software so we can work with them to fix this issue.


RE: Btrieve Error #21

Btrieve Communication Error

Status Code= 91
This error comes every time i install Pervasive SQL 2000
on a workstation and the installscout does the stress test a communication test and it tries to test the sample database on the network, but it fails.

Hope to find help over here.


RE: Btrieve Error #21

1)  What protocol are you using / have you configured?

2)  What server type (NT / Novell / Linux)?

3)  What release of PSQL 2000?  (Base, SP1, SP2 or SP3 (2000i))

Usually, this is a communications error of some sort between the client and the server.  Occasionally, it is because the server is out of client sessions (check the Number of Sessions parameter on the server configuration).

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! Already a Member? Login

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