Hello,
I am experiencing a Socket connection error with ADO.NET provider for dotConnect for Magento while opening a connection. Interestingly there is no problem connecting to the database with MySQL Nuget package by Oracle.
The Connection Errors are:
Inner Exception 1:
MagentoException: Unable to connect to the remote server
Inner Exception 2:
WebException: Unable to connect to the remote server
Inner Exception 3:
SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 000.000.000.000:80
Tried both the following ways to connect:
MagentoConnection myConnection = new MagentoConnection();
myConnection.ConnectionString = "domain=random.com/coh_magento;user=remoteuser;password=pass;";
myConnection.Open();
AND
MagentoConnectionStringBuilder connectionStringBuilder = new MagentoConnectionStringBuilder();
connectionStringBuilder.Domain = "random.com/coh_magento";
connectionStringBuilder.User = "remoteuser";
connectionStringBuilder.ServiceVersion = MagentoServiceVersion.Ver2;
connectionStringBuilder.Password = "pass";
MagentoConnection myConnection = new MagentoConnection(connectionStringBuilder.ConnectionString);
myConnection.Open();
What can be the problem? Thanks in Advance.