ODBC and a remote Oracle database

[Sebastian Bello]

Adam,

I installed the Oracle 9.2 Runtime, which includes client software. I'm using Oracle's driver, and am running on a Windows box.
    Sebastian-
  ----- Original Message ----- 
  From: Adam Aquilon 
  To: 'Sebastian Bello' 
  Cc: erlang-questions@REDACTED 
  Sent: Friday, October 14, 2005 1:45 PM
  Subject: RE: ODBC and a remote Oracle database


  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/ad266c26/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/ad266c26/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/ad266c26/attachment-0001.gif>