By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,815 Members | 1,142 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,815 IT Pros & Developers. It's quick & easy.

Stored Proc call from VB.NET

P: n/a
Jim
Here is my code and it times out on the server without throwing an error. I
know the Stored Proc exists in the database I am connected to and I can run
it with parameters from Query Analyzer with no problem.

Am I making the wrong call against this procedure. I'm passing dates as
parameters and the variables are defined as date and I use smalldatetime in
the stored proc.

My connection object is cnSQL and it works perfectly.

cmSQL = New SqlCommand
cmSQL.Connection = cnSQL
cmSQL.CommandType = CommandType.StoredProcedure
cmSQL.CommandText = "dbo.stp_NewClientStatements"
cmSQL.Parameters.Add("@date1", SqlDbType.datetime).Value = info.RptStart_Date
cmSQL.Parameters.Add("@date2", SqlDbType.datetime).Value = info.RptEnd_Date
cmSQL.ExecuteNonQuery()
--
Thanks, Jim
Nov 14 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.