Author |
Message
|
vishnurajnr |
Posted: Wed Oct 12, 2011 7:34 am Post subject: Optional feature not implemented. |
|
|
 Centurion
Joined: 08 Aug 2011 Posts: 134 Location: Trivandrum
|
Hi
Iam facing an issue in MB6.1 broker while accessing Oracle databse.
Iam accesing an oracle table with column having datatype as NCHAR.
Iam getting an ODBC exception when fetching this NCHAR Datatype columns and iam able to access other columns of the same Table successfully.
Kindly advice.
(Altering the table with cloumn datatypes to VARCHAR will work, But I would like to know if there is any way other than changing the table) |
|
Back to top |
|
 |
mqjeff |
Posted: Wed Oct 12, 2011 7:45 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
If I were facing this problem, I would perform the following steps.
- review the error message for more information about the problem.
- review the documentation on the error message for more information about the problem.
- review the documentation on configuring an ODBC data source for Oracle
- review the documentation on ODBC <-> ESQL data type mappings
|
|
Back to top |
|
 |
MrSmith |
Posted: Wed Oct 12, 2011 8:11 am Post subject: |
|
|
 Master
Joined: 20 Mar 2008 Posts: 215
|
From the help text
Quote: |
Support for Unicode and DBCS data in databases
You can manipulate Unicode Standard version 3.0 data, in suitably configured databases, using ESQL, in nodes that access databases by ODBC. The broker does not support DBCS-only columns in tables that are defined in databases.
The broker does not, therefore, support certain data types, including the following types:
GRAPHIC, VARGRAPHIC, LONGVARGRAPHIC, DBCLOB (on DB2®)
NCHAR, NVARCHAR, NVARCHAR2, NCLOB (on Oracle)
NCHAR, NVARCHAR, NTEXT, UNICHAR, UNIVARCHAR (on Sybase)
NCHAR, NVARCHAR (on Informix®)
Support for Unicode is available only for the generally-supported versions of the following database managers:
IBM® DB2 v9 for Windows, Linux, UNIX, and z/OS® operating systems.
Oracle
Microsoft SQL server
Sybase Adaptive Server Enterprise (ASE)
|
_________________ -------- *
“Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.” |
|
Back to top |
|
 |
vishnurajnr |
Posted: Mon Oct 17, 2011 8:53 pm Post subject: |
|
|
 Centurion
Joined: 08 Aug 2011 Posts: 134 Location: Trivandrum
|
Hi,
Thanks for your reply.
We have an Option at ODBC Driver level to enable N-CHAR support.
I have done that in WINDOWS system and is working fine.
And I would like to know wether the same functionality is available in UNIX ODBC Driver level |
|
Back to top |
|
 |
lancelotlinc |
Posted: Tue Oct 18, 2011 4:29 am Post subject: |
|
|
 Jedi Knight
Joined: 22 Mar 2010 Posts: 4941 Location: Bloomington, IL USA
|
vishnurajnr wrote: |
Hi,
Thanks for your reply.
We have an Option at ODBC Driver level to enable N-CHAR support.
I have done that in WINDOWS system and is working fine.
And I would like to know wether the same functionality is available in UNIX ODBC Driver level |
Did you ask your DBA this question? What was her answer? _________________ http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
Back to top |
|
 |
vishnurajnr |
Posted: Wed Oct 19, 2011 2:28 am Post subject: |
|
|
 Centurion
Joined: 08 Aug 2011 Posts: 134 Location: Trivandrum
|
Added one line in the ocbc.ini file of Broker server
"EnableNcharSupport=1"
So it is working now  |
|
Back to top |
|
 |
MB Developer |
Posted: Wed Oct 01, 2014 1:37 am Post subject: |
|
|
 Disciple
Joined: 03 Feb 2014 Posts: 179
|
Hi vishnurajnr,
Greetings ...
How to set EnableNcharSupport=1.
Please give me steps for this.
WMB 8.0.0.4,
Oracle Express.
I have facing some problem when try to Select * from table.....
command.
Please find this Link _________________ Thanks.... |
|
Back to top |
|
 |
vishnurajnr |
Posted: Thu Oct 02, 2014 6:34 am Post subject: |
|
|
 Centurion
Joined: 08 Aug 2011 Posts: 134 Location: Trivandrum
|
In Windows, you go to the Control Panel--> Administrative Tools --> ODBC Data Sources--> System DSN-->Double click your Oracle DSN--> Advanced Tab-->Click on the box 'Enable N-CHAR Support' . Apply and OK.
In UNIX, type 'vi $ODBCINI' and go to your DSN Properties line and add EnableNcharSupport=1 at the end in new line. save it and close it.
Cheers...
(The admins might scold you for reopening this old thread) |
|
Back to top |
|
 |
Vitor |
Posted: Thu Oct 02, 2014 6:40 am Post subject: |
|
|
 Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
|
vishnurajnr wrote: |
Cheers...
(The admins might scold you for reopening this old thread) |
As it's directly relevent, and a direct attempt to reach you, it'll slide just this once.....
 _________________ Honesty is the best policy.
Insanity is the best defence. |
|
Back to top |
|
 |
MB Developer |
Posted: Sun Oct 05, 2014 9:02 pm Post subject: |
|
|
 Disciple
Joined: 03 Feb 2014 Posts: 179
|
Hi vishnurajnr,
Thanks ... I already completed ... _________________ Thanks.... |
|
Back to top |
|
 |
|