UniConnection InfoMessage event issue, never fires

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for universal data access
Post Reply
idem84
Posts: 51
Joined: Thu 04 Apr 2013 19:12

UniConnection InfoMessage event issue, never fires

Post by idem84 » Fri 14 Jul 2017 22:48

Hi
I'm using dcUniversal...
InfoMessage event never fires, i tried many ways but no success, neither unicommand neither uniscript

private void ConnectionOnInfoMessage(object sender, UniInfoMessageEventArgs uniInfoMessageEventArgs) {
...
}
...
var uniCon = new UniConnection
{
... // (I'm using Sql Server provider) (I tested with SQL Server 2005 and 2008 editions)
};
uniCon.Open();
uniCon.InfoMessage += ConnectionOnInfoMessage; // Never fires
var uniComm = new UniCommand("PRINT('OK FROM ExNonQuery')", uniCon);
uniComm.ExecuteNonQuery();

var uniScript = new UniScript("PRINT ('OK FROM SCRIPT')", uniCon);
uniScript.Execute();

uniComm.Connection.Close();
...

Thanks in advance!

idem84
Posts: 51
Joined: Thu 04 Apr 2013 19:12

Re: UniConnection InfoMessage event issue, never fires

Post by idem84 » Mon 17 Jul 2017 21:37

Similar code usinng native SqlConnection works as expected! But i want to still coding in dcUniversal.

private void SqlConOnInfoMessage(object sender, SqlInfoMessageEventArgs sqlInfoMessageEventArgs)
{ ... }

//System.Data.SqlClient.SqlConnection
var sqlCon = new SqlConnection("Data Source=...;Initial Catalog=...;User id=...;Password=...;");
sqlCon.Open();
sqlCon.InfoMessage += SqlConOnInfoMessage;
var sqlCom = new SqlCommand("PRINT ('OK FROM Sys Data SqlClient SqlConnection')", sqlCon);
sqlCom.ExecuteNonQuery();
sqlCon.Close();

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: UniConnection InfoMessage event issue, never fires

Post by Shalex » Tue 18 Jul 2017 11:10

Thank you for your report. We have reproduced the issue and will notify you when it is fixed.

idem84
Posts: 51
Joined: Thu 04 Apr 2013 19:12

Re: UniConnection InfoMessage event issue, never fires

Post by idem84 » Fri 04 Aug 2017 15:37

Hi! Do you have an ETA fix?
Thanks in advance!

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: UniConnection InfoMessage event issue, never fires

Post by Shalex » Wed 09 Aug 2017 10:49

The bug with firing the UniConnection.InfoMessage event while working with SQL Server is fixed. We will notify you when the new public build of dotConnect Universal is available for download.

idem84
Posts: 51
Joined: Thu 04 Apr 2013 19:12

Re: UniConnection InfoMessage event issue, never fires

Post by idem84 » Wed 09 Aug 2017 13:52

Thanks I'll wait for it.
Will that event also work for the other data providers?
Thanks in advance!

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: UniConnection InfoMessage event issue, never fires

Post by Shalex » Wed 09 Aug 2017 14:48

idem84 wrote:Will that event also work for the other data providers?
Please specify the list of providers (used via dotConnect Universal) you are interested in.

idem84
Posts: 51
Joined: Thu 04 Apr 2013 19:12

Re: UniConnection InfoMessage event issue, never fires

Post by idem84 » Wed 09 Aug 2017 14:59

Actually at least could be great that supports SqlServer and MySql

It could be great if that will support Oracle and Postgre too maybe later.
That the event could be enabled in a general way for actually dcUniversal providers

Thanks in advance!

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: UniConnection InfoMessage event issue, never fires

Post by Shalex » Thu 10 Aug 2017 09:21

We are working on the UniConnection.InfoMessage support for MySQL / Oracle / PostgreSQL. We will notify you when it is implemented.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: UniConnection InfoMessage event issue, never fires

Post by Shalex » Mon 14 Aug 2017 14:20

The bug with firing the UniConnection.InfoMessage event while working with MySQL, Oracle, PostgreSQL is fixed. We will notify you when the new public build of dotConnect Universal is available for download.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: UniConnection InfoMessage event issue, never fires

Post by Shalex » Fri 08 Sep 2017 13:04

The new (3.70.1477) build of dotConnect Universal is available for download.

Post Reply