Re: Setting search_path in ODBC connection string

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Setting search_path in ODBC connection string
Date: 2008-11-06 10:26:05
Message-ID: C673430B22654EDCBAC1BCEBE5DFB4DA@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hiroshi,

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

Thank you. I want to do this without user interaction.
Using this requires my application to create programmatically new DSN for
every possible search_path combination. This reqires admin privileges in
windows.
Is it best way ?

I also discovered that

ConnSettings=set search_path to company1,public

in connection string seems to solve this issue without requiring DSN usage.

Is it OK to use ConnSettings and not use DSNs ?

Andrus.

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Saito 2008-11-06 16:54:41 Re: Setting search_path in ODBC connection string
Previous Message Hiroshi Saito 2008-11-06 08:45:46 Re: Setting search_path in ODBC connection string