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 tryiong 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