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(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