Skip site navigation (1) Skip section navigation (2)

Re: Setting search_path in ODBC connection string

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Setting search_path in ODBC connection string
Date: 2008-11-05 16:04:33
Message-ID: gesg6n$2d6c$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-odbc
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. 


In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi SaitoDate: 2008-11-06 08:45:46
Subject: Re: Setting search_path in ODBC connection string
Previous:From: Hiroshi SaitoDate: 2008-11-05 15:34:19
Subject: Re: Setting search_path in ODBC connection string

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group