Oracle and ODBC erlang driver

[Ingela Anderton]

The erlang ODBC application consists of an erlang part and a C-part.
The C-part delivered for the W2K platform is compiled to work with
sqlserver. Have you recompiled it to link with your oracle driver?
The C-process has crashed for some reason. We need to set some
environment variables to make oracle happy could that be the problem?

Here at OTP we have tested odbc with oracle on solaris and with
sqlserver on windows both work well.

The version of ODBC used by Hal is obsolete an unsupported!  

Please let me know how it goes.

-- 
/Ingela

Ericsson AB - OTP team


yvan.godin@REDACTED wrote:
> Hello
> 
> I would like to have a try with Erlang and Oracle
> 
> but I have some problems with ODBC ORACLE acces on W2K (and same in NT4)
> when I try to connect my database withing erl (werl) 
> 
> {ok,Ref} =
> odbc:connect("UID=<MYUSER>;PWD=<MYPASS>;DBQ=<MYTNS>;DSN=<MYDSN>",[{driver_trace,on}]).
> ** exited: {{badmatch,{error,connection_closed}},[{erl_eval,expr,3}]} **
> 
> =ERROR REPORT==== 27-May-2003::11:44:05 ===
> ** Generic server <0.112.0> terminating
> ** Last message in was {'EXIT',#Port<0.72>,normal}
> ** When Server state == {state,#Port<0.72>,
>                                {<0.110.0>,#Ref<0.0.0.526>},
>                                <0.110.0>,
>                                undefined,
>                                on,
>                                undefined,
>                                undefined,
>                                on,
>                                connecting,
>                                undefined,
>                                0,
>                                false,
>                                false,
>                                []}
> 
> LOG FILE
> ***********************************************************************
> Fatal NI connect error 12560, connecting to:
>  (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDR
> ESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=c:\PROGRA~1\ERL523~1.3\lib\odbc-1.0.5\priv\bin
> \odbcserver.exe)(HOST=<host>)(USER=<user>))))
> 
>   VERSION INFORMATION:
>         TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
>         Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version
> 8.1.7.0.0 - Production
>   Time: 27-MAI-2003 11:27:36
>   Tracing not turned on.
>   Tns error struct:
>     nr err code: 0
>     ns main err code: 12560
>     TNS-12560: TNS : erreur d'adaptateur de protocole
>     ns secondary err code: 0
>     nt main err code: 530
>     TNS-00530: Erreur d'adaptateur de protocole
>     nt secondary err code: 126
>     nt OS err code: 0
> 
>   on the log file the SID ORCL do not correspond to my TNS SID ... is that a
> normal way ??
> 	  
> NB:some string have been replaced by <SPEUDO> 
>   :the ODBC connection work fine with VisualBasic or Oracle ODBC Test
>   :release Erlang R9B-1
>   
> 
> 
> 
> Thank's for any idea or help 
>   
>   
>   
>   Yvan