How to connect to Oracle 10g Express from Delphi XE
Posted on 2011-10-07
I have Delphi XE Professional running on Windows 7 Professional (64 bit).
I would like my Delphi app to be able to connect to an Oracle database running on another machine on the same LAN. It is Oracle 10g Express Edition running on Windows XP Home Edition.
I have tried downloading Oracle stuff to get ODBC or OLEDB drivers installed but have found it unbelievably complicated and got in a complete mess. So, I have uninstalled all the Oracle stuff (and they don't make that very easy) to make a fresh start.
In my Delphi app, I am using a TADOConnection and would like to be able to specify something like "FILE=MyOracle.udl" for the ConnectionString. So, the Delphi bit of this is technically irrelevant because it will work fine if I can just get the data link in a UDL file to work.
So, my question is: what should I download from Oracle (please give a link) to get connected?
(If it helps, I used to be able to do this just fine on an XP machine using the "Oracle Provider for OLE DB".)