![]() |
|
#1
|
|||
|
|||
|
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!! ![]() |
|
#2
|
|||
|
|||
|
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/...sdk/sdkupdate/ and MDAC SDK. |
![]() |
| Thread Tools | |
| Display Modes | |
|
|