ODBC and a remote Oracle database

[Serge Aleynikov]

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