Re: Setting search_path in ODBC connection string

["Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>]

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(at)hot(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc