Re: Default schema in DSN

[Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>]

Kenneth Porter 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,
Hiroshi Inoue