Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 441
  • Last Modified:

MSMQ and ASP

Hi experts,

I'm in need of using MSMQ with ASP.  Did a search on the net but couldn't really found the information that I'm looking for.  I'm a sort of new to ASP and MSMQ.  I'd like to know how to access to MSMQ from ASP, available methods/functions, (if possible) sample codes, etc...  If you can point me to right directions, I'd greatly appreciate it.

Thanks in advance,
gibb
0
gibberish3ll3
Asked:
gibberish3ll3
  • 3
  • 3
1 Solution
 
anderson22Commented:
I can help you with code if you present a synopsis of what you are trying to do.  Below are a couple of references:

Describing the MSMQ Functionality:
http://msdn.microsoft.com/library/en-us/dnproasp2/html/workingwithqueuesmessages.asp

Example using MSMQ from ASP:
http://msdn.microsoft.com/library/en-us/dnproasp2/html/creditpayment.asp

-rca
0
 
gibberish3ll3Author Commented:
Hi anderson22,

Thanks for the URLs.

What I'm trying to do with MSMQ is that we have a huge amount of SQL query job that needs to be executed from time to time.  Depending on the server workload at that time of execution, this ASP script times out.  To solve this problem, I'd like to send a SQL query job to MSMQ asynchronously and to have MSMQ handle job executions in the background while ASP pages keep moving forward.  I know that this can be done with ASP and MSMQ but just don't know how yet.  Doing more research...

Thanks,
gibb
0
 
gibberish3ll3Author Commented:
BTW, are there any limitations on MSMQ, such as maximum character length or size which a message can consist, the number of message which MSMQ can hold, etc...?

Thanks in advance,
gibb
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
anderson22Commented:
Sorry I haven't responded sooner.  I have been doing a little research.  It appears that there are not too many limitations on MSMQ as far as string lengths etc.  I guess it is important to know that this will have a direct effect on system resources.

I don't see any reason why you would have problems doing what you have described.

-rca
0
 
gibberish3ll3Author Commented:
Hi anderson22,

thanks for your post.

Do you happen to know why "Set query = Server.CreateObject("MSMQ.MSMQQuery")" fails on my server?  I get the following error message.

Server object error 'ASP 0177 : 800401f3'
Server.CreateObject Failed
/testplan/msmq.asp, line 7
Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp.

Thanks in advance,
gibb
0
 
anderson22Commented:
You need to install MSMQ from the Windows Add/Remove Components (under Add/Remove Programs).

On Windows 2000 or XP it should be labeled Message Queueing Services.

Add this and you should be set.

-rca
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now