Running Oracle 18c XE, I have managed to create my database tables, sequences, stored procs, etc and to populate some data in tables using SQLPLUS and SQLDeveloper. The latter uses my Service created by editing tnsnames.ora, so that part is known to work correctly.
When I run a simple Delphi XE6 user program to view the data in a table I get an error “Cannot find the provider” when TADOConnection is called.
My connection string is:
Provider= OraOLEDB.Oracle.1;Password=<pwd>;user ID=MyUser;Data Source=My_Service
My_Service is the same one used above by SQLDeveloper, so that is probably not the problem.
The Oracle Home\bin folder has OraOLEDB18.dll and OraOLEDB18d.dll files, which I assume are the Provider components, along with many others that are part of ODAC, so it seems ODAC was installed when Oracle 18c XE was installed.
What can I do to determine if ODAC was correctly installed, if indeed it is meant to be ? And what other diagnostic steps can I take to figure out what has gone wrong ?
Why is the system not finding the provider ??
Can I do a manual install of ODAC, or should I ??
What steps could I take to move forward, maybe deinstall this or configure that, or whatever.
Any assistance gratefully received.
This problem is especially frustrating as it looks like I am so near and yet so far from a working system.