| Author |
Message
|
| harish6185 |
 Posted: Wed Mar 05, 2008 7:29 am Post subject: problem with ODBC connection for a specific database |
 |
|
Novice
Joined: 05 Mar 2008
Posts: 16
|
Hi all,
I have a problem with ODBC connection.
below are the details:
When a XML message is passed from the broker server to database i am getting the error
[DataDirect][ODBC Oracle driver][Oracle]ORA-01017: invalid username/password; logon denied
However, when we use SQLPlus from the broker server, we can access the data with the same ID and password.
but if we change the database server name in .odbc.ini file it is working fine with the same user id and password with the changed database.
Infact it used to work earlier with both the databases but all of a sudden it is working only with one database now.
Could anyone please explain why it is not working with first database?
thank you in advance |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Mar 05, 2008 7:36 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
mqsisetdbparms
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| harish6185 |
| Posted: Wed Mar 05, 2008 7:56 am Post subject: |
|
|
Novice
Joined: 05 Mar 2008
Posts: 16
|
thanks for replying.
i am new to MQ, so could you please explain me where to pass that command?  |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Mar 05, 2008 8:08 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
It's not an MQ command.
If it was an mq command, it would not start with "mqsi".
It's a Broker command.
All of the Information you need to know about how and why to use this command is in the Broker Information Center.
Happy Reading.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| harish6185 |
| Posted: Wed Mar 05, 2008 8:28 am Post subject: |
|
|
Novice
Joined: 05 Mar 2008
Posts: 16
|
thank you for quick reply.
i have searched for more on that command on net and i found the following syntax.
>>-mqsisetdbparms--brokername-- -n --DataSourceName------------->
>-- -u --DataSourceUserId-- -p --DataSourcePassword------------><
and i also found that this command has to be passed only after stopping the broker.
could you please tell me what exactly DataSourceName refers here?
and could you also please confirm whether this is the correct syntax?
thank you in advance |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Wed Mar 05, 2008 11:00 am Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
|
| Back to top |
|
|
|
|
