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.