About half a half-dozen store procedures have similiar problems!
It's definitely a good idea to go through all the store procedures after installation.
Make sure the store procedures code doesn't contain syntax errors!!!
Would it be possible to ask the book author (or somebody else) to update (improve) the sample code.

This would only be possible if the book was still owned by Wrox- since it is no longer a title they own, they have no contract with the author of the book.


Hal Levy
NOT a Wiley/Wrox Employee- Got a job for me?

My 'next' problem is log in! I haven't had time yet to dig in the code! Does anybody have a off the shelf solution? Would be nice with a shortcut!

Login problem is solved. I just changed the authentication mode in the web.config file.
New Problem:
When doing final checkout (pressing 'Complete Order' button) I received the following message:
    Message queuing has not been installed on this computer!

After installing Message Queuing (with only the common subcomponent!?) i restarted my machine. Now, I receive another message saying:
    Queue is not registered in the DS.

Problem is that I do not have any experience with Message Queuing! I would appreciate a quick hint on how to solve this? If not I have to read all the long help texts on message Queuing. Life is cruel...
(Note: I'm running windows XP Professional on a Laptop machine)

The error is pretty straight forward in this case.. You need to register the queue in the DS.... DS is "Directory Service-- active directory






Hal Levy
NOT a Wiley/Wrox Employee- Got a job for me?

I'm running into the same problem not very familiar with Queuing
I think I entered the DS properly but when I go to the final checkout
The transaction usage is invalid.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Messaging.MessageQueueException: The transaction usage is invalid.

Source Error:


Line 70: mq.DefaultPropertiesToSend.Recoverable = true;
Line 71:
Line 72: mq.Send( currentOrder );
Line 73: mq.Close();
Line 74:


Source File: C:\Inetpub\wwwroot\wineshopny\OrdersClient\OrdersC lient.cs Line: 72

Stack Trace:


[MessageQueueException (0x80004005): The transaction usage is invalid.]
   System.Messaging.MessageQueue.SendInternal(Object obj, MessageQueueTransaction internalTransaction, MessageQueueTransactionType transactionType) +417
   System.Messaging.MessageQueue.Send(Object obj) +9
   WS.Web.OrdersClient.OrderClient.SubmitOrder(Order currentOrder) in C:\Inetpub\wwwroot\wineshopny\OrdersClient\OrdersC lient.cs:72
   WS.Web.FinalCheckout.btnComplete_Click(Object sender, EventArgs e) in C:\Inetpub\wwwroot\wineshopny\wineshopny\FinalChec kout.aspx.cs:115
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
   System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
   System.Web.UI.Page.ProcessRequestMain() +1247




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

Brett G. Murphy

Good News! I finally made it to the ‘Your order has been submitted…’ message! Thanks a lot Hal for your help!

Here is how I did it!

The message ‘Queue is not registered in the DS’ can be ignored. There is no need to install Active Directory or any other LDAP server. Just install Message Queuing (only subcomponent ‘Common’ is needed). Create a new private queue called ‘orders’!
Clean up (delete all records) in the table ‘ShoppingCarts’ ! Log in, buy gadgets and it just works!

You are the man!:D;)

Brett G. Murphy

I'll bet that when you create the orders queue it gets put into the AD.. However since I have not used AD with MQ I can't be sure.

Glad you got it working

Hal Levy
NOT a Wiley/Wrox Employee- Got a job for me?

>Login problem is solved. I just changed the authentication mode in >the web.config file.

Would you tell me what do you exactly put code in the web.config file? I have the same problem, but still don't know how to set to authentication mode in the web.config file through its code or any other way.


Here is my problem:

I have a login problem with the MSDE database.

When I mannuelly do, I can only create a new database by Use Window NT Integrated Security.
If I use SQL Server Autherntication, it will show me the error msg "ADO Error: ' Login
falled for user 'sa'. Reason: Not associated with a trusted SQL Server connection'"

Now in the web.config file. I have followed the book used
<appSettings>
    <add key="ConnectionString" value="Server=Home\NetSDK;User ID=sa; Password=; Initial Catalog=WroxJokeShop" />
  </appSettings>

Certainly it showed me Server Error in '/WroxJokeShop' Application.
--------------------------------------------------------------------------------

Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

Source Error:


Line 11:
Line 12: ' Open the connection
Line 13: connection.Open()
Line 14:
Line 15: ' Return a SqlDataReader to the calling function


Thanks a lot,

Diana ([email protected])

Diana