Status of ODBC

yerl <>
Fri Feb 11 16:35:24 CET 2005


Greate idea. It'll be very useful for many of us
/yerl

----Message d'origine----
>De: Tiago Rodrigues Antao <>
>A: 
>Sujet: Re: Status of ODBC
>Date: Fri, 11 Feb 2005 12:10:06 +0000
>Copie à: 
>
>Hi!
>
>First I would like to thank everybody that answered.
>
>All the infrastructure was set up correctly (odbcserver, etc)
>I discovered that the problem was my poor Erlang knowledge, I was doing:
>Ref = odbc:connect("DSN=PostgreSQL;UID=XXX;PWD=XXX",[{scrollable_cursors, 
>off}]).
>
>odbc:sql_query(Ref,"select * from t1").
>
>The "Ref =" should have been "{ok, Ref} ="
>
>This was causing odbcserver to shutdown (not a crash, a normal exit).
>
>If nobody opposes I would like to document on the wiki my experience in 
>putting ODBC to work on Linux/PostgreSQL (including most of the issues raised 
>by all the people that answered my previous email).
>
>BTW, I will be making changes to odbcserver and the odbc module to include 
>support for metadata, if anyone is interested in these changes, I will be 
>more than happy to share them.
>
>
>
>Em Terça, 8 de Fevereiro de 2005 08:27, o Ingela Anderton escreveu:
>> Tiago Rodrigues Antao wrote:
>> > Hi!
>> >
>> > I am trying to use the ODBC facility of Erlang. I have noticed from the
>> > code that its only supposed to work on Windows and Solaris (I am working
>> > on Linux).
>>
>> It is not only supposed to work for Windows and Solaris. There might
>> be some unfortunate naming that gave you this idea. But there
>> is no technical reason why it should not work on Linux.
>> On the other hand it is currently only tested and commercially
>> supported for Windows and Solaris.
>>
>> > I changed the build script and compiled odbcserver.
>> > I was able to start it from within Erlang and to connect to a PostgreSQL
>> > server, but when I try to do an SQL query the server crashes.
>>
>> Without the crash report it is hard say anything! Probably it's not
>> the srollable cursors problem with 2.x drivers as you managed to
>> connect to the server.
>>
>> > Does anyone tried to use odbcserver on Linux? With any luck?
>>
>> I think there where some users who did, but I will let them speak for
>> themselves.
>
>




More information about the erlang-questions mailing list