Devart Forums

belidzs

Don't hold your breath. I've paid for another year of license fee back in November, because I just assumed that they must have already added support VS2022, like any other respectable component supplier did at the time.

They had access to betas, RCs, and other preview versions which they could've leveraged to ensure dotconnect's compatibility by the official launch. They just don't care about this products and their subscribers anymore.

belidzs

I'm also waiting for VS2022 support as .NET 6.0 is incompatible with VS2019, so if I want to target the latest LTS, I'm forced to upgrade.

belidzs

I can confirm that the latest working version is 7.13.1437

belidzs · Re: Bug in 7.14.1470 ? Same happened to me, I had to revert back to 7.13.1366.

Same happened to me, I had to revert back to 7.13.1366.

belidzs

It's been a week and there is no fix yet

belidzs

Pinturiccio wrote: ↑Fri 23 Mar 2018 11:13 We have reproduced the issue. And we have fixed the bug with throwing the "IDE not supported" exception by DataSet Manager in Visual Studio 2017 of versions 15.6.*. We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.

Thanks. I'm really looking forward to download the fixed version.

belidzs

I sent the support request below through the ticketing system two workdays ago but apparently Devart is not interested in supporting paying customers anymore.

Maybe someone else can help:

Code: Select all

Product: dotConnect for PostgreSQL
Product Version: 7.10.1086.0
OS Version: Windows 10
Platform: x64
Is registered user: True
License number: xx

Details:

I'm using Visual Studio Community 2017 15.6.3. I'm unable to open DataSet manager on untyped datasets. I tried to right-click on the component then select Edit and also Tools/PostgreSQL/DataSet manager, but nothing happens.

I have tried reinstalling the component, didn't help. I suspect it has something to do with a recent VS update.

At this point any help is appreciated.

belidzs

Thanks. Will you fix this bug retrospectively in v5 as well?

belidzs

I'm using dotConnect for PostgreSQL 5.0.449.0 with PostgreSQL server 9.1.
I have a PgSqlDataSet which connects to my server through a shared PgSqlConnection. This connection is shared with a PgSqlAlerter component. My alerter's list is preloaded during design time with a few alerts and another one is amended after the PgSqlConnection is successfully opened. The alerter is only started for the first time after this supplemental alert is added. This is where the unexpected behaviour occurs.
At this point dbMonitor show a new connection request with almost the same parameters, only SslOptions are not copied. This results in a fatal error since my server is configured to refuse non-SSL connections. Disabling connection pooling doesn't help, a new connection is opened anyways.

Code: Select all

  2014.03.20. 0:26:27 n/a dotConnect for PostgreSQL monitoring is started Complete
  2014.03.20. 0:26:27 0,717 Open connection: "User Id=Y;Password=X;Host=0.0.0.0;Database=Z;Unicode=True;Character Set=UTF8;Pooling=True;SSLMode=Allow;" Complete
  2014.03.20. 0:26:27 0,000 Connect: "User Id=Y;Password=X;Host=0.0.0.0;Database=Z;Unicode=True;Character Set=UTF8;Pooling=True;SSLMode=Allow" Complete
  2014.03.20. 0:26:28 0,031 Execute: SELECT version() Complete
  2014.03.20. 0:26:28 0,016 Execute: show integer_datetimes Complete
  2014.03.20. 0:26:28 0,015 Execute: show bytea_output Complete
  2014.03.20. 0:26:28 0,016 Execute: SET autocommit=true Complete
  2014.03.20. 0:26:28 0,015 Execute: SET datestyle=ISO ; SET client_encoding='UTF8' Complete
  2014.03.20. 0:26:28 0,016 Execute: SELECT oid FROM pg_type WHERE typname like 'geometry' Complete
  2014.03.20. 0:26:28 0,016 Prepare: SET ROLE Y Complete
  2014.03.20. 0:26:28 0,015 Execute: SET ROLE Y Complete
  
  (log entries omitted) -> application executes PgSqlAlerter.Start() here
  
  2014.03.20. 0:26:36 0,000 Creating pool with connections string: "User Id=Y;Password=X;Host=0.0.0.0;Database=Z;Unicode=True;Character Set=UTF8;Pooling=True;SSLMode=Disable" Complete
  2014.03.20. 0:26:36 0,000 Creating object Complete
  2014.03.20. 0:26:36 0,000 Creating pool with connections string: "User Id=Y;Password=X;Host=0.0.0.0;Database=Z;Unicode=True;Character Set=UTF8;Connection Timeout=0;Pooling=True;SSLMode=Disable" Complete
  2014.03.20. 0:26:36 0,000 Creating object Complete
  2014.03.20. 0:26:36 n/a Open connection: "User Id=Y;Password=X;Host=0.0.0.0;Database=Z;Unicode=True;Character Set=UTF8;Connection Timeout=0;Pooling=True;SSLMode=Disable;" Pending
  2014.03.20. 0:26:36 0,000 Connect: "User Id=Y;Password=X;Host=0.0.0.0;Database=Z;Unicode=True;Character Set=UTF8;Connection Timeout=0;Pooling=True;SSLMode=Disable" Complete
  2014.03.20. 0:26:37 0,000 Disconnect Complete

belidzs

I was afraid of this. Thank you however!

belidzs

Could you provide an example how to do it?

belidzs

I've sent the requested files

belidzs

I'm trying to post changes using an untyped dataset and a stored procedure in the same transaction using dotConnect Professional. The problem is that if posting dataset succeeds, but the stored procedure afterwards doesn't, rolling back the transaction doesn't roll back the dataset to its original state, the dataset looks like it has been successfully commited. Is there any solution to avoid this problem?

belidzs

Ok, now I get what it's supposed to do. I actually want to build an update command, which only contains the changed field's definition. The point of doing this is that since postgres 9 it is possible to set column-level privileges, but if I use an update query which sets every field of the table, the whole thing becomes pointless.

Let's say there are 3 columns:

Column A
Column B
Column C

User1 has privileges on editing A and B, User2 can edit all of the columns above. If I set the update command to update all columns, User1 won't be able to edit anything (even if he only changes the first columns the UPDATE command will trigger a privilege fault). If I use a command which only affects A and B, everyone will be able to make changes, but C never will be affected.
Is there any practice to circumvent this?
Thanks!

belidzs

I'm wondering if it's possible to generate update and select commands with a PgSqlDataTable class? I've filled connection, columns, contraints, primary key, selectcommand, refreshingfields, refreshmode, updatingfields, updatingkeyfields and updatingtable.
Is there a member of PgSqlDataTable which generates the insertcommand and updatecommand for me? It would be nice to only update fields which have been modified before.

Devart Forums

Search found 36 matches

Re: Visual Studio 2022

Re: Visual Studio 2022

Re: Bug in 7.14.1470 ?

Re: Bug in 7.14.1470 ?

Re: DataSet manager won't open in VS2015

Re: DataSet manager won't open in VS2015

DataSet manager won't open in VS2015

Re: Connection resets on PgSqlAlerter.Start() without SSL options

Connection resets on PgSqlAlerter.Start() without SSL options

Re: Transactions with untyped dataset

Re: Transactions with untyped dataset

Re: Transactions with untyped dataset

Transactions with untyped dataset

How to generate update command with PgSqlDataTable?