Page 1 of 1

The underlying provider failed on Open

Posted: Tue 11 Jan 2011 08:33
by yhersh
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

Posted: Wed 12 Jan 2011 17:21
by Shalex
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.

Posted: Thu 13 Jan 2011 16:12
by yhersh
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

Posted: Mon 17 Jan 2011 09:07
by Shalex
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).