[erlang-questions] ODBC problem if query returns multiple tables

[Surindar Sivanesan]

Dear all,
I have confirmed that, the "Column type not supported" problem is not due to
returning of multiple tables.
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 Eduardo for his suggestion to sort out the
problem. Also my thanks to all forum members for their inputs.




On 3/15/07, Surindar Sivanesan <surindar.shanthi@REDACTED> wrote:
>
> Thanks a lot for the detailed reply.
> I will check for the data type and proceed further
>
>
>  On 3/14/07, Erlang (INS) <erlang@REDACTED > wrote:
> >
> >  I have had the same problem sometime ago.
> >
> > Review the record type in each table; the supported ones by ODBC are
> > (the listed in the C Erlang port source code):
> >
> >      SQL_CHAR:
> >
> >      SQL_VARCHAR:
> >
> >      SQL_BINARY:
> >
> >      SQL_LONGVARCHAR:
> >
> >      SQL_VARBINARY:
> >
> >      SQL_LONGVARBINARY:
> >
> >      SQL_NUMERIC:
> >
> >      SQL_DECIMAL:
> >
> >      SQL_TINYINT:
> >
> >      SQL_INTEGER:
> >
> >      SQL_SMALLINT:
> >
> >      SQL_REAL:
> >
> >      SQL_FLOAT:
> >
> >      SQL_DOUBLE:
> >
> >      SQL_TYPE_DATE:
> >
> >      SQL_TYPE_TIME:
> >
> >      SQL_TYPE_TIMESTAMP:
> >
> >      SQL_BIGINT:
> >
> >      SQL_BIT:
> >
> >
> >
> >
> >
> > Hope this helps you.
> >
> > Regards, Eduardo
> >
> >
> >  ------------------------------
> >
> > *De:* erlang-questions-bounces@REDACTED [mailto:erlang-questions-bounces@REDACTED]
> > *En nombre de *Surindar Sivanesan
> > *Enviado el:* Miércoles, 14 de Marzo de 2007 02:45 a.m .
> > *Para:* Scott Lystig Fritchie
> > *CC:* Erlang
> > *Asunto:* Re: [erlang-questions] ODBC problem if query returns multiple
> > tables
> >
> >
> >
> > Thanks for the reply.
> >
> > I'm still facing the same problem even though I make the scrollable
> > cursor option off.
> >
> >
> >
> > On 3/14/07, *Scott Lystig Fritchie* < fritchie@REDACTED> wrote:
> >
> > >>>>> "ss" == Surindar Sivanesan < surindar.shanthi@REDACTED> writes:
> >
> > ss> I'm having a Store Procedure (SP) which returns 8 tables (MS Sql).
> > ss> When I use that same SP in odbc:sql_query/2, it returns
> > ss> {error,"Column type not supported"}.
> >
> > It has been a while since I've used the Erlang ODBC driver, but I have
> > a faint memory that the "Column type not supported" can appear because
> > of attempts to use scrollable cursors.  Do you still see the error if
> > you use this?
> >
> > {ok, DB} = odbc:connect(DSN_string, [{scrollable_cursors, off}]).
> >
> > -Scott
> > _______________________________________________
> > erlang-questions mailing list
> > erlang-questions@REDACTED
> > http://www.erlang.org/mailman/listinfo/erlang-questions
> >
> >
> >
> >
> > --
> > with regards,
> > S.Surindar
> >
>
>
>
> --
> with regards,
> S.Surindar




-- 
with regards,
S.Surindar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://erlang.org/pipermail/erlang-questions/attachments/20070316/8c330815/attachment.htm>