Erlang ODBC terminated, Microsoft ODBC--Oracle 11G combination
===

I have always connected with Oracle from Erlang, and i have been able to work with a lot of data from Oracle into Erlang applications. I connect to Oracle using Microsoft ODBC administrator and i always have Oracle ODBC Drivers installed very well. For connectivity, consider this code: <a href="http://stackoverflow.com/a/9256366/431620">http://stackoverflow.com/a/9256366/431620</a> <br><br> Recently i have created a table with a column whose Data type is a `CLOB`. Now, reading <a href="http://support.microsoft.com/kb/244661">here</a>, Microsoft seemed to say that there are limitations of the odbc system with certain oracle data types such as `CLOB`. Now, when the text i write in the `CLOB` column is smaller, the query returns suceesfully:<pre>
C:\Users\muzaayj\Desktop>erl
Eshell V5.9  (abort with ^G)
1> {_,D} = connect_oracle:connect().
{true,<0.36.0>}
2> SQL  = "insert into image (image,svg) values ('test','wiuefgweiufgeiufgei')".
"insert into image (image,svg) values ('test','wiuefgweiufgeiufgei')"
3> connect_oracle:send_sql(D,SQL).
{updated,1}
</pre>
Now, when i attempt to write there text whose length is more than `50,000` , the connection gets closed and the odbc server crashes.<pre>
=ERROR REPORT==== 16-Jul-2012::14:16:42 ===
ODBC: received unexpected info: {tcp_closed,#Port<0.732>}


=ERROR REPORT==== 16-Jul-2012::14:16:43 ===
** Generic server <0.36.0> terminating
** Last message in was {#Port<0.730>,{exit_status,1}}
** When Server state == {state,#Port<0.730>,
                               {<0.30.0>,#Ref<0.0.0.96>},
                               <0.30.0>,undefined,on,false,false,off,
                               connected,undefined,0,
                               [#Port<0.723>,#Port<0.724>],
                               #Port<0.731>,#Port<0.732>}
** Reason for termination ==
** {port_exit,abnormal_exit}
{error,connection_closed}
</pre>
Now, everything is okay with the connection, the queries, the database e.t.c. but i think i am hitting limits somewhere. This query doesnot reach the Oracle Database. It seems to be closed by the microsoft odbc system. I am sure that Oracle driver would supports the `CLOB` data type as expected but microsoft is the problem.<br><br> Some body explain how i can go around this. Thanks