ODBC and a remote Oracle database

[Sebastian Bello]

Serge,

tnsping works fine:

C:\oracle\ora92\bin>tnsping TEST

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 14-OCT-20
05 14:40:17

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = INSWITCH-APP)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = TEST)))
OK (30 msec)

And yes, the DSN is defined in Control Panel\Administrative Tools\Data Sources.
    Sebastian-

----- Original Message ----- 
From: "Serge Aleynikov" <serge@REDACTED>
To: "Sebastian Bello" <sebastian@REDACTED>
Cc: "Erlang Questions" <erlang-questions@REDACTED>
Sent: Friday, October 14, 2005 2:32 PM
Subject: Re: ODBC and a remote Oracle database


> Make sure that Oracle client and the ODBC is configured properly:
> 
> If you are on Windows/UNIX, try:
> 
> tnsping DATABASE_ALIAS
> 
> If this doesn't return "ok", it means that your client is missing 
> configuration in tnsnames.ora, which is usually found in:
> $ORACLE_HOME/network/admin
> 
> Otherwise make sure that ODBC has a DSN entry for the database you are 
> trying to connect to.  Verify it by using:
> 
> On Windows: Control Panel\Administrative Tools\Data Sources (ODBC)
> On Unix: run ODBCConfig (if you are using unixODBC)
> 
> Serge
> 
> Sebastian Bello wrote:
> > Hi all,
> >  
> > 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
> >     {error,"No SQL-driver information available. Connection to database 
> > failed."}
> > The same configuration works fine when ran in the machine where Oracle runs.
> >  
> > Should a different connection string be used? Any other 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 / 
> > emea@REDACTED
> > IN SWITCH ASIA Phone: +92 51 2800397/8- Fax: +92 51 2800399/ 
> > inswasia@REDACTED
> > e-mail: sebastian@REDACTED
> > *
> > 
> > **
> >  
> 
> -- 
> Serge Aleynikov
> R&D Telecom, IDT Corp.
> Tel: (973) 438-3436
> Fax: (973) 438-1464
> serge@REDACTED
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://erlang.org/pipermail/erlang-questions/attachments/20051014/21c62196/attachment.htm>