Devart Forums

I don't know if I'm being thick or not but cannot connect to Oracle 9i using ORA Developer Tools. Looking at the litterature it talks about 'local' connections.
Does this mean I cannot connect over the LAN to a remote server?

Using ODAC VCL I can connect OK with no problems except that ORAQuery does not list available tables in the 'Generate SQL' tab drop down. Filling in a 'known' table name works OK though.

I'm new to Oracle so any suggestions would be most welcome!

Previously used Ora Studio (Trial) with no problems too.

BTW, continuous changing of the parameters on the Tools Connection eventually causes Delphi 2007 to lock up and has to be re-booted.

You do can connect to remote servers.
What problem exactly did you encounter?

Hi Duke,

Thanks for taking the time to respond.

When I fill in Username, Password and server on OraSession I get a connection with no problem.

On the tools DB General connection there is Host, User & password - assuming that 'Host' = 'Server' as above.
Used the same data and get an error:
"ORA 1245 - Connect failed because target host or object does not exist."

Now somewhat confused as the 'Host' is a pulldown and the two 'server names' I had previously entered appear as options - looks like ORA remembers the entries and doesn't perform a 'look-up' on available servers per se.
One I know is the correct server name, the other the wrong one.

Perhaps I'm missing an Oracle DLL somewhere along the line?
Have tried direct connection too with no joy.

Thanks for the help.

Such error comes when the address of the server is not valid. If you are using OCI mode you need to take following actions.

Ensure the ADDRESS parameters have been entered correctly; the most likely incorrect parameter is the node name. Ensure that the executable for the server exists (perhaps "oracle" is missing.) If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the host name to a numeric IP address and try again.

For direct mode just enter correct IP (or address) in the host field.

Just for the record, if I enter the IP address as the host everything seems to work fine.
What I can't understand is why it's not picking up the tnsnames.ora file info?
The commercial app on the same PC works Ok in this regard (well I know it doesn't connect via TCP as the address has changed!).

What I can't understand is why it's not picking up the tnsnames.ora file info?

Are you trying to connect using Direct mode?