ODBC and Oracle

Ingela Anderton <>
Mon Aug 29 14:40:53 CEST 2005


Oracle is one of the databases that we test agains in our automated
test environment. The problem is probably that you have a 2.X driver.
It seems however that you can workaround this by disabling scrollable
cursors.

>From ODBC's User Guide:

1.4 About the Erlang ODBC application

 Provides an Erlang interface to communicate with relational
 SQL-databases. It is built on top of Microsofts ODBC interface and
 therefore requires that you have an ODBC driver to the database that
 you want to connect to. The Erlang ODBC application is designed using
 the version 3.0 of the ODBC-standard, however using the option
 {scrollable_cursors, off} for a connection has been known to make it
 work for at least some 2.X drivers.

-- 
/Ingela - OTP team

Sebastian Bello wrote:
> 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: 
> 
>      
> 
>   
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=Content-Type content="text/html; charset=windows-1252"><BASE 
> href=file://C:\local\firma\>
> <META content="MSHTML 6.00.2600.0" name=GENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=#ffffff background=cid:001b01c5ac94$9f370e90$>
> <DIV>Hi list,</DIV>
> <DIV> </DIV>
> <DIV>has anybody worked accessing an Oracle (in my case 9i) database from Erlang 
> using ODBC?</DIV>
> <DIV>Using the Oracle driver I got the following error:</DIV>
> <DIV> </DIV>
> <DIV><FONT color=#0000ff>odbc:connect(ConnStr, 
> []).<BR>{error,connection_closed}<BR>(</FONT><A 
> href="mailto:)15">)15</A><FONT 
> color=#0000ff>><BR>=CRASH REPORT==== 28-Aug-2005::20:09:37 ===<BR>  
> crasher:<BR>    pid: <0.721.0><BR>    
> registered_name: []<BR>    error_info: 
> {port_exit,collecting_of_driver_information_faild}<BR>    
> initial_call: 
> {gen,init_it,<BR>                      
> [gen_server,<BR>                       
> <0.694.0>,<BR>                       
> <0.694.0>,<BR>                       
> odbc,<BR>                       
> [{client,<0.99.0>}],<BR>                       
> []]}<BR>    ancestors: 
> [odbc_sup,<0.693.0>]<BR>    messages: 
> [{'EXIT',#Port<0.808>,normal}]<BR>    links: 
> [<0.694.0>]<BR>    dictionary: []<BR>    
> trap_exit: true<BR>    status: running<BR>    
> heap_size: 610<BR>    stack_size: 21<BR>    
> reductions: 1552<BR>  neighbours:<BR>(</FONT><A 
> href="mailto:)15">)15</A><FONT 
> color=#0000ff>><BR>=SUPERVISOR REPORT==== 28-Aug-2005::20:09:37 
> ===<BR>     Supervisor: 
> {local,odbc_sup}<BR>     Context:    
> child_terminated<BR>     Reason:     
> {port_exit,collecting_of_driver_information_faild}<BR>     
> Offender:   
> [{pid,<0.721.0>},<BR>                  
> {name,[]},<BR>                  
> {mfa,{odbc,start_link_sup,[[{client,<0.99.0>}]]}},<BR>                  
> {restart_type,temporary},<BR>                  
> {shutdown,7000},<BR>                  
> {child_type,worker}]</FONT></DIV>
> <DIV> </DIV>
> <DIV>Using the Microsoft drivers for Oracle (which seems not to support version 
> 9i) I got the error</DIV>
> <DIV> </DIV>
> <DIV><FONT color=#0000ff>odbc:connect(ConnString, []).<BR>{error,"No SQL-driver 
> information available. Connection to database failed."}</FONT></DIV>
> <DIV> </DIV>
> <DIV>
> <DIV>Any suggestions?</DIV>
> <DIV>Thanks,</DIV>
> <DIV>    Sebastian-</DIV></DIV>
> <DIV> </DIV>
> <DIV>
> <TABLE width="77%" border=0>
>   <TBODY>
>   <TR>
>     <TD vAlign=top width="16%"><IMG 
>       src="cid:001a01c5ac94$9f2fe2a0$"></TD>
>     <TD vAlign=top width="84%">
>       <P><B><FONT face=Verdana color=#000099 size=1>Prepaid Expertise - 
>       Programmable Switches <BR>Powered by Ericsson Licensed 
>       Technology<BR>Sebastián Bello - Engineer - Development Center - IN Switch 
>       Solutions Inc.<BR>Headquarters - Miami-U.S.A. Tel: 1305-3578076 Fax: 
>       1305-7686260<BR>Development Center - Montevideo - Uruguay Tel/Fax: 
>       5982-7104457<BR>IN SWITCH EMEA Phone: +33 0 6 0335 9427 - Fax: +33 0 4 
>       93655773 / <BR>IN SWITCH ASIA Phone: +92 51 2800397/8- 
>       Fax: +92 51 2800399/ <BR>e-mail: 
>       </FONT><FONT face=Verdana color=blue 
>       size=1><BR></FONT></B></P></TD></TR></TBODY></TABLE><B><FONT face=Verdana 
> color=blue size=1></FONT></B></DIV>  </BODY></HTML>











More information about the erlang-questions mailing list