Stored procedures

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I've seen that stored procedures are not supported by SQL Server CE
But what about calling a stored procedure from a remote standard SQL SERVER

I've try this

SqlConnection PubsConn = new SqlConnection
("Data Source=server;integrated " +
"Security=sspi;initial catalog=pubs;")
SqlCommand testCMD = new SqlCommand
("TestProcedure", PubsConn)

testCMD.CommandType = CommandType.StoredProcedure


but it doesnt work
 
Hi, I've seen that stored procedures are not supported by SQL Server CE.
But what about calling a stored procedure from a remote standard SQL SERVER ?

I've try this :

SqlConnection PubsConn = new SqlConnection
("Data Source=server;integrated " +
"Security=sspi;initial catalog=pubs;");
SqlCommand testCMD = new SqlCommand
("TestProcedure", PubsConn);

testCMD.CommandType = CommandType.StoredProcedure;
"

but it doesnt work
Click to expand...

I also tried, and tried, and finally came up with this (bit of lame)
solution:

SQLmcd = new system.data.sqlclient.sqlcommand("Exec
SP_StoredProcNameHere param1here, param2here etc ...",SQLConn)


best regards,
Kris
 
Well in fact my problem was I just didnt write the "using System.Data;" line to use the CommandType enumeration
 
Back
Top