[Migrated content. Thread originally posted on 08 September 2003]

When I link up to a sql server database using an ODBC dsn, and I display the SQLCODE, the value is 1. I can display records from the tables, but I can't seem to update or add records.
Does anyone know where I can get a list of SQLCODE values and their meanings???
Thank You!!:confused:

Given that you cannot add or modify records, the return status is most likely SQL_MODE_READ_ONLY. Which means your connection has been opened for RO. You may know that the AcuODBC product can be delivered with a RO license? Chances are, this is what you got.
As for future references, your best source of these codes would be the ODBC SDK from Microsoft.
You could look at

http://www.microsoft.com/msdownload/platformsdk/sdkupdate/

and MDAC SDK.

---