Perhaps this is something simple, but I am stuck at it at the moment:
I get the error:
"Error reading OraSession1.Options.Direct: Property Direct does not exist." when I try to run my application, and the main form won't show up at all.
It is a very simple application, with an OraSession, an OraQuery, a Dataset and a DBGrid on the form.
At design time, the connection works (I see the data in the grid), but at run time, I get that error.
I checked if the installed OraSession component (bpl) is a different version that the sources, but I rebuilt the component with the same sources and that didn't help.
Another thing is that I could only make the connection with Direct checked. If I don;t check it, I get
"Cannot load OCI DLL: oci.dll."
(running on Windows 7, 64bit)
Thanks for any suggestions
[problem solved] Property Direct does not exist
[problem solved] Property Direct does not exist
Last edited by RPS on Thu 13 May 2010 19:48, edited 1 time in total.
Although the Direct connection still doesn't work,
the real problem for me has now been solved.
After downloading and installing the 32-bit client from Oracle, the error message about the OCI DLL was gone.
Of course this was followed up by a new problem:
"ORA-12504: TNS:listener was not given the SID in CONNECT_DATA".
...
It took some searching to find out that the listener name for the 32-bit client is "orcl.mshome.net" (whereas in SQL Developer it is "orcl").
the real problem for me has now been solved.
After downloading and installing the 32-bit client from Oracle, the error message about the OCI DLL was gone.
Of course this was followed up by a new problem:
"ORA-12504: TNS:listener was not given the SID in CONNECT_DATA".
...
It took some searching to find out that the listener name for the 32-bit client is "orcl.mshome.net" (whereas in SQL Developer it is "orcl").
Hello
The problem is that you have different versions of sources and ODAC components.
Try to do the following:
- remove all sources from disk
- uninstall ODAC components
- check that all libraries, packagesб and sources were removed
-> find all files by mask “*dac*.bpl”, “*dac*.dcp”, “*dac*.rsm” in the folder where Delphi is installed and remove these files
-> find all files by mask “*dac*.bpl”, “*dac*.dcp”, “*dac*.rsm” in the Delphi BPL output directory and remove these files
-> find all files by mask “*dac*.bpl”, “*dac*.dcp”, “*dac*.rsm” in the Delphi DCP output directory and remove these files
- install ODAC again
Now try to compile and run your application again in the direct mode.
If you application is compiled and run successfully then you should download the sources of the same version as you ODAC components are.
If you need an OCI connection then you should configure your TNSNAMES.ORA file. You can find more detailed information about the configuration of the TNSNAMES.ORA file in the Oracle documentation.
The problem is that you have different versions of sources and ODAC components.
Try to do the following:
- remove all sources from disk
- uninstall ODAC components
- check that all libraries, packagesб and sources were removed
-> find all files by mask “*dac*.bpl”, “*dac*.dcp”, “*dac*.rsm” in the folder where Delphi is installed and remove these files
-> find all files by mask “*dac*.bpl”, “*dac*.dcp”, “*dac*.rsm” in the Delphi BPL output directory and remove these files
-> find all files by mask “*dac*.bpl”, “*dac*.dcp”, “*dac*.rsm” in the Delphi DCP output directory and remove these files
- install ODAC again
Now try to compile and run your application again in the direct mode.
If you application is compiled and run successfully then you should download the sources of the same version as you ODAC components are.
If you need an OCI connection then you should configure your TNSNAMES.ORA file. You can find more detailed information about the configuration of the TNSNAMES.ORA file in the Oracle documentation.