Re: Setting search_path in ODBC connection string

["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.