Page 1 of 1

UniConnection InfoMessage event issue, never fires

Posted: Fri 14 Jul 2017 22:48
by idem84
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!

Re: UniConnection InfoMessage event issue, never fires

Posted: Mon 17 Jul 2017 21:37
by idem84
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();

Re: UniConnection InfoMessage event issue, never fires

Posted: Tue 18 Jul 2017 11:10
by Shalex
Thank you for your report. We have reproduced the issue and will notify you when it is fixed.

Re: UniConnection InfoMessage event issue, never fires

Posted: Fri 04 Aug 2017 15:37
by idem84
Hi! Do you have an ETA fix?
Thanks in advance!

Re: UniConnection InfoMessage event issue, never fires

Posted: Wed 09 Aug 2017 10:49
by Shalex
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.

Re: UniConnection InfoMessage event issue, never fires

Posted: Wed 09 Aug 2017 13:52
by idem84
Thanks I'll wait for it.
Will that event also work for the other data providers?
Thanks in advance!

Re: UniConnection InfoMessage event issue, never fires

Posted: Wed 09 Aug 2017 14:48
by Shalex
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.

Re: UniConnection InfoMessage event issue, never fires

Posted: Wed 09 Aug 2017 14:59
by idem84
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!

Re: UniConnection InfoMessage event issue, never fires

Posted: Thu 10 Aug 2017 09:21
by Shalex
We are working on the UniConnection.InfoMessage support for MySQL / Oracle / PostgreSQL. We will notify you when it is implemented.

Re: UniConnection InfoMessage event issue, never fires

Posted: Mon 14 Aug 2017 14:20
by Shalex
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.

Re: UniConnection InfoMessage event issue, never fires

Posted: Fri 08 Sep 2017 13:04
by Shalex
The new (3.70.1477) build of dotConnect Universal is available for download.