Database connection for Oracle Database 10g

[ker0k3n0]

Hello everyone,

What is the best way to make a CR DB connection for Oracle Database 10g? I currently use OLE DB (ADO) with MS OLE DB Provider for Oracle and sometimes my report runs very slow.

I was talked one way and need to explore my options.

Thanks,
Phoebe

 

[Turkbear]

Hi,
The slowness may not be due to the connection method, but I would use the Oracle Server connection since it is the 'native' Oracle method.

Try running the SQL generated by your report directly in Oracle ( using SqlPlus or Sql Workshop) and see how long it takes to return records.





To Paraphrase:"The Help you get is proportional to the Help you give.."