BTrieve varchar being truncated in Access

[AndyBear]

I have a client who's trying to pull VarChar data out of a BTrieve database into Access, but the data is being truncated after 120 characters. The field size in Access is set to 250 characters, so that shouldn't be the problem. Is there something specific we should be looking at in the source database or the ODBC driver?

The BTrieve database is a legacy system from a different vendor that the client is converting from and we're not responsible for removing the data from it so she doesn't expect me to know BTrieve, but I told her I'd see if I could find her a solution. Any help would be greatly appreciated.

 

[mirtheil]

What's the version of the Btrieve ODBC driver? Also, is Access the only tool they have to read the data? Is it cut off in other tools (like MS Query or other query tools)?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[AndyBear]

Thanks for the quick response.

I tried pulling the data into Excel using MS Query and ended up having the same problem as they had with Access. I also tried "substring(TABLENAME.FIELDNAME,110,120)" in MS Query to see if the data was available to the query but just not being displayed for some reason, and all I got was characters 110-120.

They could probably try to get it using SQL Server, but they have access limitations to that because of security concerns.

I'll see if I can find out what version of the ODBC driver they're using and let you know.

 

[mirtheil]

I created a simple table in Pervasive.SQL V8 (the current version of Btrieve) with a varchar(200) and was able to get all of the data through Access. I think the version of the ODBC driver is going to be important. The easiest way to tell is to look at the "Drivers" tab of the ODBC ADministrator (in control panel or ADministrative Tools). Look for either "Pervasive ODBC-32" or "Pervasive ODBC Client Interface" or "Pervasive ODBC Engine Interface" and give the version.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com