<!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$dc00a8c0@INSWITCH244>
<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:web@JOR_PLAT0)15">web@JOR_PLAT0)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:web@JOR_PLAT0)15">web@JOR_PLAT0)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$dc00a8c0@INSWITCH244"></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 / emea@inswitch.us<BR>IN SWITCH ASIA Phone: +92 51 2800397/8-
Fax: +92 51 2800399/ inswasia@inswitch.us<BR>e-mail:
sebastian@inswitch.us</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>