Hiya Guys,

I am using System.Data.SqlClient for the first time and wrote this code to create a stored procedure but I keep getting this error: -

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

Additional information: System error.

This is my code: -

SqlConnection objConnection;
            string strSQL;
            SqlCommand objCommand;

            objConnection = new SqlConnection("Data Source=(local)\\NetSDK; Initial Catalog=NorthWind; Integrated Security = true");

            objConnection.Open();
            strSQL = "CREATE PROCEDURE sp_WaCustomers AS SELECT CustomerID, CustomerName FROM Customers WHERE Region = 'WA'";
            objCommand = new SqlCommand(strSQL, objConnection);
            objCommand.CommandType = CommandType.StoredProcedure;
            objCommand.ExecuteNonQuery();
            Console.WriteLine("Procedure Created !!");

Any ideas??



Adz - The World is not enough

__________________
Adz - Learning The J2EE Ways.

Dear friend:
ur command (strSQL) is not wrong but I think u get this error bc of 3 reason.
1_ I see no user & pass in ur Connection string to connect user(objConnection).
2_ Ensure u r going to execute the command for not first time & SP is already created.
3_ U might have no primission to create SP on server.

START FROM #1.
HTH, Keep in touch.

Always:),
Hovik Melkomian.

What should the connection string be if the SQL Database using the windows authentication as user name and password??

Adz - The World is not enough

Hi,

I have changed my connection string, but I am still getting the same error??

this is my code: -

SqlConnection objConnection;
            string strSQL;
            SqlCommand objCommand;

            objConnection = new SqlConnection("Data Source=(local)\\NetSDK; Initial Catalog=NorthWind; uid=QSUser; pwd=QSPassword; Integrated Security=SSPI");

            objConnection.Open();
            strSQL = "CREATE PROCEDURE sp_WaCustomers AS SELECT CustomerID, CustomerName FROM Customers WHERE Region = 'WA'";
            //strSQL = "SELECT * FROM CustomerID";
            objCommand = new SqlCommand(strSQL, objConnection);
            objCommand.CommandType = CommandType.StoredProcedure;
            objCommand.ExecuteNonQuery();
            Console.WriteLine("Procedure Created !!");

Any Ideas??

Adz - The World is not enough

dear freind:
u r creating SP not using SP so ur comand is Test & u should set ur CommandType to

Code:

objCommand.CommandType = CommandType.Text;

HTH.

Always:),
Hovik Melkomian.