| Author |
Message
|
| alma |
 Posted: Sat Feb 12, 2011 4:27 am Post subject: ODBC error |
 |
|
Apprentice
Joined: 26 Jan 2011
Posts: 36
|
Hi Everyone,
I'm again stuck in the beauties of message broker.
I'd like to connect to an Oracle schema but it always gives me this error message:
| Quote: |
| Text:CHARACTER:[DataDirect][ODBC Oracle driver][Oracle]ORA-01017: invalid username/password; logon denied |
I have read through MQSeries forum, Internet but they couldn't help me.
This is my odbc32.ini:
| Quote: |
[ODBC Data Sources]
BRKDB= IBM DB2 version 9 ODBC Driver
TESTCONN=DataDirect 5.3 Oracle Driver
###########################################
###### Individual data source stanzas #####
###########################################
# BRKDB stanza
[BRKDB]
Driver=/opt/ibm/db2/V9.1/lib32/libdb2.so
Description=BRKDB DB2 ODBC Database
Database=BRKDB
[TESTCONN]
Driver=/opt/ibm/mqsi/6.1/ODBC32/V5.3/lib/UKor823.so
Description=DataDirect 5.3 Oracle Driver
EnableDescribeParam=1
OptimizePrepare=1
Database=TESTDB
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
EnableNcharSupport=1
##########################################
###### Mandatory information stanza ######
##########################################
[ODBC]
# To turn on ODBC trace set Trace=1
Trace=1
TraceFile=/home/shatvani/odbctrace32.out
TraceDll=/opt/ibm/mqsi/6.1/ODBC32/V5.3/lib/odbctrac.so
InstallDir=/opt/ibm/mqsi/6.1/ODBC32/V5.3
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8
|
TESTDB is in the tnsnames.ora.
I have alredy run mqsisetdbparms DEVBK -n TESTCONN -u TESTUSER -p TESTPASS however I can't get through the above-mentioned error message.
 Help me, please. |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Sat Feb 12, 2011 6:23 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| The user name and password are wrong, or the mqsisetdbparms command is not in effect. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sat Feb 12, 2011 6:25 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Are user and password really uppercase? Remember case matters.
Can you connect using SQL PLUS from the broker box?
If yes do you need to specify the schema name, or is it implied for the user?
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| alma |
| Posted: Sat Feb 12, 2011 6:50 am Post subject: |
|
|
Apprentice
Joined: 26 Jan 2011
Posts: 36
|
I checked the tnsnames.ora, odbc32.ini, compute node datasource parameter, queue manager channel name, listener port about 20 times and I delete and rerun mqsisetdbparams a lot os times. I can connect to database with this user and password.
I did these on Windows XP and CentOS.
I close to a breakdown
I thing it could be a silly errata or I made a mistake at message broker setup. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sat Feb 12, 2011 7:01 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| alma wrote: |
I can connect to database with this user and password.
I did these on Windows XP and CentOS.
I am close to a breakdown
I thing it could be a silly errata or I made a mistake at message broker setup. |
But can you connect to the DB from the broker box with the user and password specified in mqsisetdbparms?
In the mqsisetdbparms are your username and passwd in the right case?
Do you need to specify a DB schema in your setup, or is it implied for the user? Does the user have permissions to the DB schema you are trying to access?
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| alma |
| Posted: Sat Feb 12, 2011 7:38 am Post subject: |
|
|
Apprentice
Joined: 26 Jan 2011
Posts: 36
|
Yes, I can connect to database from broker toolkit.
Yes, username and password are in the right case, so I tried the username and password of database administrator with the same effect.
The database of broker is DB2 and I want to connect to a remote ORACLE instance.
It is so interesting because I could connect to it from another MB Toolkit on another XP.
Now I try to do the whole story from the biginning (setup Red Hat, setup DB2, ...),
maybe I find out where is the mistake.
Thank you for all the answers.
 |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Sat Feb 12, 2011 10:00 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| alma wrote: |
The database of broker is DB2 and I want to connect to a remote ORACLE instance.
|
Well, I'd check the odbc.ini params. It seems to me that the ORacle bits are not defined to connect to a remote DB.
There is the host address/name and the remote DB Listener Port defined?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| alma |
| Posted: Sat Feb 12, 2011 1:35 pm Post subject: |
|
|
Apprentice
Joined: 26 Jan 2011
Posts: 36
|
Dear smdavies99,
You was right, the error was caused by odbc32.ini.
I wrote ServerName insted of Database in the odbc32.ini and
the authentication error disappeared.
Thank you very much.
 |
|
| Back to top |
|
|
|
|
