Share this page 

"Access or violation" error using timestamp with OracleTag(s): Common problems


Using the ODBC escape sequence {ts to represent a timestamp value, you may receive the error "Access violation" if your query looks like 
{ ts '2003-03-25 00:00:00' }
With Oracle, you have to add the milliseconds part. So use this instead 
{ ts '2003-03-25 00:00:00.000000' }
mail_outline
Send comment, question or suggestion to howto@rgagnon.com