| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Overriding the dataSourceUserId when connecting to an app db |
« View previous topic :: View next topic » |
| Author |
Message
|
| venusboy |
 Posted: Thu Feb 22, 2007 6:21 am Post subject: Overriding the dataSourceUserId when connecting to an app db |
 |
|
Acolyte
Joined: 11 Jun 2002
Posts: 51
|
I understand this may have been covered numerous times, but I was wandering if there method to connect to an application database via ODBC using a different userid.
I.e. Does Broker support the LogonID and Password within the ODBC configuration file?
So when I create a data source entry within the ODBC.ini as:
[MYDATASOURCE]
Driver=/opt/IBM/mqsi/6.0/merant/lib/UKor820.so
Description=DataDirect 5.0 Oracle
EnableDescribeParam=1
OptimizePrepare=1
ServerName=MYDATABASE
WorkArounds=536870912
ProcedureRetResults=1
LogonID=non_mqsidb_user
Password=mypassword
The broker is still using the mqsicreatebroker –u dataSourceUserId as proved by an ODBC trace.
Is there anyway to get the broker to use the LogonID from the ODBC stanza?
System Information:
• Solaris 8
• Oracle 9
• WMBv6
• DataDirect version 5
From what I remember this used to be an issue in version 2, but IBM came out with a fix in a later CSD.
Also is there a supplied tool from merant that will test the ODBC datasource issolated from the broker?
Regards,
Tom. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Feb 22, 2007 6:24 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 |
|
|
| venusboy |
| Posted: Thu Feb 22, 2007 6:37 am Post subject: |
|
|
Acolyte
Joined: 11 Jun 2002
Posts: 51
|
Jeff,
Thanks for your reply and I will give this a whirl. Is this in version 5 as well?
Thanks again, for your speedy answer.
Regards,
Tom. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Feb 22, 2007 6:40 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
pretty sure it's in v5.
but you said you were using v6.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| venusboy |
| Posted: Thu Feb 22, 2007 7:00 am Post subject: |
|
|
Acolyte
Joined: 11 Jun 2002
Posts: 51
|
Thanks Jeff, its all coming back. You are quite correct it is supported in both version 5 and 6.
Regards,
Tom. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
