By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,588 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Jet 4.0 and Regional Settings problem

P: n/a
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.


Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.



Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.