<div><font face="georgia" color="#000000">Dear all,</font></div>
<div><font face="georgia" color="#000000">I have confirmed that, the "Column type not supported" problem is not due to returning of multiple tables.</font></div>
<div><font face="georgia"><font color="#000000">Some of the fields returned in the table are not supported by the erlang odbc server. In my case 'nvarchar' type is not supported by the erlang odbc server. My special thanks to
<font size="2">Eduardo for his suggestion to sort out the problem. Also my thanks to all forum members for their inputs.</font></font></font></div>
<div><font face="Times New Roman" color="#000080" size="2"></font><br> </div>
<div><br> </div>
<div><span class="gmail_quote">On 3/15/07, <b class="gmail_sendername">Surindar Sivanesan</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:surindar.shanthi@gmail.com" target="_blank">surindar.shanthi@gmail.com
</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>Thanks a lot for the detailed reply.</div>
<div>I will check for the data type and proceed further<br><br> </div>
<div><span>
<div><span class="gmail_quote">On 3/14/07, <b class="gmail_sendername">Erlang (INS)</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:erlang@inswitch.us" target="_blank">erlang@inswitch.us</a>
> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div lang="EN-US" link="blue" vlink="blue">
<div>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">I have had the same problem sometime ago.</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Review the record type in each table; the supported ones by ODBC are (the listed in the C Erlang port source code):
</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_CHAR:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_VARCHAR:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_BINARY:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_LONGVARCHAR:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_VARBINARY:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_LONGVARBINARY:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_NUMERIC:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_DECIMAL:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_TINYINT:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_INTEGER:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_SMALLINT:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_REAL:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_FLOAT:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_DOUBLE:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_TYPE_DATE:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_TYPE_TIME:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_TYPE_TIMESTAMP:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_BIGINT:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> SQL_BIT:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Hope this helps you.</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Regards, Eduardo</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </span></font></p>
<div>
<div style="TEXT-ALIGN: center" align="center"><font face="Times New Roman" size="3"><span lang="ES" style="FONT-SIZE: 12pt">
<hr align="center" width="100%" size="2">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span lang="ES" style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">De:</span></font></b><font face="Tahoma" size="2"><span lang="ES" style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:erlang-questions-bounces@erlang.org" target="_blank">erlang-questions-bounces@erlang.org</a> [mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:erlang-questions-bounces@erlang.org" target="_blank">
erlang-questions-bounces@erlang.org</a>] <b><span style="FONT-WEIGHT: bold">En nombre de </span></b>Surindar Sivanesan<br><b><span style="FONT-WEIGHT: bold">Enviado el:</span></b> Miércoles, 14 de Marzo de 2007 02:45 a.m
. <br><b><span style="FONT-WEIGHT: bold">Para:</span></b> Scott Lystig Fritchie<br><b><span style="FONT-WEIGHT: bold">CC:</span></b> Erlang<br><b><span style="FONT-WEIGHT: bold">Asunto:</span></b> Re: [erlang-questions] ODBC problem if query returns multiple tables
</span></font><span lang="ES"></span></p></div>
<div><span>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Thanks for the reply.</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">I'm still facing the same problem even though I make the scrollable cursor option off.<br><br> </span></font></p></div>
<div>
<p><span><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">On 3/14/07, <b><span style="FONT-WEIGHT: bold">Scott Lystig Fritchie</span></b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:fritchie@snookles.com" target="_blank">
fritchie@snookles.com</a>> wrote:</span></font></span> </p>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">>>>>> "ss" == Surindar Sivanesan <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:surindar.shanthi@gmail.com" target="_blank">
surindar.shanthi@gmail.com</a>> writes:<br><br>ss> I'm having a Store Procedure (SP) which returns 8 tables (MS Sql).<br>ss> When I use that same SP in odbc:sql_query/2, it returns<br>ss> {error,"Column type not supported"}.
<br><br>It has been a while since I've used the Erlang ODBC driver, but I have<br>a faint memory that the "Column type not supported" can appear because<br>of attempts to use scrollable cursors. Do you still see the error if
<br>you use this?<br><br>{ok, DB} = odbc:connect(DSN_string, [{scrollable_cursors, off}]).<br><br>-Scott<br>_______________________________________________<br>erlang-questions mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:erlang-questions@erlang.org" target="_blank">
erlang-questions@erlang.org</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.erlang.org/mailman/listinfo/erlang-questions" target="_blank">http://www.erlang.org/mailman/listinfo/erlang-questions
</a></span></font></p></div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"><br><br clear="all"><br>-- <br>with regards, <br>S.Surindar </span></font></p></span></div></div></div></blockquote></div><br><br clear="all"><br></span>
</div>-- <br>with regards,<br>S.Surindar </blockquote></div><br><br clear="all"><br>-- <br>with regards,<br>S.Surindar