| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| DSN names in odbc.ini |
« View previous topic :: View next topic » |
| Author |
Message
|
| srikanthc60 |
 Posted: Fri Apr 15, 2016 1:21 am Post subject: DSN names in odbc.ini |
 |
|
Voyager
Joined: 21 Jul 2013
Posts: 79
|
Hi All,
While adding new Data source entries in broker odbc.ini file, does it really matters specifying the DSN in uppercase or Lowercase?
For Eg, I want to add ABCDSN entry for Oracle, Does it make any difference if I use all uppercase or lowercase or mix of both?
ABCDSN or abcdsn or ABCdsn ?
[ABCDSN] or [ABCdsn] or [abcdsn]
Driver=<PATH>
Description=<DESC>
HostName=xxxxxxxxxxxxxxxxxx
PortNumber=1625
ServiceName=abcdsn
and while associating a username ,password for this DSN, which of the below command i need to use? Or Do I need to use the service name(bold one above) while associating username/password?
mqsisetdbparms BROKER -n ABCDSN -u user -p abcdef
(or)
mqsisetdbparms BROKER -n ABCdsn -u user -p abcdef
(or)
mqsisetdbparms BROKER -n abcdsn -u user -p abcdef
Thanks in advance!!!!
 |
|
| Back to top |
|
 |
| maurito |
| Posted: Fri Apr 15, 2016 3:27 am Post subject: Re: DSN names in odbc.ini |
|
|
Partisan
Joined: 17 Apr 2014
Posts: 358
|
| srikanthc60 wrote: |
Hi All,
While adding new Data source entries in broker odbc.ini file, does it really matters specifying the DSN in uppercase or Lowercase?
For Eg, I want to add ABCDSN entry for Oracle, Does it make any difference if I use all uppercase or lowercase or mix of both?
ABCDSN or abcdsn or ABCdsn ?
[ABCDSN] or [ABCdsn] or [abcdsn]
Driver=<PATH>
Description=<DESC>
HostName=xxxxxxxxxxxxxxxxxx
PortNumber=1625
ServiceName=abcdsn
and while associating a username ,password for this DSN, which of the below command i need to use? Or Do I need to use the service name(bold one above) while associating username/password?
mqsisetdbparms BROKER -n ABCDSN -u user -p abcdef
(or)
mqsisetdbparms BROKER -n ABCdsn -u user -p abcdef
(or)
mqsisetdbparms BROKER -n abcdsn -u user -p abcdef
Thanks in advance!!!!
|
You can try it and see what happens. Execute the mqsisetdbparms you posted and then use mqsicvp to validate.
Once you have done that, you can post the results here if they did not work and then ask for help. |
|
| 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
|
|
|
|
