ODBC and Oracle

Sebastian Bello <>
Mon Aug 29 14:24:37 CEST 2005


Hi list,

has anybody worked accessing an Oracle (in my case 9i) database from Erlang using ODBC?
Using the Oracle driver I got the following error:

odbc:connect(ConnStr, []).
{error,connection_closed}
()15>
=CRASH REPORT==== 28-Aug-2005::20:09:37 ===
  crasher:
    pid: <0.721.0>
    registered_name: []
    error_info: {port_exit,collecting_of_driver_information_faild}
    initial_call: {gen,init_it,
                      [gen_server,
                       <0.694.0>,
                       <0.694.0>,
                       odbc,
                       [{client,<0.99.0>}],
                       []]}
    ancestors: [odbc_sup,<0.693.0>]
    messages: [{'EXIT',#Port<0.808>,normal}]
    links: [<0.694.0>]
    dictionary: []
    trap_exit: true
    status: running
    heap_size: 610
    stack_size: 21
    reductions: 1552
  neighbours:
()15>
=SUPERVISOR REPORT==== 28-Aug-2005::20:09:37 ===
     Supervisor: {local,odbc_sup}
     Context:    child_terminated
     Reason:     {port_exit,collecting_of_driver_information_faild}
     Offender:   [{pid,<0.721.0>},
                  {name,[]},
                  {mfa,{odbc,start_link_sup,[[{client,<0.99.0>}]]}},
                  {restart_type,temporary},
                  {shutdown,7000},
                  {child_type,worker}]

Using the Microsoft drivers for Oracle (which seems not to support version 9i) I got the error

odbc:connect(ConnString, []).
{error,"No SQL-driver information available. Connection to database failed."}

Any 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 / 
      IN SWITCH ASIA Phone: +92 51 2800397/8- Fax: +92 51 2800399/ 
      e-mail: 

     

  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://erlang.org/pipermail/erlang-questions/attachments/20050829/b5fcce0f/attachment.html>
-------------- 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/20050829/b5fcce0f/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/20050829/b5fcce0f/attachment-0001.gif>


More information about the erlang-questions mailing list