I am running two stored procedures in SQL 2005 from VB. First one runs fine but the second it looks like it runs but does not do anything. It does not give me any errors and I know it works and runs in SQL but from VB the second proc just runs thru and does not execute. I am not sure why it would not work for the second command.
Cmd1.ActiveConnection = Con1
Cmd1.CommandType = adCmdStoredProc
Cmd1.CommandText = "UpdateTemp"
Cmd1.CommandTimeout = 0
Cmd2.ActiveConnection = Con1
Cmd2.CommandType = adCmdStoredProc
Cmd2.CommandText = "ApplyPay"
Cmd2.CommandTimeout = 0