odbc help :(

[Ingela Anderton]

Hi Jimmy!

Jimmy Olgeni wrote:
> 
> Hi!
> 
> Looking for clues... I compiled the odbc application (R9B) using
> libiodbc, installed odbcserver in priv/bin by hand, and found a
> working DSN using the sample iodbc's odbctest application. I'm using
> the postgresql driver (7.2.3).
> 
> The odbc app complains:
> 
> (odbc@REDACTED)12> odbc:connect ("dsn=octopus;server=localhost;port=5432;database=octopus;uid=octopus", []).
> SQLGetInfo failed in dbInfo
> =ERROR REPORT==== 13-Nov-2002::15:57:08 ===
> ODBC: exit signal from port program:normal
> {error,{port_exit,normal}}
> (odbc@REDACTED)13>
> =ERROR REPORT==== 13-Nov-2002::15:57:08 ===
> ** Generic server <0.81.0> terminating
> ** Last message in was {'EXIT',#Port<0.63>,normal}
> ** When Server state == {state,#Port<0.63>,
>                                {<0.79.0>,#Ref<0.0.0.285>},
>                                <0.79.0>,
>                                undefined,
>                                on,
>                                undefined,
>                                undefined,
>                                connecting,
>                                false,
>                                false,
>                                []}
> ** Reason for termination ==
> ** {port_exit,normal}
> 
> odbc:connect performs application:start (odbc), so it should be sufficient (?).
> 

That is sufficient. The problem is not that the odbc application is not
started. The error message tells me that both the erlang an the
c-process are started correctly. But the C-program exits as the ODBC
API-function SQLGetInfo returns an unexpected value. This causes the
whole application to stop. This is something that logical should not
have happened and that is why the c-program exits. We will have to
look in to that. 

> Has anybody managed to get postgresql/iodbc/odbc working? =)
Unfortunately we have not had time to set up that test environment.

-- 
/Ingela

Ericsson AB - OTP team