The underlying provider failed on Open

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
yhersh
Posts: 22
Joined: Fri 30 Apr 2010 12:13

The underlying provider failed on Open

Post by yhersh » Tue 11 Jan 2011 08:33

Hi,
From time to time we are getting the following erros while trying to open connection.

'[2011-01-11 09:51:21.063] 26495_2_359483 Error: The underlying provider failed on Open.'
'[2011-01-10 20:06:53.125] 26495_2_359483 Error: Can't connect to MySQL server on '[HOST_NAME]' (10061): Authentication failed.'
'[2011-01-10 20:06:53.125] 26495_2_359483 Error: Unable to read data from the transport connection: An established connection was aborted by the software in your host machine.'
'[2011-01-10 20:06:53.125] 26495_2_359483 Error: An established connection was aborted by the software in your host machine'

The MySql server is hosted in Amazon RDS and available in all times.

The dotConnect version in the server is 5.80.180.0
connectionstring value:
persist security info=True;Pooling=False;Connection Timeout=15;Default Command Timeout=0;CharSet=utf8;Unicode=True

Thanks

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

Post by Shalex » Wed 12 Jan 2011 17:21

As I understand, you are getting this error in your deployment environment, aren't you? If yes, please register configuration information in the DbProviderFactories section of the *.config file to inform your environment about the existence of the provider factory as it is described at http://www.devart.com/dotconnect/mysql/ ... yment.html. As an alternative, you can make minimal install of dotConnect for MySQL in your deployment environment.

Notify us about the results.

yhersh
Posts: 22
Joined: Fri 30 Apr 2010 12:13

Post by yhersh » Thu 13 Jan 2011 16:12

Hi,

All deployment servers have the min. installation of the dotConnect
I will add the following code to the services config as you recommend and let you know of the results

Thanks

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

Post by Shalex » Mon 17 Jan 2011 09:07

Please notify us about the results. If possible, send us your call stack and describe what your code does. A small test project will be appreciated (contact form).

Post Reply