Cross-database references are not implemented

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
flxkid

Cross-database references are not implemented

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
Posts: 140
Joined: Mon 08 Nov 2004 12:07

Cross-database references are not implemented

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

Update...

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
Posts: 140
Joined: Mon 08 Nov 2004 12:07

Update...

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
Posts: 2
Joined: Tue 27 Jan 2009 19:05

Problem has cropped up again

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
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

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
Posts: 2
Joined: Tue 27 Jan 2009 19:05

cross-database references are not implemented

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
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

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.

Post Reply