Re: How can I keep an OdbcDataAdapter from using fully qualified tble names? - Mailing list pgsql-odbc

From Rob Richardson
Subject Re: How can I keep an OdbcDataAdapter from using fully qualified tble names?
Date
Msg-id 1335365560.94781.YahooMailRC@web83606.mail.sp1.yahoo.com
Whole thread Raw
In response to Re: How can I keep an OdbcDataAdapter from using fully qualified tble names?  (Barry Bell <Barry_Bell@harte-hanks.com>)
List pgsql-odbc
The issue is that ADO.Net's OdbcDataAdapter object automatically expands the
table name "MyTable" into "MyDatabase.public.MyTable", and PostgreSQL cannot
handle that.

In PgAdmin, "insert into cycle (cycle) values ('Another cycle')" succeeds, but
"insert into Anneal.public.cycle (cycle) values ('Another one')" fails with the
cross-database references not implemented error.  The OdbcDataAdapter object
automatically converts a query of the first form into a query of the second
form, and I want to know how to stop it from doing that.

RobR

pgsql-odbc by date:

Previous
From: Barry Bell
Date:
Subject: Re: How can I keep an OdbcDataAdapter from using fully qualified tble names?
Next
From: Nils Gösche
Date:
Subject: Re: How can I keep an OdbcDataAdapter from using fully qualified tble names?