Jet 4.0 and Regional Settings problem

[John Smith]

Hi, I hope somebody can help here.

I have an app. that uses both MS Access 2000 and SQL Server databases
running under XP and 2003 server.

The problem I have encountered during testing was that if I changed the
Regional & Language settings to 'Mongolian (Cyrillic)', all Access queries
fail, however the SQL server ones continue to work fine. I thought it was my
code but apparently not so.

I tried the following test code in VB 6 with the Northwind Database:

Dim oRS as New ADODB.Recordset

oRS.Open "SELECT * FROM Suppliers", Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=D:\Documents and Settings\SeanF\Desktop\NWIND.MDB;Persist Security
Info=False

I get a run time error:

-2147217865 (80040e37) The Microsoft Jet database engine could not find the
object 'HomePage'. Make sure the object exists and that you spell its name
and the path correctly.

If I query the Orders or Customers table the same type of error message is
generated. Once I switch the locale to English (United States) it works as
expected. I initially thought it was failing because of the Cyrillic context
however the same thing happens if I switch the local to Zulu and a few other
non-Cyrillic based locales. Latin based language locales all seem to work
fine.

Can anyone offer any advice on how to deal with this? It certainly looks
like a Jet 4.0 specific issue. I intend to release my product to the world
market and this seems like a major problem to me.

I have tested this with the following configurations:

Windows XP (SP1 & SP2)

Windows Server 2003

Visual Basic 6.0 using MDAC 2.5, 2.6, 2.8

Jet 4.0 SP3 & SP8

Any help appreciated.

-Sean.

[David Schofield]

Hi
excuse my top-posting on this one.
Michal Kaplan is the expert on this sort of thing, you might start by
looking at his web site
www.trigeminal.com/
David
On Thu, 6 Jan 2005 22:49:02 +1300, "John Smith" <jo**@internet.com>
wrote:

Hi, I hope somebody can help here.

I have an app. that uses both MS Access 2000 and SQL Server databases
running under XP and 2003 server.

The problem I have encountered during testing was that if I changed the
Regional & Language settings to 'Mongolian (Cyrillic)', all Access queries
fail, however the SQL server ones continue to work fine. I thought it was my
code but apparently not so.

I tried the following test code in VB 6 with the Northwind Database:

Dim oRS as New ADODB.Recordset

oRS.Open "SELECT * FROM Suppliers", Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=D:\Documents and Settings\SeanF\Desktop\NWIND.MDB;Persist Security
Info=False

I get a run time error:

-2147217865 (80040e37) The Microsoft Jet database engine could not find the
object 'HomePage'. Make sure the object exists and that you spell its name
and the path correctly.

If I query the Orders or Customers table the same type of error message is
generated. Once I switch the locale to English (United States) it works as
expected. I initially thought it was failing because of the Cyrillic context
however the same thing happens if I switch the local to Zulu and a few other
non-Cyrillic based locales. Latin based language locales all seem to work
fine.

Can anyone offer any advice on how to deal with this? It certainly looks
like a Jet 4.0 specific issue. I intend to release my product to the world
market and this seems like a major problem to me.

I have tested this with the following configurations:

Windows XP (SP1 & SP2)

Windows Server 2003

Visual Basic 6.0 using MDAC 2.5, 2.6, 2.8

Jet 4.0 SP3 & SP8

Any help appreciated.

-Sean.