language issue with DoCmd.TransferDatabase

[Amedee Van Gasse]

Hello,

One of our users reported this error:

DoCmd.TransferDatabase acLink, "ODBC Database",
"ODBC;DSN=DB2;UID=xxxxxxxx;PWD=xxxxxxxxx;DBALIAS=DB2", acTable,
"U.D604_RO", "U_D604_RO", , True

Works OK when the Office language/locale is set to English.
Fails with error "type ODBC Database niet gekend" (type ODBC Database
unknown) when the Office language/locale is set to Dutch.

I'm not familiar with Access so if anyone could please enlighten me it
would be very much appreciated.

 

[Alex Dybenko]

hi,
yes, localized access version requires localized name for "ODBC Database". I
use the following code to determine, in my case for Russian version:

On Error Resume Next
DoCmd.CopyObject 'generate an error
Select Case left(Err.Description, 1)
Case "Ð’" 'starts with Russian letter
strResult = "Базы данных ODBC"
Case Else
strResult = "ODBC Database"
End Select
Perhaps there is a better way, but this works ok for me

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Amedee Van Gasse]

hi,
yes, localized access version requires localized name for "ODBC Database".. I
use the following code to determine, in my case for Russian version:

š š š š On Error Resume Next
š š š š DoCmd.CopyObject 'generate an error
š š š š Select Case left(Err.Description, 1)
š š š š š š Case "÷" 'starts with Russian letter
š š š š š š š š strResult = "âÁÚÙ ÄÁÎÎÙÈ ODBC"
š š š š š š Case Else
š š š š š š š š strResult = "ODBC Database"
š š š š End Select
Perhaps there is a better way, but this works ok for me

Thanks, but "ODBC Database" in English is also "ODBC Database" in
Dutch.
So I think there is a different problem.

By the way, I like your style. Intentionally throwing an error to find
out the language. Kung-fu code

 

[Alex Dybenko]

hi,
then check ODBC connection string, perhaps it differs in Dutch environment

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

hi,
yes, localized access version requires localized name for "ODBC Database".
I
use the following code to determine, in my case for Russian version:

On Error Resume Next
DoCmd.CopyObject 'generate an error
Select Case left(Err.Description, 1)
Case "÷" 'starts with Russian letter
strResult = "âÁÚÙ ÄÁÎÎÙÈ ODBC"
Case Else
strResult = "ODBC Database"
End Select
Perhaps there is a better way, but this works ok for me

Thanks, but "ODBC Database" in English is also "ODBC Database" in
Dutch.
So I think there is a different problem.

By the way, I like your style. Intentionally throwing an error to find
out the language. Kung-fu code

 

[Amedee Van Gasse]

hi,
then check ODBC connection string, perhaps it differs in Dutch environment

No, it does not.

 

[Amedee Van Gasse]

No, it does not.

Today the user is back from holiday.
Does anyone have any idea how this problem could be solved?

 

[Amedee Van Gasse]

No, it does not.

OK, case closed.
When writing the full query, the user says he doesn't have the
problem.
User happy, me happy.