| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| WMQMB 6 and SQL Server 2000: "Unsuitable database" |
« View previous topic :: View next topic » |
| Author |
Message
|
| svu |
 Posted: Thu Aug 16, 2007 6:39 am Post subject: WMQMB 6 and SQL Server 2000: "Unsuitable database" |
 |
|
Voyager
Joined: 30 Jan 2006
Posts: 99
|
I am running WMBMB 6.0.0.1 and Microsoft SQL Server 2000. In ESQL code, I am trying to execute a stored procedure (on SQL Server) using PASSTHRU statement. The statement is run against the system-wide ODBC datasource pointing to local SQL server database.
I am getting rather funny exception number 2466: "Unsuitable database". WMQMB definitely sees the data source (otherwise I am getting "Data source name not found") - but for some reason cannot exec the SP.
Any ideas?
TIA,
Sergey |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Aug 16, 2007 6:45 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
It seems that you're trying to talk to two different kinds of databases from the same node...
At least, that's what the error message says you're trying to do.
What does it report for Insert2 and Insert3?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| svu |
| Posted: Thu Aug 16, 2007 6:54 am Post subject: |
|
|
Voyager
Joined: 30 Jan 2006
Posts: 99
|
| jefflowrey wrote: |
It seems that you're trying to talk to two different kinds of databases from the same node...
|
Yes, IIRC it is the case. Is it forbidden? Where could I read about it? I tried to google the error message and error code - found nothing relevant at all.
| jefflowrey wrote: |
| At least, that's what the error message says you're trying to do. |
Ghm. My English is not native, but IMVVHO that error message does not say that... 
| jefflowrey wrote: |
| What does it report for Insert2 and Insert3? |
I'll give it a try...
Thanks a bunch for the idea - I'll try to split the code in 2 nodes. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Aug 16, 2007 6:56 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
No, you can't talk to DB2 and SQLServer from the same node.
You can talk to DB2 from one node and SQLServer from another node.
Likewise, you can't talk to Db2 and Informix from the same node, or Oracle and SQLServer, or etc.
You can't talk to two kinds of databases from the same node.
When I said "that's what the error message says", I meant - "that's what the reference for BIP2466 says".
The InfoCenter has a page called "Diagnostic Messages" where you can input a BIP number, and get back an explanation of what the BIP number means.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| svu |
| Posted: Thu Aug 16, 2007 7:02 am Post subject: |
|
|
Voyager
Joined: 30 Jan 2006
Posts: 99
|
| jefflowrey wrote: |
No, you can't talk to DB2 and SQLServer from the same node.
The InfoCenter has a page called "Diagnostic Messages" where you can input a BIP number, and get back an explanation of what the BIP number means. |
Thanks a lot again. I just have to use InfoCenter more often (and trust Google a bit less). Going to split the code... |
|
| 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
|
|
|
|
