| Author |
Message
|
| Missam |
 Posted: Sat Jan 17, 2004 1:49 pm Post subject: ODBC Connection in compute node |
 |
|
Chevalier
Joined: 16 Oct 2003
Posts: 424
|
Hi,
I have a PC with windows XP Prof .I Have a broker,configmgr and control center on the same machine.When i do a query the database with the ODBC with which i created broker ,the query results fine.but when i create another odbc connection to the sane database and try using this ODBC in my compute node it's not working.can any body tell whats the reason. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Sat Jan 17, 2004 2:27 pm Post subject: Re: ODBC Connection in compute node |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| IamSam wrote: |
| when i create another odbc connection to the sane database and try using this ODBC in my compute node it's not working. can any body tell whats the reason. |
Yes, the reason is you've done something wrong.
If you want a more specific answer, you will need to be more specific about what is not working.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Missam |
| Posted: Sat Jan 17, 2004 3:56 pm Post subject: |
|
|
Chevalier
Joined: 16 Oct 2003
Posts: 424
|
Yep,
You are right.I went wrong and i realised we can't create 2 ODBC's for the same database.
Thanx
Sam |
|
| Back to top |
|
|
| kirani |
| Posted: Fri Jan 23, 2004 12:05 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
| IamSam wrote: |
i realised we can't create 2 ODBC's for the same database.
|
Yes, you can!
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| Missam |
| Posted: Fri Jan 23, 2004 10:43 am Post subject: |
|
|
Chevalier
Joined: 16 Oct 2003
Posts: 424
|
|
| Back to top |
|
|
| EddieA |
| Posted: Fri Jan 23, 2004 11:04 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
Different Data Source Name (what your application, WMQI, uses). Same Database Alias (the actual database).
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| Missam |
| Posted: Sat Jan 24, 2004 5:35 am Post subject: |
|
|
Chevalier
Joined: 16 Oct 2003
Posts: 424
|
Hi
Every Body,
I did some thing other wrong which is not related to ODBC.
and made misconception on ODBC.
Thanks to every one.
Sam |
|
| Back to top |
|
|
|
|
