We have a customer using Oracle 8.0.5 db server and has problem w/ one of our insert statement when using ODBC connection. More specifically, the {ts 'YYYY-MM-DD HH:MI:SS'} failed since that server can't recognize the ODBC datetime escape sequence.

I tried that same insert statement on my server (8i and 9i) using ODBC connection and they both worked fine. So my question is:

Is there anyway to turn on ANSI settings on Oracle 8.0.5 server? If yes, how?