Re: Setting search_path in ODBC connection string

Hi Andrus-san.

Sorry...late reaction.

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.

Regards,
Hiroshi Saito

----- Original Message -----
From: "Andrus" <kobruleht2(at)hot(dot)ee>

> Hiroshi,
>
>> Please set in odbc.ini.
>>
>> ConnSettings = set search_path = Others,public;
>
> Thank you.
> I need to change this setting at runtime.
> When connection is re-created, VFP creates it using previous connection
> string automatically.
> It is not possible to force VFP to send SET SEARCH_PATH command
> automatically on re-connect.
>
> Using odbc.ini requires parsing odbc.ini file in c:\windows directory.
> Different connections require different default seach paths. This settings
> seems to be global for all connections.
> How to force driver to use different search_path's for different connections
> ?
>
> Any other idea ?
> How to force ODBC driver to issue SET SEARCH_PATH automatically ? Maybe
> there is some connection option which can be used ?
>
> 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