Re: Cannot get psqlODBC to work

Sorry, I've attached the logs now.

If I send a valid Query, I get a microsoft odbc error "Program type out of range", If I send an invalid query my app just hangs.

Any Ideas?

Thanks in advance
Glyn

<b><a rel="nofollow">Glyn Astill</a>
</b>

----- Original Message ----
> From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
> To: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
> Cc: pgsql-odbc(at)postgresql(dot)org
> Sent: Friday, 7 March, 2008 6:31:51 PM
> Subject: Re: [ODBC] Cannot get psqlODBC to work
>
> Glyn Astill wrote:
> > Hi people,
> >
> > I've been trying to use psqlODBC on windows XP to connect to 8.2.5
> > running on Debian and had no luck whatsoever.
> >
> > I've currently got psqlodbc_08_03_0100 installed using the msi
> > installer, but have tried older versions as well with no change.
> >
> > I've tried using both ANSI and Unicode driver, both have the same
> > problem.
> >
> > The problem is, that I send a query and I seem to get no response. I
> > can see my query in the servers logs, but nothing after that.
> >
> > The server log shows (my query):
> > ----------------------------------------------------------------------
> > STATEMENT: select * from "Events.SHOW" limit 1
> > ----------------------------------------------------------------------
> >
> > The mylog on the client shows:
>
> The logging options seem to be turned off.
> Could you try to turn on the per DSN Debug option ?
>
> regards,
> Hiroshi Inoue
>

__________________________________________________________
Sent from Yahoo! Mail.
The World's Favourite Email http://uk.docs.yahoo.com/nowyoucan.html