.Net connector suddenly fail to connect
Posted by: Francois Carabin
Date: September 28, 2016 01:36AM

Hello,

I faces a very strange behavior:
This issue appears on a dedicated customer infrastructure,
connection to Mysql DB suddenly always fail using .Net Connector

If server IP is bad: good error message
If user/login is bad: good error message
If user/login is OK, rights are bad (from not allowed IP) : good error message
If all is OK: connection fails wiht timeout (I see the connection with Mysql Workbench on the DB server)

The connection only works from the local database server (localhost or 127.0.0.1)

Connections can come from several subnets.

* All connections are OK using Mysql Workbench from all subnets
* All connections are OK using C++ connector with a VStudio 2015 test program from all subnets
* All connections are OK from a PHP site using mysql from another subnet (not tested on all subnets)
* All connections failed using .Net connector on a VS Studio 2015 C# test program from all subnets.
* All connections failed using .Net connector from IIS C# WS another subnet

I do not understand what can be the problem ......
Should it be something about firewall application rules ?


Any help is welcome ;)

Regards

PS: the WS uses .Net Connector V5.2.5.0 , C# test program has been compiled with the same .Net connector, and also other compiled with several versions up to V6.9.9.0 for the same result :(

Options: ReplyQuote


Subject
Written By
Posted
.Net connector suddenly fail to connect
September 28, 2016 01:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.