<!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.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff background=cid:005a01c5d0dc$f2394830$dc00a8c0@INSWITCH244>
<DIV><FONT face=Arial size=2>Adam,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I installed the Oracle 9.2 Runtime, which includes
client software. I'm using Oracle's driver, and am running on a Windows
box.</FONT></DIV>
<DIV><FONT face=Arial size=2> Sebastian-</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=adam.aquilon@home.se href="mailto:adam.aquilon@home.se">Adam
Aquilon</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=sebastian@inswitch.us
href="mailto:sebastian@inswitch.us">'Sebastian Bello'</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=erlang-questions@erlang.org
href="mailto:erlang-questions@erlang.org">erlang-questions@erlang.org</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, October 14, 2005 1:45
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: ODBC and a remote Oracle
database</DIV>
<DIV><BR></DIV>
<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:005901c5d0dc$f2394830$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>
</BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>