ODBC and a remote Oracle database

Michael McDaniel <>
Fri Oct 14 21:38:44 CEST 2005


Perhaps ODBCINI and ODBCSYSINI need setting, pointing
to proper files describing the (remote) server/database?

>From within an application I do

os:putenv("ODBCINI", "/etc/unixODBC/odbc.ini") ,
os:putenv("ODBCSYSINI", "/etc/unixODBC/odbcinst.ini") ,


~Michael


On Fri, Oct 14, 2005 at 12:32:23PM -0400, Serge Aleynikov wrote:
> 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 / 
> >
> >IN SWITCH ASIA Phone: +92 51 2800397/8- Fax: +92 51 2800399/ 
> >
> >e-mail: 
> >*
> >
> >**
> > 
> 
> -- 
> Serge Aleynikov
> R&D Telecom, IDT Corp.
> Tel: (973) 438-3436
> Fax: (973) 438-1464
> 

-- 
Michael McDaniel
Portland, Oregon, USA
http://autosys.us
+1 503 283 5284



More information about the erlang-questions mailing list