Buffer Error When Importing Btrieve DB with SQL Server 7 DTS

[Guest_imported]

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

 

[Linda84]

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