0 Replies Latest reply: Mar 3, 2008 8:01 AM by conrad RSS

Oracle ODBC Connection to Remedy Database

conrad

Hi All,

Has anyone used an Oracle ODBC Connection to the Remedy Database? I am currently having an issue that any query sent to the database either via Crystal or Remedy Reports, it is sending the query suffixed with Order By 1 Asc, while there  is no sort order specified anywhere. Even if its a query that is sent to the Remedy Database based on a specific Request ID it is doing Order by 1 Asc while it is absolutely unnecessary.

I want to know why it could be suffixed this way and if there is a way to remove this Order By 1 Asc. Also if anyone has steps on configuring the Oracle ODBC connection to the Remedy Database. The version is ARS 6.3, Oracle 9i. I have over half a million records that I am trying to get a Crystal Report out and it gives me an error "Failed to open rowset". Query Engine Error: 'S000:[AR System ODBC Driver]Cannot open catalog; Message number=94.<server name>

Thanks in advance.