We have a ColdFusion application that updates an oracle database that we use to update information on AssetCenter. The dba added a user called connectit. I am using a native oracle connector.

When I configure the database server connection I use the following information:
Code:
Server        => ORDSYSQA
User          => connectit 
Password      => *****
Diagram owner => nyenetorders
If we have a blank diagram owner the scenario doesn't see the table.

However, now I have problems coding the "Configure the reconnection parameters" "Test connection query".

Code:
The test connection query 'SELECT sysDate from dual' is not supported by the server.
I have tried the query statement using a semi-colon, using "sys.dual" with and without a semi-colon, and we are consistently getting the same error message. I have also tried using "select count(*) from orderexchange" using this query both with and without a semi-colon and with an without the owner name (i.e. nyenetorders.orderexchange).

Has anyone seen this situation before?