Re: Default schema in DSN

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