Default schema in DSN

From: Kenneth Porter <shiva(at)sewingwitch(dot)com>
To: PostgreSQL ODBC <pgsql-odbc(at)postgresql(dot)org>
Subject: Default schema in DSN
Date: 2008-03-26 02:07:23
Message-ID: EB58939BEA68519D522E432B@[10.169.6.155]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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.

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Peter Eisentraut 2008-03-26 08:15:23 Re: connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0
Previous Message Richard Broersma 2008-03-25 19:56:03 Re: Access complains : Update or CancelUpdate without AddNew or Edit