Can anyone please submit a working example of how to perform an INSERT statement to insert a record into a table on SQL Server 2000. We know the ODBC DSN requirements we just can not seem to get an INSERT statement to work. We can do all the UPDATE statements we want, just not the INSERT. Thanks for any help you can offer.
Subject: Insert SQL statement for SQL Server 2000
There is a good example in the Help Text for how to insert a row into a table via ODBC - search for “ODBCResultSet”
Essentially you need to add an Empty row, and then update it.
Stating the obvious, ensure your DSN allows additions.