| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| configuring SQL Server database access |
« View previous topic :: View next topic » |
| Author |
Message
|
| Fede_patane |
 Posted: Thu Jan 25, 2007 12:54 pm Post subject: configuring SQL Server database access |
 |
|
Novice
Joined: 05 Oct 2006
Posts: 15
Location: Buenos Aires, Argentina
|
Dear all,
I am trying to configure a database access an SQL Server database on a Windows system.
I am running WMB 6 on AIX 5.3. The broker's database is a DB2 on the same machine.
What i want to do is use the database node to access the SQLServer.
After reading A LOT of documentation i have found that i have to configure the ODBC source that is in the file pointed by the ODBCINI AIX environment variable. In this file I can put my new ODBC source and it's conection parameters. But what is missing is user and pass. The thing is i have found nowhere to put them and since the user created to access the database is (obviously) different than the service user for the broker, i haven't found where to configure it.
If anyone can point me to where to configure it i would be very grateful. Also if there is an easier way to access a database (without using WBI Adapters) i am more than happy to listen to any ideas.
Thanx in advance.
Federico
_________________
You ask why are we slaves, but I ask why are you not? What hideous force in the universe could set you free and forever taken away your peace of mind. |
|
| Back to top |
|
 |
| EddieA |
| Posted: Thu Jan 25, 2007 4:28 pm Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
Look at mqsisetdbparms.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| Bill.Matthews |
| Posted: Thu Jan 25, 2007 4:39 pm Post subject: |
|
|
Master
Joined: 23 Sep 2003
Posts: 232
Location: IBM (Retired)
|
| EddieA wrote: |
Look at mqsisetdbparms.
Cheers, |
In addition to EddieA's answer, be sure that your WMB is at v6.0.0.1 or later since the DataDirect drivers provided by WMB were updated then to include support for SQL Server.
_________________
Bill Matthews |
|
| Back to top |
|
|
| Fede_patane |
| Posted: Fri Jan 26, 2007 3:38 am Post subject: |
|
|
Novice
Joined: 05 Oct 2006
Posts: 15
Location: Buenos Aires, Argentina
|
Thanx!!! looks like the command i was missing. I will try it.
 )
Federico
_________________
You ask why are we slaves, but I ask why are you not? What hideous force in the universe could set you free and forever taken away your peace of mind. |
|
| 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
|
|
|
|
