ExecuteNonQuery() error

[magmo]

Hi

I try to use this code in a vb.net application but I get a an error on the "MyCommand.ExecuteNonQuery()" line.
I dont see any faults in this code, am I missing something here?

Dim MyConnection As SqlConnection
Dim MyCommand As SqlCommand
Dim MyDataReader As SqlDataReader
MyConnection = New SqlConnection(connStr)
MyCommand = New SqlCommand("p_DropColumn", MyConnection)
MyCommand.CommandType = CommandType.StoredProcedure
MyConnection.Open()
MyCommand.ExecuteNonQuery()
MyConnection.Dispose()

The only errror message VS give me is...

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

Additional information: System error.


(The stored procedure is to drop a column in a database table.)


Regards

 

[chrissie1]

if you try it without using the sp for example alter table drop column does it work then?

is your connectionstring aimed for the correct database?

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]

 

[magmo]

Hi


Just found out that I do not have permissions to drop a column in the database table.


Regards

 

[chrissie1]

yep, that could be it.

placing the executenonquery in a try catch would have probably told you that.

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]