MQSeries.net :: View topic - Database error: ODBC return code '-1'.

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Database error: ODBC return code '-1'.

Database error: ODBC return code '-1'.

« View previous topic :: View next topic »

Author

Message

maanav_kr

Posted: Sun Feb 11, 2007 2:00 pm Post subject: Database error: ODBC return code '-1'.

Novice

Joined: 19 Jan 2007
Posts: 15

Hi,

I am connecting to Oracle database on different UNIX box than the one which broker is installed.

i am using the data source name in message flow as mentioned in TNSNAMES.ORA

i ran

Code:

mqsisetdbparms <broker> -n <oracle_db_servicename> -u <db_id> -p <db_pwd>

edited .ODBCINI file

Code:

[ORACLEDB]
Driver=/opt/IBM/mqsi/6.0/merant/lib/UKor820.so
Description=DataDirect 5.0 Oracle
EnableDescribeParam=1
OptimizePrepare=1
ServerName=<oracle_db_servicename>
WorkArounds=536870912
ProcedureRetResults=1

In mqm user profile i am have to export ORACLE_HOME and then login as :

Code:

sqlplus /nolog

SQL> connect <db_id>/<db_pwd>@<oracle_db_servicename>

Problem is message goes to error queue, select from database statement fails.

Trace says :

Code:

DatabaseException BIP2321E: Database error: ODBC return code '-1'.
The error has the following diagnostic information: SQL State ''78'' SQL Native Error Code '0' SQL Error Text ''523 76''

What did I miss?

Lillian

Posted: Wed Feb 14, 2007 3:13 am Post subject:

Centurion

Joined: 15 Apr 2002
Posts: 102

any progress on this? i have the same error

gregop

Posted: Wed Feb 14, 2007 3:40 am Post subject:

Voyager

Joined: 24 Nov 2006
Posts: 81

Quote:

i am using the data source name in message flow as mentioned in TNSNAMES.ORA

If I understand correctly you have used oracle_db_servicename in message flow and mqsisetdbparms command.

You should be using DSN = The DSN Stanza in .odbc.ini. You have used ORACLEDB so that should be the DSN used in your message flows and on mqsisetdbparms command.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Database error: ODBC return code '-1'.

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP