| Author |
Message
|
| fehmees |
 Posted: Mon Apr 28, 2003 8:17 am Post subject: Using Database Node to access MSSQL |
 |
|
Newbie
Joined: 10 Mar 2003
Posts: 5
|
Hi,
I have a requirement for a POC, which is to use WMQI broker services running on AIX5.L system and using MS SQL as an application database.
On Windows 2000, I am able to use the native SQL odbc driver to connect and using WMQI database node able to insert into MQ SQL tables.
But moving on to AIX, I am not sure how shall or could handle this situation, cause there is no driver or odbc connectivity to MQ SQL on windows system.
Appreciate, if any one can share their experience using the above scenario or guide me thru the steps! .....
regards |
|
| Back to top |
|
 |
| hornbeam123 |
| Posted: Tue May 04, 2004 5:46 am Post subject: Using Database Node to access MSSQL |
|
|
Centurion
Joined: 01 Nov 2003
Posts: 101
|
| Like fehmees, I to need to access a MSSQL database running on a Windows server but this time from a Database/Compute nodes from a broker (MQSI 2.1) running on Sun Solaris. Presumedly it can be done? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue May 04, 2004 6:32 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
In order to access any particular database from WMQI, you need an ODBC driver for your operating system that can access that database.
On top of that, you have to have an OBDC driver that is approved for working with WMQI.
If you have such a thing for SQL Server that is a Solaris driver, then yes you can connect to SQLServer from Solaris using WMQI.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Empeterson |
| Posted: Tue May 04, 2004 7:03 am Post subject: |
|
|
Centurion
Joined: 14 Apr 2003
Posts: 125
Location: Foxboro, MA
|
Where can we find a list of 'approved' drivers?
_________________
IBM Certified Specialist: MQSeries
IBM Certified Specalist: Websphere MQ Integrator |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue May 04, 2004 7:27 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| hornbeam123 |
| Posted: Tue May 04, 2004 7:50 am Post subject: Using Database Node to access MSSQL |
|
|
Centurion
Joined: 01 Nov 2003
Posts: 101
|
This is where I started.
The list against SOLARIS in all of the documentation seems to suggest MSSQL is not supported on that platform but our learned colleague seems to think given the availability of an approved driver I should be ok to access this dbms remotely from Solaris. This was my initial belief.
We do NOT want to mount a mqsi broker on the Windows machine just to get to a remote database from Solaris.
Meanwhile I will continue to search the web for something I'm not sure even exists ! |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue May 04, 2004 9:22 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
The Supported Databases page in the Toolkit help says that SQLServer support is "Not Applicable" for Solaris.
So there is no supported driver, and there likely isn't a driver.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| hornbeam123 |
| Posted: Tue May 04, 2004 9:40 am Post subject: Using Database Node to access MSSQL |
|
|
Centurion
Joined: 01 Nov 2003
Posts: 101
|
Jeff,
Ouch!
My client will not be happy.
However I see that EasySoft have a product 'odbc to odbc bridge' and after initial conversation with their company suggests this may serve our purpose.
Where that leaves the support question is another matter ?
The thought of numerous licences for MQ and MQSI on these Windows Server machines (multi-processor of course) is looming.
I will keep you all posted on developments on this project.
Thanks to all of you for your help. |
|
| Back to top |
|
|
|
|
