Hi

I'm sorry if this is a simple question, but I seem to be having problems insterting data into a table in a database. I'm using SQL2008 Express and I am able to query the database and create the table. The problem arises when I try to run an insert statement on the new table, I get the following error message:

Error getting parameter info (SQLDescribeParam): [07009][Microsoft][SQL Server Native Client 10.0]Invalid Descriptor Index, [07009][Microsoft][SQL Server Native Client 10.0]Invalid parameter number

The table was created using the following statement:

CREATE TABLE tbl_DockedPose ( id INT IDENTITY name VARCHAR(20) NOT NULL, ctab VARCHAR(MAX) NOT NULL, )

and the insert sql is as follows:

INSERT INTO tbl_DockedPose (name, ctab) VALUES (?, ?)

The value for ctab is read from an sd file and converted to ctab using the covert molecule to text protocol. 'name' is from a variable created on the fly using a custom manipulator. In the ODBC insert component I have set the SQL parameter mapping to

Lig_name, CTAB

, and the SQL Parameter Types on in, in.

Does anyone have any ideas where i'm going wrong?

Thanks for you help.
Hassan