| Author |
Message
|
| angka |
 Posted: Tue Jul 04, 2006 7:30 pm Post subject: Broker V6 MS SQL |
 |
|
Chevalier
Joined: 20 Sep 2005
Posts: 406
|
Hi all,
How to access the MQ SQL database using Broker V6? Keep giving me the error "Unresolvable database table reference". Or is there any Red book for reference?? thanks. |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Tue Jul 04, 2006 7:57 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Do you have an ODBC reference for your MSSQL space ?
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| angka |
| Posted: Tue Jul 04, 2006 9:57 pm Post subject: |
|
|
Chevalier
Joined: 20 Sep 2005
Posts: 406
|
| Ya I include a DSN. Thanks |
|
| Back to top |
|
|
| angka |
| Posted: Tue Jul 04, 2006 10:00 pm Post subject: |
|
|
Chevalier
Joined: 20 Sep 2005
Posts: 406
|
| Broker set up is ok. btw wat you meant by ODBC reference for your MSSQL space. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Tue Jul 04, 2006 10:20 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi angka,
Please try a search...
In control Panel-->Administrative Tasks-->Data Sources(ODBC), Under System DSN you must create an entry for the database...
Also, you might need to use the mqsisetdbparms also.
Regards. |
|
| Back to top |
|
|
| angka |
| Posted: Tue Jul 04, 2006 10:34 pm Post subject: |
|
|
Chevalier
Joined: 20 Sep 2005
Posts: 406
|
Hi elvis_gn,
I include an entry but i still cant connect to the application Database. Thanks |
|
| Back to top |
|
|
| angka |
| Posted: Tue Jul 04, 2006 10:36 pm Post subject: |
|
|
Chevalier
Joined: 20 Sep 2005
Posts: 406
|
Hi elvis_gn,
My broker database is ok but not the application database. btw what i need to use for the mqsisetdbparms. Thanks |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Jul 05, 2006 2:37 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Where are you gettting "unresolvable database table reference"? In toolkit? or in broker exception list at runtime?
Can you use the ODBC DSN to connect to the database with the test connection button?
Can you otherwise use a regular SQLServer tool to connect to the database from the broker machine?
Then you can use mqsisetdbparms to associate a user and a password with the DSN.
Then you can use the DSN just like every other DSN is used in Broker.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| angka |
| Posted: Wed Jul 05, 2006 11:34 pm Post subject: |
|
|
Chevalier
Joined: 20 Sep 2005
Posts: 406
|
Hi jefflowrey,
The error "unresolvable database table reference" is in the toolkit.. my test connection button is ok.. I try deploying and it works.. it is just warning. thanks.. |
|
| Back to top |
|
|
|
|
