Cross-database references are not implemented

Cross-database references are not implemented

Postby 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
flxkid
 

Cross-database references are not implemented

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

Update...

Postby 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
flxkid
 

Update...

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

Problem has cropped up again

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

Postby 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.
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44

cross-database references are not implemented

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

Postby 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.
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL