Porting Application using SQL-Toolkit from NT to XP

[markus kossmann]

We have to port one application which is running under NT to XP. This application uses SQL-Toolkit 2.0.5 and the NI provided dbase ODBC drivers. These ODBC drivers a no longer provided with the current version of SQL-Toolkit. So we did switch to the Microsoft Dbase driver for ODBC.

But that causes one problem: The Microsoft driver seems to use the system settings to decide what codepage for character data has to be used, the old driver seems to use another ( fixed ?) codepage. Is there documentation, which codepage was used by the NI ODBC drivers and is there a way to setup the Microsoft ODBC drivers to use that  codepage from within our Labwindows source code ?

[RobertH]

hello markus,

i have some more questions on the issue:
- Are any other characters affected besides 0xa7?
- Does regular ASCII work? (the first 127 characters)?
- Is it the native ODBC driver from Windows or an additional one?
- What code pages are set for Windows?
- Is the binary itself being changed or is it just being interpreted incorrectly?

regards,

robert h
NI germany

[markus kossmann]

- Are any other characters affected besides 0xa7?

- Is the binary itself being changed or is it just being interpreted incorrectly?
A quick test shows that at least german umlauts are also affected.  If you save a string into the ( dbase ) database and then open it with an editor you will find the string as is in the database  when using the old NI drivers on NT  but you will see some translation on non ASCII characters done using the  Microsoft drivers on XP . So you will will get only problems if you write with the old driver and read with the new driver or vice versa.   

- Does regular ASCII work? (the first 127 characters)?

Seems to work . But I didn't test all ASCII characters.

- Is it the native ODBC driver from Windows or an additional one?.

It's the driver which which is called in the ODBC control panel "Microsoft dBase Driver 4.00.6304 Microsoft Corporation ODBCJT32.dll 4.8.2004 "
- What code pages are set for Windows?

I'am not quite sure where to lookup the settings for codepages.  Is it in the control panel ? Then I did overlook it.

I'm using a standard german language setup.