Oracle 10g ODBC

[Isa Karbstein]

Hi NG,

we are using MS-Access 2002 as a frontend for Oracle Databases versions 8i
and 10g. Now I have a problem with the connected tables of the 10g database.
In Access all text fields are shown with a wrong fieldsize. (e.g.
Varchar(10) is shown as Text(30) in Access).
The connected tables of the 8i database are correct.

I am using the Oracle ODBC driver version 9.02.00.00.

Does anybody know this problem?

Thank you for your help
Isa

[Gox]

Isa Karbstein wrote:

Hi NG,

we are using MS-Access 2002 as a frontend for Oracle Databases versions 8i
and 10g. Now I have a problem with the connected tables of the 10g database.
In Access all text fields are shown with a wrong fieldsize. (e.g.
Varchar(10) is shown as Text(30) in Access).
The connected tables of the 8i database are correct.

I am using the Oracle ODBC driver version 9.02.00.00.

Does anybody know this problem?

Thank you for your help
Isa

I had same problem like you.
You must check your database parameters with query:

select * from nls_database_pa rameters

Check parameters NLS_CHARACTERSE T and NLS_NCHAR_CHARA CTERSET.
Certainly, one of those parameters is UTF8 or UTF16. (on 10g db)

Regardless of Text(30) in Access you can NOT insert data length>10,
because you used linked table, not access table.

About UTF8, You can find more information on metalink.oracle .com

I replaced both NLS_CHARACTERSE T and NLS_NCHAR_CHARA CTERSET to
(EE8MSWIN1250) and solve my problem.

--
Gox