[archive] AcuODBC and ADO.NET ODBC provider problem
[Migrated content. Thread originally posted on 10 August 2004]Reading data via AcuODBC from the ADO.NET ODBC data provider works fine, and acucorp has a VB.NET example of this in their downloads area.However, there are problems when trying to implement more advanced features of the OdbcDataAdapter to allow dataset/datatable updates to persist back to the AcuODBC datasource. For instance in Visual Studio.NET 2003, when you drop an OdbcDataAdapter component onto your form, a handy wizard appears allowing you to specify your connection object, and to specify your select query, which in turn will generate four command objects for you: select, insert, update, and delete command objects. This is very helpful. The problem is that the wizard seems to be unable to retrieve the schema from the AcuODBC driver correctly and the paramater collections for the command objects cannot be created, which appears to stop the insert, update and delete command objects from rendering. The wizard actuall