Problem with OdbcDataAdapter and OdbcCommandBuilder
Posted on 2006-11-11
I'm trying to use an OdbcCommandBuilder to build an Insert statement for a table.
OdbcDataAdapter adapter = new OdbcDataAdapter(sqlSelect, connectionObject);
OdbcCommandBuilder cmdBuilder = new OdbcCommandBuilder(adapter);
adapter.InsertCommand = cmdBuilder.GetInsertCommand();
When I get to the "adapter.InsertCommand = " statement, I get the following error:
"ERROR - no error information available"
I've used this connection object elsewhere to read info from a table, so I know the connection object is ok.
Is there any way I can get more info on what's happening? Or can anyone suggest any possible solutions?