Skip site navigation (1) Skip section navigation (2)

Re: ODBC Behavior, where do I find help?

From: Jon V <jon(at)cecorp(dot)com>
To: Wayne Armstrong <wdarmst(at)bacchus(dot)com(dot)au>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC Behavior, where do I find help?
Date: 2003-04-29 17:48:12
Message-ID: 3EAEBADC.4040402@cecorp.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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(at)cecorp(dot)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
>>    
>>


In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2003-04-30 02:17:43
Subject: Re: ODBC Behavior, where do I find help?
Previous:From: Miguel JuanDate: 2003-04-29 08:52:34
Subject: Fw: Error:Unable to identify an operator

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group