Re: A few problems with the ODBC driver

Shachar Shemesh wrote:
>
> Hiroshi Inoue wrote:
>
> >>-----Original Message-----
> >>From: Shachar Shemesh
> >>
> >>1. The application is successful in seeing the database, and
> >>in getting the rows
> >>from it. When it tries to modify a row, however, we get an
> >>error that says "Only
> >>SQL_POSITION/REFRESH is supported for PGAPI_SetPos".
> >>Searching the sources
> >>reveals that the line is issued as a result of line 2762 of
> >>"result.c". The
> >>preceding lines show that either the odbc driver was compiled without
> >>DRIVER_CURSOR_IMPLEMENT, or the cursor is a read only cursor.
> >>Tracing the MFC
> >>stack reveals that the program does try to create a ROW_VER
> >>cursor. Could it be
> >>that the binary ODBC available from the mirrors does not
> >>support cursors? Why?
> >
> >Are you checking the "Updatable cursors" DSN option ?
> >
> As a matter of fact - I am. We were wondering what it does. In any case,
> that did not help.

What kind of cursor are you opening ?
Anyway, could you send me the Mylog debug output ?

> > 2. I tried to compile a replica of the driver I downloaded. I
> >followed the
> >instructions in README.TXT. Created the project in Visual
> >Studio 6. Added the
> >def file (I opted for psqlodbc_win32.def, as that's the only
> >one that matched
> >the name of the DLL I was supposed to create). The result was
> >that the project
> >wouldn't compile. I tried to run ./configure from cygwin
> >before, and now it
> >would compile, but throw an exception when I try to run it.
> >What do I need to do
> >in order to recompile a copy of the binary version given at the site?
> >
> >Don't use the driver compiled under cygwin.
> >I recommend to compile it from the command line i.e type
> >  nmake /f win32.mak
> >
> Ok. I fail with "don't know how to make psqlodbc.rc". It is, indeed, not
> in the sources. Where do I get it?

Please go to
http://gborg.postgresql.org/project/psqlodbc/projdisplay.php.
You can view Web CVS there or access CVS from the command line
according to an info on the page.

regards,
Hiroshi Inoue
    http://www.geocities.jp/inocchichichi/psqlodbc/