Thread: ODBC Behavior, where do I find help?
Hello all, I'm sure this is a pretty basic misunderstanding or misapplication on my part. I'm hoping one of you can set me straight. I'm running PostgreSQL 7.3.2 under Cygwin. Running ODBC 7.01.00.10 (as displayed in the ODBC Data Source Administrator Driver tab), my application works fine. However, if I install any of the 7.02 ODBC drivers, my application fails. We've traced the cause of the failure, and it has me scratching my head. Using our application OR PgAdminII, I run the following: begin; select * from table_name end With 7.1 ODBC I get a result (in PgAdminII a table pops up on the screen, in our app we get the results of the query). With 7.2 I get a "query completed successfully" (status) message. The same thing happens when I run an SQL function we've written that passes a cursor back -- 7.1 returns the result, 7.2 returns a status. I assume I must be doing something wrong because if it was really broken then nobody could use 7.2, and the latest versions of PgAdmin are quite forceful about automatically installing the 7.2 drivers if they aren't present. Where should I look? TIA, Jon
** Reply to message from Jon V <jon@cecorp.com> on Mon, 28 Apr 2003 14:37:05 -0700 Hi, Try it without the begin and end; What you are seeing is the result of the last executed statement (end; ) I don't know if this represents a change in the odbc driver - but it is behaviour that seems reasonable to me :) Regards, Wayne > Hello all, > > I'm sure this is a pretty basic misunderstanding or misapplication on my > part. I'm hoping one of you can set me straight. > I'm running PostgreSQL 7.3.2 under Cygwin. Running ODBC 7.01.00.10 (as > displayed in the ODBC Data Source Administrator Driver tab), my > application works fine. However, if I install any of the 7.02 ODBC > drivers, my application fails. > > We've traced the cause of the failure, and it has me scratching my head. > Using our application OR PgAdminII, I run the following: > > begin; > select * from table_name > end > > With 7.1 ODBC I get a result (in PgAdminII a table pops up on the > screen, in our app we get the results of the query). With 7.2 I get a > "query completed successfully" (status) message. The same thing happens > when I run an SQL function we've written that passes a cursor back -- > 7.1 returns the result, 7.2 returns a status. > > I assume I must be doing something wrong because if it was really broken > then nobody could use 7.2, and the latest versions of PgAdmin are quite > forceful about automatically installing the 7.2 drivers if they aren't > present. > > Where should I look? > > TIA, > Jon > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html
OK, the symptom is consistant with your explanation, so that makes sense in its way. I'm not sure how it applies to my greater problem though. Namely, I have a function stored in the database that returns a refcursor through 7.1 and (despite my wishes) a status through 7.2. The symptoms are identical to the begin;query;end example, but because it is a function I can't remove the begin and end. :( Someone else must be doing the same sort of thing... has anyone had a similar problem? Is there a trick I've missed? Right now we are stuck with 7.1, but we want to use PgAdminII, and the current version seems to auto-install odbc 7.2. Thanks, -Jon Wayne Armstrong wrote: >** Reply to message from Jon V <jon@cecorp.com> on Mon, 28 Apr 2003 14:37:05 >-0700 >Hi, > Try it without the begin and end; > What you are seeing is the result of the last executed statement (end; ) > I don't know if this represents a change in the odbc driver - but it is >behaviour that seems reasonable to me :) > >Regards, >Wayne > > > >>Hello all, >> >>I'm sure this is a pretty basic misunderstanding or misapplication on my >>part. I'm hoping one of you can set me straight. >>I'm running PostgreSQL 7.3.2 under Cygwin. Running ODBC 7.01.00.10 (as >>displayed in the ODBC Data Source Administrator Driver tab), my >>application works fine. However, if I install any of the 7.02 ODBC >>drivers, my application fails. >> >>We've traced the cause of the failure, and it has me scratching my head. >>Using our application OR PgAdminII, I run the following: >> >>begin; >>select * from table_name >>end >> >>With 7.1 ODBC I get a result (in PgAdminII a table pops up on the >>screen, in our app we get the results of the query). With 7.2 I get a >>"query completed successfully" (status) message. The same thing happens >>when I run an SQL function we've written that passes a cursor back -- >>7.1 returns the result, 7.2 returns a status. >> >>I assume I must be doing something wrong because if it was really broken >>then nobody could use 7.2, and the latest versions of PgAdmin are quite >>forceful about automatically installing the 7.2 drivers if they aren't >>present. >> >>Where should I look? >> >>TIA, >> Jon >> >>
Jon V wrote:
>
> OK, the symptom is consistant with your explanation, so that makes sense
> in its way.
>
> I'm not sure how it applies to my greater problem though. Namely, I have
> a function stored in the database that returns a refcursor through 7.1
> and (despite my wishes) a status through 7.2. The symptoms are identical
> to the begin;query;end example, but because it is a function I can't
> remove the begin and end. :(
>
> Someone else must be doing the same sort of thing... has anyone had a
> similar problem?
>
> Is there a trick I've missed? Right now we are stuck with 7.1, but we
> want to use PgAdminII, and the current version seems to auto-install
> odbc 7.2.
> >>Using our application OR PgAdminII, I run the following:
> >>
> >>begin;
> >>select * from table_name
> >>end
Using the 7.2 or later driver, you would get 3 results
for the above chained command sequence.
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/