Failed to add relation(s).

Failed to add relation(s).

Postby manisys » Tue 09 Jan 2007 21:54

OS: Windows XP
Compiler: Visual Studio 2005 SP2 / c#
Driver: PostgresqlDirect Version 2.55.23.0

I am trying attach a new dataSet with two tables using the "Add Project Data Source" wizard.

I drop a DataGrid onto a blank form. Then I attach a new dataSet with two tables using the "Add Project Data Source" wizard.
I am using the test database that is provided in the Samples code.
I add the "dept" and the "emp" table together in the Wizard and then get the error .

I get an error saying:
"Failed to add relation(s)."
"Column 'Index' does not belong to table IndexColumns"

I researched this a little on google and learned the the IndexColumns table is related to the GetSchema() command return values for "IndexColumns".

I can perform the operation if I use an Access (OLEDB) or SQL Server just not with Postgresql and the PostgresqlDirect driver.

Please let me know how to either get around this or when it will be resolved.

Thank you.

James
manisys
 
Posts: 2
Joined: Tue 09 Jan 2007 21:43

Postby Alexey » Wed 10 Jan 2007 07:14

We are investigating this problem.
Look forward to the next build.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby manisys » Wed 10 Jan 2007 22:18

I installed the Beta 3.0 version and the problem has been resolved.

Thank you.

Do you know when the Beta version will be released? I am under pressure to get a project out the door.

James
manisys
 
Posts: 2
Joined: Tue 09 Jan 2007 21:43

Postby Alexey » Fri 12 Jan 2007 07:59

PostgreSQLDirect .NET 3.0 is going to be released in a month.
The issue with relations is also fixed in PostgreSQLDirect .NET 2.55.24 which is coming out in two weeks.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for PostgreSQL