×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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

Buffer Error When Importing Btrieve DB with SQL Server 7 DTS

Buffer Error When Importing Btrieve DB with SQL Server 7 DTS

Buffer Error When Importing Btrieve DB with SQL Server 7 DTS

(OP)
I'm trying to import a number of tables from a Btrieve DB into an SQL Server 7 DB using DTS. I seem to be able to make and ODBC connection to the Btrieve DB but the import fails immediately after it starts copying data to the newly created table in SQL Server. The error I receive reads:

"Error at Source for Row number 2870. Errors encountered so far in this task: 1. Unspecified error

[Maximizer][ODBC Driver][Btrieve Database]Buffer is too small."

Now the the Pervasive Server's Communication and MKDE buffer sizes are set to about 64500 B of a maximum 65000 B.
The Read buffer size is set to about 64000 B out of a maximum of 65500 B. The table I'm trying to import is only about 29000 rows and I have no problem importing it into MS Access 2000 and then importing it into SQL Server from there. The ODBC driver I'm using is a Maximizer ODBC Driver from Multiactive Software.

Is this truly a buffer error? Could it be an ODBC error?

Thanks in advance!
Cam

RE: Buffer Error When Importing Btrieve DB with SQL Server 7 DTS

Most likely, you have a Btrieve file with a corresponding DDF definition that doesn't quite match.  To check this, go into PCC, right click on your database, and select Tasks/Check Database.  Do a Consistency test on the table you're trying to export, and see if there are any errors.

You can also try going into PCC and start up a SQL Data Manager window and issue: SELECT * FROM <Tbl>
for the table you're trying to export.  Do you get any errors scrolling through the data?  Or, you can right-click on the database icon in PCC and select Tasks/Export and try a straight ODBC export (without Access and SQLServer being in the picture).

Linda
Pervasive Software Support

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