Thread: (Fwd) SQLSetPos problem under Linux
Hi, is there really no answer for me ? Thanks Lothar ------- Weitergeleitete Nachricht / Forwarded message ------- Von: lothar.behrens@lollisoft.de An: pgsql-odbc@postgresql.org Datum: Sun, 20 Feb 2005 20:10:56 +0100 Betreff: [ODBC] SQLSetPos problem under Linux Hi, I have the following problem under Linux: I use SQLSetpos to update data at current cursor position with SQL_UPDATE. I get back an error message, that only SQL_POSITION/REFRESH is supported. Does this limitation come from your ODBC driver or is it limited by unixODBC ? Or, how must I activate these functionality while building it from sources ? With your windows ODBC driver (version 7.3.200), I do not have these problems. Ehhm, SuSE Linux 9.1, its unixODBC version 2.2.8-55 Thanks Lothar ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org --- Ende der weitergeleiteten Nachricht / End of forwarded message ---
lothar.behrens@lollisoft.de wrote: > Hi, > > is there really no answer for me ? I'm not sure the question was clear. > I have the following problem under Linux: > > I use SQLSetpos to update data at current cursor position with SQL_UPDATE. > I get back an error message, that only SQL_POSITION/REFRESH is supported. > Does this limitation come from your ODBC driver or is it limited by unixODBC ? > Or, how must I activate these functionality while building it from sources ? > With your windows ODBC driver (version 7.3.200), I do not have these problems. So - "SQLSetpos+SQL_UPDATE" works with the ODBC driver under Windows. It doesn't work under unixODBC on Suse 9.1 Well, the ODBC driver is presumably the same - AFAIK the same code builds Windows and Unix versions. This suggests the problem lies elsewhere. Are you sure the SQL being executed is the same in both cases? Try turning on statement logging in PostgreSQL and check. -- Richard Huxton Archonet Ltd
--- Richard Huxton <dev@archonet.com> wrote: > lothar.behrens@lollisoft.de wrote: > > Hi, > > > > is there really no answer for me ? > > I'm not sure the question was clear. > > > I have the following problem under Linux: > > > > I use SQLSetpos to update data at current cursor > position with SQL_UPDATE. > > I get back an error message, that only > SQL_POSITION/REFRESH is supported. > > > Does this limitation come from your ODBC driver or > is it limited by unixODBC ? > > > Or, how must I activate these functionality while > building it from sources ? > > With your windows ODBC driver (version 7.3.200), I > do not have these problems. > > So - "SQLSetpos+SQL_UPDATE" works with the ODBC > driver under Windows. > It doesn't work under unixODBC on Suse 9.1 > > Well, the ODBC driver is presumably the same - AFAIK > the same code > builds Windows and Unix versions. This suggests the > problem lies elsewhere. > > Are you sure the SQL being executed is the same in > both cases? Try > turning on statement logging in PostgreSQL and > check. > > -- > Richard Huxton > Archonet Ltd > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose > an index scan if your > joining column's datatypes do not match > __________________________________ Do you Yahoo!? Yahoo! Mail - 250MB free storage. Do more. Manage less. http://info.mail.yahoo.com/mail_250
Do a search for DRIVER_CURSOR_IMPLEMENT on the odbc mailing list. With version 7.x this needed to be defined on the command line when building the source code to use updateable cursors. -- Janet -----Original Message----- From: lothar.behrens@lollisoft.de [mailto:lothar.behrens@lollisoft.de] Sent: Wednesday, February 23, 2005 10:23 PM To: Pgsql-Odbc@Postgresql.Org Subject: (Fwd) [ODBC] SQLSetPos problem under Linux Hi, is there really no answer for me ? Thanks Lothar ------- Weitergeleitete Nachricht / Forwarded message ------- Von: lothar.behrens@lollisoft.de An: pgsql-odbc@postgresql.org Datum: Sun, 20 Feb 2005 20:10:56 +0100 Betreff: [ODBC] SQLSetPos problem under Linux Hi, I have the following problem under Linux: I use SQLSetpos to update data at current cursor position with SQL_UPDATE. I get back an error message, that only SQL_POSITION/REFRESH is supported. Does this limitation come from your ODBC driver or is it limited by unixODBC ? Or, how must I activate these functionality while building it from sources ? With your windows ODBC driver (version 7.3.200), I do not have these problems. Ehhm, SuSE Linux 9.1, its unixODBC version 2.2.8-55 Thanks Lothar ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org --- Ende der weitergeleiteten Nachricht / End of forwarded message --- ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster