From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Shachar Shemesh <psql(at)shemesh(dot)biz> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: A few problems with the ODBC driver |
Date: | 2003-07-02 01:45:23 |
Message-ID: | 3F023933.E81DDB64@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Nagaraja Sadar | 2003-07-02 08:40:49 | How to can i make ,y system as psql database server???????? |
Previous Message | Shachar Shemesh | 2003-07-01 14:53:46 | Re: A few problems with the ODBC driver |