Re: A few problems with the ODBC driver

Hiroshi Inoue wrote:

>>-----Original Message-----
>>From: Shachar Shemesh
>>
>>Hi list,
>>
>>I'm still trying to find my way around the ODBC arena, so
>>please forgive me if I
>>ask something irrelevant. I am trying to migrate an
>>application that currently
>>works on Windows with MS-SQL and Oracle to also work with PG-SQL. I've
>>downloaded the 7.3.100 ODBC driver. The problems are
>>independant, but if anyone
>>manages to solve my first problem, I'm not going to care
>>about the other ones.
>>
>>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.

> 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?

>
>regards,
>Hiroshi Inoue
>
>

--
Shachar Shemesh
Open Source integration consultant
Home page & resume - http://www.shemesh.biz/