Cross-database references are not implemented

flxkid · Post by **flxkid** » Tue 17 May 2005 18:29

I am just switching over my app from using the npgsql driver to the corelab's driver. Everything worked ok in the npgsql driver, but I get an error using the crlab driver when I try to update rows. Here is the code I'm using:

Code: Select all

DataSet ds = new DataSet();
PgSqlDataAdapter da = new PgSqlDataAdapter("select * from prospect where 0=1", conn);
da.FillSchema(ds, SchemaType.Source);
DataTable prospect_dt = ds.Tables["Table"];
prospect_dt.TableName = "prospect";

DataRow newProspect = prospect_dt.NewRow();
newProspect["prospect_id"] = oProspect.ProspectID;
newProspect["agency"] = Convert.ToInt16(oProspect.Agency);
newProspect["branch"] = Convert.ToInt16(oProspect.Branch);
newProspect["name"] = oProspect.Name;
newProspect["street"] = oProspect.Street;
newProspect["city"] = oProspect.City;
newProspect["state"] = oProspect.State;
newProspect["zip"] = oProspect.ZipCode;
newProspect["phone_bus"] = oProspect.PhoneBusiness;
newProspect["user2"] = oProspect.UserField2;
da.InsertCommand = new PgSqlCommandBuilder(da).GetInsertCommand();
ds.Tables["prospect"].Rows.Add(newProspect);
da.Update(ds, "prospect");

Any ideas as to what I'm doing wrong?

OLIVER

Yuri · Post by **Yuri** » Wed 18 May 2005 08:25

We fixed your problem. It will be included in the next PostgreSQLDirect .NET build.
It will be available in about two weeks.

flxkid · Post by **flxkid** » Thu 19 May 2005 16:54

Yuri,

Thank you for the quick response. How will I know when the update is released? Will it be emailed to me (I do have a license of the driver)?

OLIVER

Yuri · Post by **Yuri** » Fri 20 May 2005 12:51

Look for announcements in PostgreSQLDirect.NET forum or send us e-mail if you want to be notified about the next build.

flxkid · Post by **flxkid** » Tue 27 Jan 2009 19:07

I updated to the latest dotConnect version 5.0.1.0 and I get this same error on the exact same piece of code. Is there something wrong with this way of adding a row?

OLIVER

Shalex · Post by **Shalex** » Wed 28 Jan 2009 13:37

The latest version of dotConnect for PostgreSQL is 4.00.20 (there is no 5.0.1.0 version). I've checked it. It works fine. Please check the 4.00.20 version, and if the problem persists, specify the exact error message.

flxkid · Post by **flxkid** » Wed 28 Jan 2009 15:50

Ok, sorry about the mix on the last message. Was looking at the version number from devart.data. I have updated from 4.00.16 to the latest 4.00.20 and I still get this same error from the same code:

cross-database references are not implemented: "hlmksys.public.prospect"

Shalex · Post by **Shalex** » Thu 29 Jan 2009 09:01

We cannot reproduce the issue. Please send me (alexsh*devart*com) a small test project that reproduces the problem. Please include definitions of database objects and avoid using third-party components. Also please specify the version of your PostgreSQL server.

Devart Forums