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
> 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.
In response to
pgsql-odbc by date
|Next:||From: noreply||Date: 2008-03-31 07:31:29|
|Subject: [ psqlodbc-Bugs-1010368 ] connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0|
|Previous:||From: Hiroshi Inoue||Date: 2008-03-31 03:36:08|
|Subject: Re: Can't create DSN using SSPI authentication WinXP to WinXP|