Stored procedures

[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

 

[Guest]

Ive found the solution

thats ok

 

[HomeAutomation Freak]

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

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

 

[Guest]

Well in fact my problem was I just didnt write the "using System.Data;" line to use the CommandType enumeration