Re: Default schema in DSN

Kenneth ****ter wrote:
> Is there some way to specify a schema in a DSN so that individual table 
> references in an app don't need to specify it, and so that the app 
> doesn't need to know what DB is on the back end? (The latter constraint 
> means I can't set the schema search path in the app.) I tried using 
> "mydb.public" as the DB name but the Data Source editor doesn't like
that.)
> 
> I'm trying to migrate an old Paradox app to a client/server paradigm. I 
> installed psqlodbc_08_03_0100 on XP SP2 and have an 8.1.11 server on 
> Linux. The app uses the Borland Database Engine (BDE) to access the 
> database.
> 
> I don't see a place in the Data Source configuration tool to set the 
> schema or a search path for a DSN.

Please use the Connect Settings option.
You can set the command like 'set search_path to ....' for the option.

regards,
Hiro**** Inoue


-- 
Sent via pgsql-odbc mailing list (pgsql-odbc@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc