Running a Stored Procedure?

[Tomer]

I've tried running a stored procedure from my ppc, I've connected to my sql
server 2000 successfully, and when I use this code:


DM.Cmd.Connection = DM.Conn;

DM.Cmd.CommandType = System.Data.CommandType.StoredProcedure;

DM.Cmd.CommandText = "DTSRun";

DM.Cmd.Parameters.Add("@ServerName",SqlDbType.Text);

DM.Cmd.Parameters[0].Value = "GUEST";

DM.Cmd.Parameters.Add("@UserName",SqlDbType.Text);

DM.Cmd.Parameters[1].Value = "sa";

DM.Cmd.Parameters.Add("@Password",SqlDbType.Text);

DM.Cmd.Parameters[2].Value = "sa";

DM.Cmd.Parameters.Add("@DtsName",SqlDbType.Text);

DM.Cmd.Parameters[3].Value = "Import Phones";

DM.Cmd.Parameters.Add("@DtsPassword",SqlDbType.Text);

DM.Cmd.Parameters[4].Value = "";

DM.Cmd.ExecuteNonQuery();



I get an exception: PlatformNotSupported.

I used to get this exception when I first tried to connect to the sql
server, but when I've changed the databse/tables collation to
Latin_General_CI_AS, it resolved.

But now this doesn't seem to work, even on another sql server which by
default has the Latin_General_CP1255_CI_AS collation (the first sql server
I've tried this on had a Hebrew_CI_AS collation by default).

 

[Chris Stephens]

Try something much simpler like....

rda.SubmitSQL("Exec MyStoredProc Param1")

Chris