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

Oracle 10g ODBC

P: n/a
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
Share this Question
Share on Google+
1 Reply


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