ODBC and a remote Oracle database

[Sebastian Bello]

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