| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Simple database connection (SELECT) to DB2 using ESQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| umesh |
 Posted: Sat May 21, 2005 2:28 am Post subject: Simple database connection (SELECT) to DB2 using ESQL |
 |
|
Novice
Joined: 13 May 2005
Posts: 16
|
Hi all,
I am trying to connect to a db2 database which is on other machine using SQL in ESQL. I have set up the DSN to the database
and successfully tested connection using "test Connection" in ODBC menu in win2k. I have also saved the password. But when i try to retrieve the values using
SET Environment.Variables.Result[] = (SELECT T.CD FROM Database.CODES as T);
(this always results multiple values)
I am getting exception Database user id and password incorrect. Do i need to set these values before connecting and how do set them?
Thanks,
umesh |
|
| Back to top |
|
 |
| Ian |
| Posted: Sat May 21, 2005 4:21 am Post subject: |
|
|
Disciple
Joined: 22 Nov 2002
Posts: 152
Location: London, UK
|
Refer to topic "an07080_" which covers the mqsicreatebroker command, specifically the -u parameter :
| Quote: |
The user ID with which databases containing broker tables and user data are to be accessed. If this is not specified, it defaults to the value specified by -i.
|
_________________
Regards, Ian |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Sat May 21, 2005 4:26 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
If you are using version 5, you should look at the mqsisetupdbparms command.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| umesh |
| Posted: Sun May 22, 2005 8:41 pm Post subject: |
|
|
Novice
Joined: 13 May 2005
Posts: 16
|
Hi,
thanks for all inputs. setdbparams made it work.
umesh |
|
| 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
|
|
|
|
