| Author |
Message
|
| shalabh1976 |
 Posted: Thu Sep 29, 2005 8:12 pm Post subject: DB2 Alias not working |
 |
|
Partisan
Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
|
I have a Database IHUBDV with alias IHUB. In MQSI when I specify the DataSource name as IHUB I get the error
| Quote: |
| Database error: SQL State 'IM002'; Native Error Code '0'; Error Text '[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'. |
However I do have the ODBC set connection set up with ALIAS as IHUB and Database name as IHUBDV.
Broker and database have been restarted also.
Changing the DataSource name to IHUBDV in the node works.
I wanted to know about how to make the ALIAS work.
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Thu Sep 29, 2005 8:37 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
I am not sure if ODBC has a test connection option for DB2...If yes try that to first make sure your connection is set right...
Next have you done a mqsisetdbparms ??? If not search the forum and u'll find many threads on it...
Regards. |
|
| Back to top |
|
|
| shalabh1976 |
| Posted: Thu Sep 29, 2005 8:43 pm Post subject: |
|
|
Partisan
Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
|
I am on Windows Platform.
It does have a test ODBC connection and it is working fine.
Do I still need to set mqsisetdbparms ?
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu Sep 29, 2005 8:47 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
|
| Back to top |
|
|
| EddieA |
| Posted: Thu Sep 29, 2005 11:14 pm Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
Why. mqsisetdbparms is only used to set the UserID and Passwd to access a DataSource. That is not the problem here.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu Sep 29, 2005 11:51 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Oh ! didn't notice that. My apologies....
I only meant that eventually that also needs to be done....
So now i'm inquisitive too, is it possible to use the alias name in the node or not ?? |
|
| Back to top |
|
|
|
|
