odbc problem

Anders Nygren <>
Sat Apr 2 00:22:33 CEST 2005


Hi 
I am trying to use odbc and have run into a strange problem.
Using R10B-2 on Windows XP, with Microsoft SQL Server2000.
The data is inserted in the table on the sql server but for some
reason the connection is lost.

I have tried to trace the odbc driver with {trace_driver,on}
but it does not look very interesting, (but what do I know),
I have attatched it anyway.

/Anders Nygren


Eshell V5.4.3
()26>
{ok,Ref1}=odbc:connect("DSN=LocalServer;UID=sa;PWD=",[]).
{ok,<0.186.0>}
()27> odbc:param_query(Ref1,"insert into MESSAGE
(ID,TELEPHONE) values(?,?)",
[{{sql_varchar,13},["123454678"]},{{sql_varchar,10},["2345"]}]).
{error,connection_closed}
=ERROR REPORT==== 1-Apr-2005::13:10:26 ===
** Generic server <0.186.0> terminating
** Last message in was {#Port<0.614>,{exit_status,14}}
** When Server state == {state,#Port<0.614>,
                               {<0.183.0>,#Ref<0.0.0.1758>},
                               <0.183.0>,
                               undefined,
                               on,
                               true,
                               true,
                               on,
                               connected,
                               undefined,
                               0,
                               [#Port<0.612>,#Port<0.613>],
                               #Port<0.615>,
                               #Port<0.616>}
** Reason for termination ==
** {port_exit,socket_send_message_body_failed}


=CRASH REPORT==== 1-Apr-2005::13:10:26 ===
  crasher:
    pid: <0.186.0>
    registered_name: []
    error_info: {port_exit,socket_send_message_body_failed}
    initial_call: {gen,init_it,
                      [gen_server,
                       <0.111.0>,
                       <0.111.0>,
                       odbc,
                       [{client,<0.183.0>}],
                       []]}
    ancestors: [odbc_sup,<0.110.0>]
    messages: [{'EXIT',#Port<0.614>,normal}]
    links: [<0.111.0>]
    dictionary: []
    trap_exit: true
    status: running
    heap_size: 610
    stack_size: 21
    reductions: 1581
  neighbours:
()28>
=SUPERVISOR REPORT==== 1-Apr-2005::13:10:26 ===
     Supervisor: {local,odbc_sup}
     Context:    child_terminated
     Reason:     {port_exit,socket_send_message_body_failed}
     Offender:   [{pid,<0.186.0>},
                  {name,[]},
                  {mfa,{odbc,start_link_sup,[[{client,<0.183.0>}]]}},
                  {restart_type,temporary},
                  {shutdown,7000},
                  {child_type,worker}]
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SQL.LOG
Type: application/octet-stream
Size: 13168 bytes
Desc: not available
URL: <http://erlang.org/pipermail/erlang-questions/attachments/20050401/28716d1b/attachment.obj>


More information about the erlang-questions mailing list