Error attempting to add records to a Postgres database table

0 Likes

Attempting to add a record to a Postgres database table using AcuSQL encounters errors.

Problem:

Attempting to add a record to a Postgres database table using AcuSQL encounters errors:

SQLCODE = -1, SQLSTATE = 42000, SQLERRMC = Attempt to execute nonexistent, unprepared or invalid statement SQLIST.

Resolution:

With the more recent ODBC drivers for UNIX and Linux the ReadOnly entry in the odbc.ini file needs to be set to NO. Once this is done any of the operations that modify data in the table (INSERT, UPDATE, DELETE) will work without error.

Incident Number: 2220456

Old KB# 14527
Comment List
Anonymous
Related Discussions
Recommended