Problems with linking to Foxpro tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My company has decided to finally upgrade from Office 97 to Office 2003, which probably mainly is a good thing.

However, I get horrible problems with applications containing table links to an old Foxpro-based application, since the links use the old ISAM routine.

So I created an ODBC data source, which works excellently except for various national characters that are no longer displayed correctly (they mainly seem to be replaced with other weird characters, but sometimes are not displayed at all). This happens regardless of what collating sequence I choose.

Reading the tables as dBase III/IV ISAM files works fine, national characters and all, except for the two tables that contain Memo fields.

Modifying or upgrading the Foxpro application in any way is not an option at the moment.

I'm fine with using ODBC if anyone knows how to get around the national character issue. Does anyone here know how?

Henrik
 
Hi Cindy,

thank you for replying.

I already tried using the Visual Foxpro ODBC driver. Then I got the issue
with national characters I mentioned. National characters entered and
displayed correctly in the DOS-based Foxpro application somehow get
translated to other national characters in Access.

Now, this is most probably some NLS/code page issue, but as far as I can see
the driver does not allow me to select what code page to use. I can select
the collation order, but that doesn't seem help at all.

The dbase ISAM driver as well as the old Foxpro ISAM driver handles any
national characters I throw at them completely flawlessly.

I got a couple of ideas for a solution, but don't know how to implement them.

One would be to install the old Foxpro ISAM driver in a XP/Office 2003
environment, íf it's possible at all. I don't know how to do this or if it's
possible at all.

The other would be if there is a way to tell the ODBC driver what code page
the Foxpro application uses, so it can handle the character translation
correctly. I don't know how to do this or if it is possible.

Best regards,
Henrik
 
Back
Top