ODBC and a remote Oracle database

[Adam Aquilon]

Hi!
 
I'm hardly an expert at ODBC or the erlang interface, but maybe it could
be that the local
machine is lacking the odbc drivers? Or maybe the config files. Are you
using some kind
of Oracle-provided ODBC client library?
 
Oracle also have their own OCI library -- Oracle Call Interface. I seem
to remember that
the "tnsnames.ora" file was involved in that interface.
 
We use the "unixODBC-2.2.3-6" package on old RedHat 9 servers.
It depends on config info in "/etc/odbc.ini" and "/etc/odbcinst.ini".
They contain settings like server, port, database name, driver shareable
object
library etc.
 
Hope that helps,
/Adam Aquilon

 

  _____  

From: owner-erlang-questions@REDACTED
[mailto:owner-erlang-questions@REDACTED] On Behalf Of Sebastian Bello
Sent: Friday, October 14, 2005 5:28 PM
To: erlang-questions@REDACTED
Subject: ODBC and a remote Oracle database


Hi all,
 
I'm trying to access a remote Oracle database from Erlang through ODBC.
I define the DSN pointing to a TNS Service Name which points to a remote
Oracle database (and use Oracle's ODBC driver). Using the connection
string "DSN=ev;UID=test;PWD=test" I get error
    {error,"No SQL-driver information available. Connection to database
failed."}
The same configuration works fine when ran in the machine where Oracle
runs.
 
Should a different connection string be used? Any other suggestions?
Thanks,
    Sebastian-
 
	 
Prepaid Expertise - Programmable Switches 
Powered by Ericsson Licensed Technology
Sebastián Bello - Engineer - Development Center - IN Switch Solutions
Inc.
Headquarters - Miami-U.S.A. Tel: 1305-3578076 Fax: 1305-7686260
Development Center - Montevideo - Uruguay Tel/Fax: 5982-7104457
IN SWITCH EMEA Phone: +33 0 6 0335 9427 - Fax: +33 0 4 93655773 /
emea@REDACTED
IN SWITCH ASIA Phone: +92 51 2800397/8- Fax: +92 51 2800399/
inswasia@REDACTED
e-mail: sebastian@REDACTED



  

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://erlang.org/pipermail/erlang-questions/attachments/20051014/5eaaf16b/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 1429 bytes
Desc: not available
URL: <http://erlang.org/pipermail/erlang-questions/attachments/20051014/5eaaf16b/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: logoparafondo.gif
Type: image/gif
Size: 16886 bytes
Desc: not available
URL: <http://erlang.org/pipermail/erlang-questions/attachments/20051014/5eaaf16b/attachment-0001.gif>