Not Connecting To SQL Database Anymore

I have the following code in my ASP program
dbRows = Server.CreateObject("ADODB.Recordset");
dbRows.Open( dbCmd );
dbCmd.Parameters.Delete("@reset");

newUser=((dbRows.EOF) || ((!dbRows.EOF) && (dbRows("isActive").value != 1)) )
if ( newUser ) {
if(Request.ServerVariables("SCRIPT_NAME") != "/profile_edit.asp" ) {
Response.clear();
Response.Redirect("/newuser.asp");
}
} else {
Session("logon_user") = Request.ServerVariables("LOGON_USER")+"";
Session("fullname") = dbRows("full_name").value;
Session("email") = dbRows("email_address").value;
Session("q1") = dbRows("q1").value == " " ? "" : dbRows("q1").value;
Session("q2") = dbRows("q2").value == " " ? "" : dbRows("q2").value;
Session("q3") = dbRows("q3").value == " " ? "" : dbRows("q3").value;
Session("ct") = dbRows("ct").value == " " ? "" : dbRows("ct").value;
Session("so") = dbRows("so").value == " " ? "" : dbRows("so").value;
Session("graphic_level") = 3;
Session("er_view") = dbRows("er_view").value;
dbRows.close();
gLev=Session("graphic_level");

dbCmd.CommandText = "knet_user_setLastLogin"
dbCmd.Execute();


This same code used to work but doesn't anymore. The connection times out and the error points to the dbCMD.Execute command. Here same things I have found:
1. If I point the database calls to the development server it works. If I point the database calls to the production server it fails. I am to get to production through other calls just fine.

2. If I comment out the dbCmd.Execute or dbCmd.CommandText = "knet_user_setLastLogin" seperately the code works.

What is the dbCmd.Execute doing when it is called?
Could it be a problem with the store procedure?
Could it be a software upgrade on the Database server that is causing the problem?

Your help will be greatly appreciated.

Thanks,
Craig-