RE: SQLSTATE mapping problem

2005-02-01 Thread lakshmi.narasimharao
@lists.mysql.com Subject: SQLSTATE mapping problem Hi all, We are using MySQL ODBC 3.51 driver for db connection. When executing an SQL statement using SQLExecDirect() function and if there is a syntax error in the SQL statement, the SQLSTATE returned by the driver is "23000" (which stands f

SQLSTATE mapping problem

2005-02-01 Thread lakshmi.narasimharao
Hi all, We are using MySQL ODBC 3.51 driver for db connection. When executing an SQL statement using SQLExecDirect() function and if there is a syntax error in the SQL statement, the SQLSTATE returned by the driver is "23000" (which stands for invalid constraint/duplicate keys.) instead of "42