<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.5730.11" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">More Feedback:</SPAN><?xml:namespace
prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> <o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I managed to track down where in the
odbc module it hangs.</SPAN><o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> <o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">It is in the handle_msg({connect,
ODBCCmd, AutoCommitMode, SrollableCursors}, Timeout,
State) </SPAN><o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">function while doing the following
call gen_tcp:accept(ListenSocketSup, 5000).</SPAN><o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> <o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I can execute odbc:connect as many
times as I want and it works. It only hangs when I do an odbc:disconnect and
odbc:connect .</SPAN><o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </SPAN><o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Unfortunately debugging is a slow
process because this is a customer’s server. On my test server
everything is working.</SPAN><o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> <o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Cheers</SPAN><o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Jan Jacobs</SPAN><o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"></SPAN> </P></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=hpjcon@mweb.co.za href="mailto:hpjcon@mweb.co.za">Jan Jacobs</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=erlang-bugs@erlang.org
href="mailto:erlang-bugs@erlang.org">erlang-bugs@erlang.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Saturday, January 27, 2007 10:14
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [erlang-bugs] ODBC and Windows
2003 Anomaly</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Hi All,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I am experiencing an anomaly with erlang running
the odbc application.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Steps:</FONT></DIV>
<DIV><FONT face=Arial size=2>I start the odbc application. </FONT></DIV>
<DIV><FONT face=Arial size=2>>application:start(odbc).<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Create a odbc connection to the databse. It works
an the queries work.</FONT></DIV>
<DIV><FONT face=Arial
size=2>>f(Ref),{ok,Ref}=odbc:connect("DSN=example;UID=SYSDBA;PWD=masterkey",[]).</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Disconnect from the databse.</FONT></DIV>
<DIV><FONT face=Arial size=2>>odbc:disconnect(Ref).</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Create a new connection. The erlang runtime hangs
and the erlang process CPU runs away.</FONT></DIV>
<DIV><FONT face=Arial
size=2>>f(Ref),{ok,Ref}=odbc:connect("DSN=example;UID=SYSDBA;PWD=masterkey",[]).<BR></FONT></DIV>
<DIV><FONT face=Arial size=2><FONT face=Arial size=2>System
Description:</FONT></DIV>
<DIV>
<DIV><FONT face=Arial size=2>- </FONT><FONT face=Arial size=2>Microsoft
Windows Server 2003, Standard Edition and Service Pack 1.</FONT></DIV>
<DIV><FONT face=Arial size=2>- Erlang 5.5.2 </FONT></DIV>
<DIV> </DIV>
<DIV>Summary:</DIV>
<DIV>The weirdest thing I have an application the follows the same steps as
above which works every time on Windows XP.</DIV>
<DIV>From 10 Windows 2003 servers I have experience the problem three times
already. </DIV>
<DIV> </DIV>
<DIV>I am not sure if I am missing something. Any help will be
appreciated.</DIV>
<DIV> </DIV>
<DIV>Thanks</DIV>
<DIV>Jan Jacobs</DIV>
<DIV> </DIV></FONT></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>erlang-bugs mailing
list<BR>erlang-bugs@erlang.org<BR>http://www.erlang.org/mailman/listinfo/erlang-bugs<BR></BLOCKQUOTE></BODY></HTML>