469,336 Members | 6,100 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,336 developers. It's quick & easy.

Oracle 10g ODBC

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

Feb 13 '06 #1
1 2603
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_parameters

Check parameters NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET.
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_CHARACTERSET and NLS_NCHAR_CHARACTERSET to
(EE8MSWIN1250) and solve my problem.

--
Gox
Feb 13 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by SerGioGio | last post: by
13 posts views Thread by Chris Botha | last post: by
1 post views Thread by Crazy Cat | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Marylou17 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.