| Author |
Message
|
| Gemz |
 Posted: Tue May 13, 2008 6:03 am Post subject: [Oracle][ODBC]Optional feature not implemented. |
 |
|
Centurion
Joined: 14 Jan 2008
Posts: 124
|
Hi,
I am facing the similar problem.
| Quote: |
DatabaseException BIP2321E: Database error: ODBC return code '-1'.
The message broker encountered an error whilst executing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database pertaining to this error.
Use the following messages to determine the cause of the error. This is likely to be such things as incorrect datasource or table names. Then correct either the database or message broker configuration.
2008-05-13 13:03:22.669086 3088 DatabaseException BIP2322E: Database error: SQL State ''HYC00''; Native Error Code '0'; Error Text ''[Oracle][ODBC]Optional feature not implemented.''.
The error has the following diagnostic information: SQL State ''HYC00'' SQL Native Error Code '0' SQL Error Text ''[Oracle][ODBC]Optional feature not implemented.''
|
I am using the oracle10g as application database and WMB v6.1.
I created the DSN and mqsisetdbparms.
I am able to connect to this database using sqlplus. |
|
| Back to top |
|
 |
| broker_new |
| Posted: Tue May 13, 2008 6:09 am Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
Test the connection on the AIX box ......search for the odbc .ini file and execute ./example/example and it prompts for DSN name,userid and passwd if you are able to connect from their then you should be able to connect from Broker too
_________________
IBM ->Let's build a smarter planet |
|
| Back to top |
|
|
| mgk |
| Posted: Tue May 13, 2008 7:50 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
The message shows that you are using the Oracle ODBC driver: "''[Oracle][ODBC]". This is the wrong driver, you should use the DataDirect ones included with the product.
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| broker_new |
| Posted: Tue May 13, 2008 8:28 am Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
Follow these steps:
Oracle
When you define a data source for Oracle, choose the driver:
MQSeries DataDirect Technologies 5.00 32-BIT Oracle
The ODBC Oracle Driver Setup dialog opens.
Complete these steps to configure the driver:
On the General tab:
Enter the DSN name, description, and server name (where the server name is the "Service Name" that resolves to a "Connect Descriptor", for example through a mapping in the TSNAMES.ORA file).
Select the appropriate Oracle client version from the list.
On the Advanced tab:
Select Enable SQLDescribeParam.
Select Procedure Returns Results. The resultant ODBC definition in the Windows registry has a string value called ProcedureRetResults with the value 1.
Click Start > Run.
Type REGEDIT in the Open field.
Click OK.
Use REGEDIT to navigate to the correct location. Create a new registry subkey for each of your DSNs that reference an Oracle database.
HKEY_LOCAL_MACHINE
SOFTWARE
ODBC
ODBC.INIClick OK to close ODBC Data Source Administrator.
Right-click DSN. Select New > String Value.
Specify WorkArounds for the string.
Right-click WorkArounds.
Select Modify.
Type the data value 536870912.
_________________
IBM ->Let's build a smarter planet |
|
| Back to top |
|
|
| Gemz |
| Posted: Tue May 13, 2008 9:10 am Post subject: |
|
|
Centurion
Joined: 14 Jan 2008
Posts: 124
|
Thanks broker_new and mgk.
Its working in windows.
Now in AIX i created the odbc64.ini file as mentioned in IBM help.
| Quote: |
#######################################
#### List of data sources stanza ######
#######################################
[ODBC Data Sources]
WBRKBKDB=IBM DB2 ODBC Driver
IARDS=DataDirect 5.2 64bit Oracle Wire Protocol
SYBASEDB=DataDirect 5.2 64bit Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 5.2 64bit Sybase UTF8 Wire Protocol
SQLSERVERDB=DataDirect 5.2 64bit SQL Server Wire Protocol
INFORMIXDB=IBM Informix ODBC Driver
###########################################
###### Individual data source stanzas #####
###########################################
# DB2 stanza
[WBRKBKDB]
DRIVER=/opt/IBM/mqsi/6.1/lib/libdb2Wrapper64.so
Description=WBRKBKDB DB2 ODBC Database
Database=WBRKBKDB
# Oracle stanza
[IARDS]
Driver=/opt/IBM/mqsi/6.1/ODBC64/V5.2/lib/UKora22.so
Description=DataDirect 5.2 64bit Oracle Wire Protocol
HostName=IPADDRESS
PortNumber=1521
SID=dev
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
# Sybase Stanza
[SYBASEDB]
Driver=<Your Broker install directory>/ODBC64/V5.2/lib/UKase22.so
Description=DataDirect 5.2 64bit Sybase Wire Protocol
Database=<Your Database Name>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Your Sybase Server Name>,<Your Sybase Port Number>
SelectUserName=1
ColumnSizeAsCharacter=1
# Sybase Stanza for a UTF8 datasource
[SYBASEDBUTF8]
Driver=<Your Broker install directory>/ODBC64/V5.2/lib/UKase22.so
Description=DataDirect 5.2 64bit Sybase Wire Protocol
Database=<Your Database Name>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Your Sybase Server Name>,<Your Sybase Port Number>
SelectUserName=1
ColumnSizeAsCharacter=1
Charset=UTF8
# Unix to SQLServer stanza
[SQLSERVERDB]
Driver=<Your Broker install directory>/ODBC64/V5.2/lib/UKmsss22.so
Description=DataDirect 5.2 64bit SQL Server Wire Protocol
Address=<Your SQLServer Server Name>,<Your SQLServer Port Number>
AnsiNPW=Yes
Database=db
QuotedId=No
ColumnSizeAsCharacter=1
# Informix Stanza
[INFORMIXDB]
Driver=libinfWrapper64.so
Description=IBM Informix ODBC Driver
ServerName=<Your Informix Server Name>
Database=<Your Database Name>
##########################################
###### Mandatory information stanza ######
##########################################
[ODBC]
Trace=0 # To turn on ODBC trace set = 1
TraceFile=/data/db2odbctrace/odbctrace64.out
TraceDll=/opt/IBM/mqsi/6.1/ODBC64/V5.2/lib/odbctrac.so
InstallDir=/opt/IBM/mqsi/6.1/ODBC64/V5.2
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8 |
Do we need to set any more settings. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Tue May 13, 2008 8:31 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
just try to connect Database through command prompt and confirm its working properly
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| Gemz |
| Posted: Fri May 23, 2008 4:07 am Post subject: |
|
|
Centurion
Joined: 14 Jan 2008
Posts: 124
|
Yes, I am able to connect to database in command prompt.
In TNSNAMES.ORA we hav this database entry as
DEV=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IPADDRESS)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dev)
(SRVR = DEDICATED)
)
) |
|
| Back to top |
|
|
|
|
