Hi Graham > -----Original Message----- > From: Graham Keys [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 13. November 2003 00:44 > To: [EMAIL PROTECTED] > Subject: SQLMode > > > Using 'C' and 'ODBC' on Linux. Can anyone give me an example > of how to set > SQLMode = ORACLE.
You can either specify the sqlmode in the connect string (SQLMODE=ORACLE;) or you can set it in the DSN (ODBC-Admin -> Configure -> Settings). On Unix add the line SQLMODE = ORACLE in you DSN. Setting it with SQLSet...Attr actually following constants are missing: #define SQL_SQLMODE SQL_CONNECT_OPT_DRVR_START+2 #define SQLMODE_INTERNAL 1 #define SQLMODE_DB2 2 #define SQLMODE_ANSI 3 #define SQLMODE_ORACLE 4 Originally this was only intended for internal use and therefore is missing in the ODBC-headers. I'm going to change this. HTH Thomas ---------------------------------------------- Dr. Thomas K�tter SAP DB, SAP Labs Berlin Do you know SAP^H^H^H MaxDB ? www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
