<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=Arial size=2>Serge,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>tnsping works fine:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#008080 size=2>C:\oracle\ora92\bin>tnsping
TEST</FONT></DIV>
<DIV><FONT face=Arial color=#008080 size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#008080 size=2>TNS Ping Utility for 32-bit Windows:
Version 9.2.0.1.0 - Production on 14-OCT-20<BR>05 14:40:17</FONT></DIV>
<DIV><FONT face=Arial color=#008080 size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#008080 size=2>Copyright (c) 1997 Oracle
Corporation. All rights reserved.</FONT></DIV>
<DIV><FONT face=Arial color=#008080 size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#008080 size=2>Used parameter files:</FONT></DIV>
<DIV><FONT face=Arial color=#008080 size=2></FONT> </DIV>
<DIV><BR><FONT face=Arial color=#008080 size=2>Used TNSNAMES adapter to resolve
the alias<BR>Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
(PROTOCOL = TCP)<BR>(HOST = INSWITCH-APP)(PORT = 1521))) (CONNECT_DATA =
(SERVICE_NAME = TEST)))<BR>OK (30 msec)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>And yes, the DSN is defined in Control
Panel\Administrative Tools\Data Sources.</FONT></DIV>
<DIV><FONT face=Arial size=2> Sebastian-</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>----- Original Message ----- </FONT>
<DIV><FONT face=Arial size=2>From: "Serge Aleynikov" <</FONT><A
href="mailto:serge@hq.idt.net"><FONT face=Arial
size=2>serge@hq.idt.net</FONT></A><FONT face=Arial size=2>></FONT></DIV>
<DIV><FONT face=Arial size=2>To: "Sebastian Bello" <</FONT><A
href="mailto:sebastian@inswitch.us"><FONT face=Arial
size=2>sebastian@inswitch.us</FONT></A><FONT face=Arial size=2>></FONT></DIV>
<DIV><FONT face=Arial size=2>Cc: "Erlang Questions" <</FONT><A
href="mailto:erlang-questions@erlang.org"><FONT face=Arial
size=2>erlang-questions@erlang.org</FONT></A><FONT face=Arial
size=2>></FONT></DIV>
<DIV><FONT face=Arial size=2>Sent: Friday, October 14, 2005 2:32 PM</FONT></DIV>
<DIV><FONT face=Arial size=2>Subject: Re: ODBC and a remote Oracle
database</FONT></DIV></DIV>
<DIV><FONT face=Arial><BR><FONT size=2></FONT></FONT></DIV><FONT face=Arial
size=2>> Make sure that Oracle client and the ODBC is configured
properly:<BR>> <BR>> If you are on Windows/UNIX, try:<BR>> <BR>>
tnsping DATABASE_ALIAS<BR>> <BR>> If this doesn't return "ok", it means
that your client is missing <BR>> configuration in tnsnames.ora, which is
usually found in:<BR>> $ORACLE_HOME/network/admin<BR>> <BR>> Otherwise
make sure that ODBC has a DSN entry for the database you are <BR>> trying to
connect to. Verify it by using:<BR>> <BR>> On Windows: Control
Panel\Administrative Tools\Data Sources (ODBC)<BR>> On Unix: run ODBCConfig
(if you are using unixODBC)<BR>> <BR>> Serge<BR>> <BR>> Sebastian
Bello wrote:<BR>> > Hi all,<BR>> > <BR>> > I'm trying to
access a remote Oracle database from Erlang through ODBC. <BR>> > I define
the DSN pointing to a TNS Service Name which points to a remote <BR>> >
Oracle database (and use Oracle's ODBC driver). Using the connection <BR>>
> string "DSN=ev;UID=test;PWD=test" I get error<BR>>
> {error,"No SQL-driver information available.
Connection to database <BR>> > failed."}<BR>> > The same
configuration works fine when ran in the machine where Oracle runs.<BR>>
> <BR>> > Should a different connection string be used? Any other
suggestions?<BR>> > Thanks,<BR>> >
Sebastian-<BR>> > <BR>> > <BR>> > <BR>> > *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>> > </FONT><A
href="mailto:emea@inswitch.us"><FONT face=Arial
size=2>emea@inswitch.us</FONT></A><BR><FONT face=Arial size=2>> > IN
SWITCH ASIA Phone: +92 51 2800397/8- Fax: +92 51 2800399/ <BR>> >
</FONT><A href="mailto:inswasia@inswitch.us"><FONT face=Arial
size=2>inswasia@inswitch.us</FONT></A><BR><FONT face=Arial size=2>> >
e-mail: </FONT><A href="mailto:sebastian@inswitch.us"><FONT face=Arial
size=2>sebastian@inswitch.us</FONT></A><BR><FONT face=Arial size=2>> >
*<BR>> > <BR>> > **<BR>> > <BR>> <BR>> -- <BR>>
Serge Aleynikov<BR>> R&D Telecom, IDT Corp.<BR>> Tel: (973)
438-3436<BR>> Fax: (973) 438-1464<BR>> </FONT><A
href="mailto:serge@hq.idt.net"><FONT face=Arial
size=2>serge@hq.idt.net</FONT></A></BODY></HTML>