Oracle and ODBC erlang driver

yvan.godin@REDACTED yvan.godin@REDACTED
Tue May 27 13:09:09 CEST 2003


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




More information about the erlang-questions mailing list