| Author |
Message
|
| sknrt1 |
 Posted: Wed Jun 09, 2004 11:01 am Post subject: sql server drivers - WBIMB |
 |
|
Apprentice
Joined: 22 Jan 2003
Posts: 39
Location: USA
|
Hi,
Does WBIMB product ships with ODBC drivers for SQL Server?
Also can the ODBC driver 'SQL Server' installed automatically with windows NT/2000, be used for WBIMB.
or should go with providers such as "Merant" or "Data Direct" ...for SQL Server - ODBC drivers.
What are the choices for SQL Server - WBIMB
Thanks in Advance. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Jun 09, 2004 11:12 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Have you considered looking at the IBM webpage to see if there is a list of supported ODBC providers for WBIMB based on different platforms?
Because there is such a list on IBM's webpage.
SQLServer is supported only for Configuration Manager databases and for Brokers running *on Windows*. There are no supported drivers for Linux/Unix or OS/390 brokers.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Michael Dag |
| Posted: Wed Jun 09, 2004 1:34 pm Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
it's almost pointless to use SQLServer with WBIMB as SQLServer is only supported for the Broker part,
Configmanager ALWAYS needs DB2... So why install both if the later is already required...
_________________
Michael
MQSystems Facebook page |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Jun 09, 2004 2:35 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| MichaelDag wrote: |
it's almost pointless to use SQLServer with WBIMB as SQLServer is only supported for the Broker part,
Configmanager ALWAYS needs DB2... So why install both if the later is already required... |
Ehh?
Okay.
But the point of any database is to get at the data that's in it. And data migration is a pain.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Michael Dag |
| Posted: Wed Jun 09, 2004 2:39 pm Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
| jefflowrey wrote: |
| But the point of any database is to get at the data that's in it. And data migration is a pain. |
True, but running DB2 and SQLServer on one Windows machine, including MQ and the Broker can be a real 'hog'...
especially in a development situation where you have both configmgr and broker on the same machine 
_________________
Michael
MQSystems Facebook page |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Jun 09, 2004 2:40 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| MichaelDag wrote: |
| jefflowrey wrote: |
| But the point of any database is to get at the data that's in it. And data migration is a pain. |
True, but running DB2 and SQLServer on one Windows machine, including MQ and the Broker can be a real 'hog'...
especially in a development situation where you have both configmgr and broker on the same machine |
Yeah, but why would you install Broker on a database server?
Even in dev?
Hardware is *cheap*.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Michael Dag |
| Posted: Wed Jun 09, 2004 2:48 pm Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
that's why I said: almost...
I just haven't come across situations where both were used...
To add to the argument, I would never architect a solution where the broker updates and 'application' datastore.
(Not to mention an ODBC or JDBC connection to a remote machine)
Always send a message and let another program update the database.
For performance reasons the only stuff I would access from a database
is reference/lookup data.
_________________
Michael
MQSystems Facebook page |
|
| Back to top |
|
|
| kirani |
| Posted: Wed Jun 09, 2004 10:32 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
| MichaelDag wrote: |
To add to the argument, I would never architect a solution where the broker updates and 'application' datastore.
(Not to mention an ODBC or JDBC connection to a remote machine)
Always send a message and let another program update the database.
|
Well that's true in an ideal world. But how does that fit into integrating existing applications? Some of the older applications are designed to read from DB, so there will be instances where one will end up updating a DB using ODBC connection. Clients don't want to change their existing applications and make it MQ enabled.
_________________
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 |
|
|
| Michael Dag |
| Posted: Wed Jun 09, 2004 10:55 pm Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
Kiran, this discussion has many faces.
In the end when the client says: this is the way I want it I'll do it. period.
Putting one or two (and once you go down that road much more) broker-application datastore connections in (either ODBC or JDBC) you'll notice a dramatic performance degradation...
_________________
Michael
MQSystems Facebook page |
|
| Back to top |
|
|
| kirani |
| Posted: Wed Jun 09, 2004 11:03 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Michael,
I understand your point with regards to performance. But, It's not as bad as I'd thought earlier.
_________________
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 |
|
|
| sknrt1 |
| Posted: Thu Jun 10, 2004 11:57 am Post subject: |
|
|
Apprentice
Joined: 22 Jan 2003
Posts: 39
Location: USA
|
This is about WBIMB broker running on AIX and accessing user/application database SQL Server on Windows.
I couldn't find any info in the ibm docs related to this. Probably this is not supported as Jeff indicated.
wondering have any one tried this?
if so, what the odbc driver used for it.
Seems that, DataDirect provides SQL server odbc driver (not sure, need to check on this).
when i have searched on this topic, was able to find the earlier discussions:
http://www.mqseries.net/phpBB2/viewtopic.php?t=8658&highlight=sql+server
Please keep posting as one finds info.
thanks |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Jun 10, 2004 12:27 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| sharpyk wrote: |
This is about WBIMB broker running on AIX and accessing user/application database SQL Server on Windows.
I couldn't find any info in the ibm docs related to this. Probably this is not supported as Jeff indicated. |
It's not.
As far as I know. You can check the documentation yourself, and confirm it.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| kirani |
| Posted: Thu Jun 10, 2004 1:49 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
sharpyk,
Couple of months back someone from DataDirect contacted me regarding the requirements for accessing SQL server from UNIX environment. At that time they were planning on building a Business Case to develop/market such driver. Try contacting the vendor and see if they have anything coming up in near future.
_________________
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 |
|
|
|
|
