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