Oracle connection problem with 4D 2004
Luc Devar (2/5/10 11:19AM)
Ben Kershaw (2/5/10 1:01PM)
Luc Devar (2/5/10 11:19 AM)
We have a strange problem when connecting to an Oracle database from
4D.
We used the default Oracle 10g client installation with ODBC driver.
TNS_Admin key is properly set in registry and Tns_names.ora file is
on a network volume.
We use sql plus to test the connection and it works fine. We then
define an ODBC source (DSN) using oracle driver
and the connection still works fine.
Then from 4D, we select import from ODBC source and try to connect to
the Data source previously define in ODBC administrator.
And we get the following message: Could not access the remote server.
Note that this is only happening with Oracle database. WeÇve tested
with SQL Server database and it works fine. It seems that 4D has
difficulties finding the tnsnames.ora files.
We try the tech tips #41706 from 4DKB without success. We have two
other similar installations that work fine just fine
Any suggestions where to go after all those tests.
Ben Kershaw (2/5/10 1:01 PM)
Luc Devar wrote:
color><param>00000,08CF,D8CC/param>WWe have a strange problem when
connecting to an Oracle database from 4D.
/color>
Have you tried tns ping? That's the first place I start when trying to
track down connection problems. Try it from the command line; if TNS
ping can see the server, then you know the tnsnames.ora file is
working OK and your Oracle network setup is good.
Have you tried it with OCI? If neither OCI or ODBC works, it may not
be a 4D issue. Does ODBC work from something else, like Excel?
A while ago I had an issue connecting via OCI, and the only way I
could get it to work was to define the database name as the full path
(as you would enter it in the tnsnames.ora file). For example:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XXX.XXX.XXX.XXX)(PORT=
1521))(CONNECT_DATA=(SERVICE_NAME=MyServiceName)))
Does the ODBC admin window allow you to define the database name this
way? It may be worth trying.
Regards,
Ben Kershaw
Reply to this message
Summary created 2/5/10 at 1:22PM by Intellex Corporation
Comments welcome at: feedback@intellexcorp.com