Interesting Connection and Locale Identifier problem

[Aras Kucinskas]

Hi All,



My app connects to FoxPro DB via FoxPro OLE DB provider and retrieves not EN
data and populates it to datagrid. Connection string is like:



\\Server\DATA;Provider=VFPOLEDB.1;Locale Identifier=1063



The first request performs well and charecters in datagrid is in right
encoding (1063 locale). Every next request populates data in wrong encoding
and some characters are not readable. When I restarts app the problem
repeats. Locale property is set right on typed dataset, which is data source
for grid.



What is the core of the problem?

 

[Mohamoss]

Hi
This might be a wild guess here but may be it work, try to keep one
connection opened may be this is why you see that , in the connection
string add pooling='false' so what happen at the first time happens every
time.
hope that help
Mohamed Mahfouz
MEA Developer Support Center
ITworx on behalf of Microsoft EMEA GTSC

 

[Aras Kucinskas]

Thank You for solution, but it does not solve the problem.
I disabe all OLE DB services in connection string with "OLE DB Services
= -1;", but the problem persists!

 

[Aras Kucinskas]

Sorry, I mean "OLE DB Services = 0".