<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1"><BASE
href=file://C:\local\firma\>
<META content="MSHTML 6.00.2900.2722" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff background=cid:937303715@14102005-1E58>
<DIV dir=ltr align=left><SPAN class=937303715-14102005><FONT face=Arial
color=#0000ff size=2>Hi!</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=937303715-14102005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=937303715-14102005><FONT face=Arial
color=#0000ff size=2>I'm hardly an expert at ODBC or the erlang interface, but
maybe it could be that the local</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=937303715-14102005><FONT face=Arial
color=#0000ff size=2>machine is lacking the odbc drivers? Or maybe the config
files. Are you using some kind</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=937303715-14102005><FONT face=Arial
color=#0000ff size=2>of Oracle-provided ODBC client library?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=937303715-14102005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=937303715-14102005><FONT face=Arial
color=#0000ff size=2>Oracle also have their own OCI library -- Oracle
C</FONT></SPAN><SPAN class=937303715-14102005><FONT face=Arial color=#0000ff
size=2>all Interface. I seem to remember that</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=937303715-14102005><FONT face=Arial
color=#0000ff size=2>the "tnsnames.ora" file was involved in that
interface.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=937303715-14102005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=937303715-14102005><FONT face=Arial
color=#0000ff size=2>We use the "unixODBC-2.2.3-6" package on old RedHat 9
servers.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=937303715-14102005><FONT face=Arial
color=#0000ff size=2>It depends on config info in "/etc/odbc.ini" and
"/etc/odbcinst.ini".</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=937303715-14102005><FONT face=Arial
color=#0000ff size=2>They contain settings like server, port, database name,
driver shareable object</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=937303715-14102005><FONT face=Arial
color=#0000ff size=2>library etc.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=937303715-14102005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=937303715-14102005><FONT face=Arial
color=#0000ff size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=937303715-14102005><FONT face=Arial
color=#0000ff size=2>/Adam Aquilon</FONT></SPAN></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT><BR> </DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> owner-erlang-questions@erlang.org
[mailto:owner-erlang-questions@erlang.org] <B>On Behalf Of </B>Sebastian
Bello<BR><B>Sent:</B> Friday, October 14, 2005 5:28 PM<BR><B>To:</B>
erlang-questions@erlang.org<BR><B>Subject:</B> ODBC and a remote Oracle
database<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Hi all,</DIV>
<DIV> </DIV>
<DIV>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</DIV>
<DIV> {error,"No SQL-driver information available.
Connection to database failed."}</DIV>
<DIV>The same configuration works fine when ran in the machine where Oracle
runs.</DIV>
<DIV> </DIV>
<DIV>Should a different connection string be used? Any other
suggestions?</DIV>
<DIV>Thanks,</DIV>
<DIV> Sebastian-</DIV>
<DIV> </DIV>
<DIV>
<TABLE width="77%" border=0>
<TBODY>
<TR>
<TD vAlign=top width="16%"><IMG src="cid:937303715@14102005-1E51"></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> </BLOCKQUOTE></BODY></HTML>