Re: Setting search_path in ODBC connection string

Hi.

Yes, can use DSN less.

Sample of VBA) -- not VFP

  szConnect = "DRIVER=" & txtDriver & _
               ";DATABASE=" & txtDB & _
               ";UID=" & txtUID & _
               ";SSLMODE=allow" & _
               ";SERVER=" & txtServer & _
               ";PORT=" & txtPort & _
               ";PWD=" & txtPWD & _
               ";A6=set search_path to company1,public;"

Please see,
http://psqlodbc.projects.postgresql.org/config-opt.html

Regards,
Hiroshi Saito

----- Original Message -----
From: "Andrus" <kobruleht2@hot.ee>


> Hiroshi,
>
>> Ahh, there is a part set up into Dialog in windows. Then, It is
>> automatically used at the time of connection. I'm not checking by the
>> reason for not using VFP.  However, It is used when operating it by DSN.
>
> Thank you. I want to do this without user interaction.
> Using this requires my application to create programmatically new DSN for
> every possible search_path combination. This reqires admin privileges in
> windows.
> Is it best way ?
>
> I also discovered that
>
> ConnSettings=set search_path to company1,public
>
> in connection string seems to solve this issue without requiring DSN usage.
>
> Is it OK to use ConnSettings and not use DSNs ?
>
> Andrus.
>
>
> --
> Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc