|  | 
 
  
    | RSS Feed - WebSphere MQ Support | RSS Feed - Message Broker Support |  
 
  
	|    |  |  
  
	| MQ Series 5.2 - SQL Server 7.0 | « View previous topic :: View next topic » |  
  	| 
		
		
		  | Author | Message |  
		  | MQSIBM | 
			  
				|  Posted: Thu Nov 01, 2001 7:04 am    Post subject: |   |  |  
		  | Novice
 
 
 Joined: 31 Oct 2001Posts: 18
 
 
 | 
			  
				| Hi all I am a member of MQSeries.net forum and I am new to MQ.
 I have a similar question to the one you have
 Posted: 2001-07-27 .
 I have to implement MQI Calls between MQ Series 5.2 and SQL Server 7.0. I have no idea if I have to use any Adapters for this or if there is any other way. If you have any info available with you or on INternet. Let me knwo.
 
 Thanks in advance.
 |  |  
		  | Back to top |  |  
		  |  |  
		  | kolban | 
			  
				|  Posted: Thu Nov 01, 2001 7:08 am    Post subject: |   |  |  
		  |  Grand Master
 
 
 Joined: 22 May 2001Posts: 1072
 Location: Fort Worth, TX, USA
 
 | 
			  
				| Not sure what you mean by MQI calls between a queue manager and a database?  It almost sounds like you want to populate a database table with data from a message?  If this is so, you will either have to write an application which gets messages from a queue and then performs SQL calls to insert the data into the table or else investigate the MQSI product which takes the majority of that work away from the programmers. |  |  
		  | Back to top |  |  
		  |  |  
		  | bduncan | 
			  
				|  Posted: Thu Nov 01, 2001 10:57 am    Post subject: |   |  |  
		  | Padawan
 
 
 Joined: 11 Apr 2001Posts: 1554
 Location: Silicon Valley
 
 | 
			  
				| Yes, there are adapters you can purchase to take MQSeries messages and do updates to a MSSQL database with very little configuration, but these can be costly. If you have application developers available who aren't afraid to venture into the world of MQSeries (valley of the shadow of death??) they can write the adaptor in one of many languages that MQI is available for. But no, MQSeries "out of the box" can't talk directly to a database, or any other external system for that matter. 
 
 _________________
 Brandon Duncan
 IBM Certified MQSeries Specialist
 MQSeries.net forum moderator
 |  |  
		  | Back to top |  |  
		  |  |  
		  | MQSIBM | 
			  
				|  Posted: Fri Nov 02, 2001 7:31 am    Post subject: |   |  |  
		  | Novice
 
 
 Joined: 31 Oct 2001Posts: 18
 
 
 | 
			  
				| Thanks all for ur valuable suggestions.. 
 Bduncan I would like to know the names of the adapters available in the market. my client is ready to buy  things..
 If you have any additional info , let me know.
 
 cheers
 
 
 
 
   
	| Quote: |  
	| On 2001-11-01 10:57, bduncan wrote:
 Yes, there are adapters you can purchase to take MQSeries messages and do updates to a MSSQL database with very little configuration, but these can be costly. If you have application developers available who aren't afraid to venture into the world of MQSeries (valley of the shadow of death??) they can write the adaptor in one of many languages that MQI is available for. But no, MQSeries "out of the box" can't talk directly to a database, or any other external system for that matter.
 
 
 
 |  |  |  
		  | 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
 
 |  |  |  |