Btrieve->SQL error 7347 unexpected field length 1

[FGS]

I am trying to import from a Btrieve 6.15 data file (generated by Scala v5.0)using Perv ODBC 2.04, into SQL 7 sp3 via linked server. The whole process is on a desktop machine running NT4 sp6.
The imports are monthly, and worked until this month. The error was - Server: Msg 7347, Level 16, State 1, Line 1: OLE DB provider 'MSDASQL' returned an unexpected data length for the fixed-length column '[SCALADATA]...[UKOrdLnHi].OR21012_QtyShipped'. The expected data length is 12, while the returned data length is 1. I get this using DTS and with a straight select query in Query Analyzer.
I have tried to rebuild/reindex the file using the utility supplied with Scala and then reimport to no effect. I can view the data in Access, or through the Smithware DDF builder, and see no corruption, however with 600,000 records it is easy to miss something.
I do not know enough about how Btrieve stores the data to narrow down the records to review, how to resolve the error, or why it is a problem to SQL and not other programs.
Please help
Fred Stumpp
fstumpp@hotmail.com

 

[FGS]

Additional info
The problem does not occur using a DTS ODBC connection object - only using the Linked Server, even though both sources use the same DSN. Does anyone know the difference between how the ODBC connection is implemented via Linked Server vs a DTS data source connection object?
FGS

 

[Pervasivite]

I would guess that there are some problems with the metadata from Scala and so the data that is actually coming from the Btrieve files is not what SQL is expecting. You might be able to get updated DDFs from Scala or you might try something like the Data Junction tool which will go directly to the Btrieve interface which should be much more robust than using the old ODBC 2.04 drivers.

Pervasivite