Re: Setting search_path in ODBC connection string

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.