471,317 Members | 1,907 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,317 software developers and data experts.

CLR Hosting and code execution

Hello:

I'm trying to call a method of a class using CLR Hosting but whenn
calling Invoke on the IDispatch interface of the object i'm getting
E_NOINTERFACE, the method i'm trying to execute looks like this:

public FbResultSet AddEmployeeProject(short employeeID, string
projectID)
{
FbConnection connection = new
FbConnection(this.GetConnectionString());
connection.Open();

string sql = "INSERT INTO employee_project (emp_no,
proj_id) VALUES (@EmployeeID, @ProjectID);";

using (FbCommand insert = new FbCommand(sql, connection))
{
insert.Parameters.Add("@EmployeeID",
FbDbType.SmallInt).Value = employeeID;
insert.Parameters.Add("@ProjectID",
FbDbType.Char).Value = "GUIDE";

int rowsAffected = insert.ExecuteNonQuery();
}

return new FbResultSet();
}

I can get it executed if i have the two parameters as short ( or is i
left only one parameter )

The first parameter will be passed as VT_I2 and the second one as VT_BSTR

Any idea on what can i do to solve the problem ??

--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain CLR Hosting and code execution
Dec 8 '05 #1
0 983

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Siegfried Heintze | last post: by
reply views Thread by Kunal Pandya | last post: by
reply views Thread by Richard | last post: by
3 posts views Thread by mpar612 | last post: by
2 posts views Thread by Carl Gilbert | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.