Hi All,
I am working with an application built on VB5.0 connecting to a SQL 7.0 database. At present, I am installing the product at client site. The problem here is that the SQL server uses code page 850 whereas the workstations use code page 1252. One of the applications modules that we use was retrieving junk from the database as a result of this - this module uses ADO.
So, I changed the ACP value in the registry from 1252 to 850
[HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\Nls\CodePage]
"ACP"="850"
After this, things seemed fine with this workstation.
On another workstation, I made the same change in the registry, but I have a curious problem. Modules that use ODBC/DSN are working properly, whereas modules that use ADO to connect to SQL are failing - they retrieve junk.
How can I correct this problem?
Thank you all in advance!
Regards,
Venkat
I am working with an application built on VB5.0 connecting to a SQL 7.0 database. At present, I am installing the product at client site. The problem here is that the SQL server uses code page 850 whereas the workstations use code page 1252. One of the applications modules that we use was retrieving junk from the database as a result of this - this module uses ADO.
So, I changed the ACP value in the registry from 1252 to 850
[HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\Nls\CodePage]
"ACP"="850"
After this, things seemed fine with this workstation.
On another workstation, I made the same change in the registry, but I have a curious problem. Modules that use ODBC/DSN are working properly, whereas modules that use ADO to connect to SQL are failing - they retrieve junk.
How can I correct this problem?
Thank you all in advance!
Regards,
Venkat