Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Data type changes using ODBC...

0 views
Skip to first unread message

Strange Cat @ Work

unread,
Jun 24, 2009, 5:18:13 AM6/24/09
to
Hello everyone,

I am using Oracle ODBC to connect tables from an Oracle schema to an empty
Microsoft Access DB.

In one particular table i have a VARCHAR2 field that is 255 chars long.

This field is reported as being of MEMO type in Access, which is untrue.

Problem is that another third-party (that reads the Oracle data sw) has
problems using Memo fields.

Can anyone help me in forcing ODBC driver to report the field as TEXT in
Access, as it should be?

TIA
Paolo

Gerard H. Pille

unread,
Jun 24, 2009, 12:46:16 PM6/24/09
to
Strange Cat @ Work schreef:

Could it be that your NLS_LANG setting is referring to a multi-byte characterset? Text is max
255 characters, maybe the ODBC driver thinks you may need more.

Strange Cat @ Work

unread,
Jun 25, 2009, 4:26:38 AM6/25/09
to
> Could it be that your NLS_LANG setting is referring to a multi-byte
> characterset? Text is max 255 characters, maybe the ODBC driver thinks
> you may need more.

Thanx for answering...

I'll check with the DBA.

Problem is that I dont think they are willing to change their NLS_LANG
setting.

I wonder if there is a way to force ODBC driver to believe there is no
multi-byte charset in Oracle instance, of course without messing up the data
retrieved...

TIA
Paolo

0 new messages