Postgres Pro
Downloads
Home   >   mailing lists

Thread: odbc noob question - setting Declare/Fetch in the connection string?

odbc noob question - setting Declare/Fetch in the connection string?

From
Antoine
Date:
Hi,
Is this possible? If that can be passed as a parameter then we add it to
our communal connection string and our problem disappears.
Cheers
Antoine

Re: odbc noob question - setting Declare/Fetch in the

From
Dave Page
Date:


On 8/2/06 18:22, "Antoine" <melser.anton@gmail.com> wrote:

> Hi,
> Is this possible? If that can be passed as a parameter then we add it to
> our communal connection string and our problem disappears.

Yes - UseDeclareFetch=1 iirc.

Regards, Dave.

Re: odbc noob question - setting Declare/Fetch in the

From
tomas@nocrew.org (Tomas Skäre)
Date:
Antoine <melser.anton@gmail.com> writes:

> Is this possible? If that can be passed as a parameter then we add it
> to our communal connection string and our problem disappears.

Sure that's possible. I use "DSN=db" without declare/fetch set
normally, and in some cases "DSN=db;UseDeclareFetch=1", when I need
it.


Greetings,

Tomas

Re: odbc noob question - setting Declare/Fetch in the connection string?

From
Antoine
Date:
Thanks for that, I will implement it right away.
Cheers
Antoine

On 08/02/06, Dave Page <dpage@vale-housing.co.uk> wrote:
>
>
>
> On 8/2/06 18:22, "Antoine" <melser.anton@gmail.com> wrote:
>
> > Hi,
> > Is this possible? If that can be passed as a parameter then we add it to
> > our communal connection string and our problem disappears.
>
> Yes - UseDeclareFetch=1 iirc.
>
> Regards, Dave.
>
>


--
This is where I should put some witty comment.