Recent content by smeridew

Ok - I made a few mistakes...here are the actual tables, with the pertinent data. CustProd is really like a join between customer and product, to enable a many-to-many relationship. Let's pretend that the product is some microsoft software. Product Table ============= ProductID (Text)...

Wow - thanks so much for this information. I will try it out and let you know how it works. Up til now, I've been managing an 'indicator' flag in the table, but it's a major pain to maintain this flag as customers buy new products. Very much appreciate you taking the time to answer my...

I need to write an ACCESS query that goes something like this: For each customer (table customer-product) For each product they have (table customer-product) If they don't have the latest product (table product) Include that customer+product combo in the result The...

I am having trouble applying a filter to my OWC Excel Sheet. I have a dropdown box that lets the user select the criteria based on an old date. Here's the code: Dim StartDate As String StartDate = ">" & Format$(DateSerial(Year(Date), Month(Date) - Combo1.Text, Day(Date))...

One other small clarification - you only need MQBEGIN if you are coordinating your unit of work with an external resource such as a database within the GET thread. Get within SYNCPOINT is all that you need to do otherwise (i.e. a query style application). My suggestion here? Have the same...

MQClient; Advantage is cost (free). Disadvantage is connection dependence - i.e. MQ Server must be available. MQServer; advantage is connection independance (messages remain in xmit queue until connection is up). Disadvantage: cost (5K -10K per server roughly). MSMQ; advantage is win32...

Make sure you know what userID the IIS application is running under. Sometimes people change this in the MMC snap-in. IUSR_<system> is the default, but can be changed - try changing this yourself even, to an ID that is mqm privelaged. Is the application running under COM+ control? If so, you...

To clarify, your server process should strip the messageID from the MQMD of the request message. It should then use this value as the correlationID field of the reply message. The client-side process process: The client application puts the request message, then saves the messageID created by...

I you are looking for auto fail-over from a non-clustered qmgr to a cluster, you're out of luck. It only works in a clustered environment. You will need to create a second channel (QM3.TO.QM2) to a second repository qmgr in the cluster, in case you lose the first cluster QMgr (QM1 in your...

Vinoo, Next time you need help I'll be happy to help you out. Thanks, Scott Meridew scott@txmq.com www.txmq.com Certified MQSeries Specialist,MCSE MQ Squared Inc. www.mqsquared.com I'm also an independant MQSeries consultant, so if you come across any short-term assignments, look me up :-)

Wow - lots of confusion about clustering in this thread. I have written a couple of articles on clustering you can find on IBM's MQSeries web site (under library..articles) - check them out (perhaps the one mentioned above). The most disturbing comment offered here is using a remote queue...

From the COM manual: The MQSeries client requires access to at least one MQSeries server. When both the MQSeries server and client are installed on your system MQAX applications will always run against the server. You need to make sure only the MQ client is installed on the system, and then...

You need to create a client connection channel between the client and the server first. The trigger monitor runs as an MQ client, connecting to the server via this channel. Create a SVRCONN channel on the server and call it CLIENT_CHANNEL. On the client, use the MQSERVER variable to easily...

Your answer depends on your system resource availability, and throughput/volume of messages. I've designed applications that run continuously with an unlimited wait after being triggered. I've also designed apps that wait only 10 seconds for new messages and then terminate. You definately have...

Are you disconnecting from the first queue manager, changing the connectionname (in MQCNOCD structure) and then connecting to the second queue manager? This should work, assuming the parameters are all correct. (IP address, port number, protocol). Scott Meridew Certified MQSeries...