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 22

Btrieve Error 22

Btrieve Error 22

In Pervasive 10.3 my INSERT script gives error

Pervasive.Data.SqlClient.Lna.k: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The data buffer parameter is too short(Btrieve Error 22)

How do I fix this ?

RE: Btrieve Error 22

Sounds like your DDFs may not match the data file. Are the data files / DDFs from a third party application? If so, make sure the DDFs are correct and accurately describe the data files.
The status 22 is caused when a buffer specified is smaller than the Engine expects. If a field in the DDF is defined as a 100 byte character field but the Btrieve file defines a record of less than 100 bytes, the status 22 can occur.

Certified Pervasive Developer
Certified Pervasive Technician

RE: Btrieve Error 22

How do I make sure the DDFs are correct and accurately describe the data files? When I insert a record do I have to assign values to all fields in a table?

RE: Btrieve Error 22

You only have to specify values for fields that are defined "NOT NULL".
You can use the "Check Database" function in the DDF Builder tool to check the database. Here's a link to docs for v11 but they should apply for v10 too:

Certified Pervasive Developer
Certified Pervasive Technician

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