I required named pipe connection to connect wamp server and VB.NET

**tasawer** · Jul 9 '15, 01:43 AM

I have a desktop VB.net Application that successfully connects to SQL server both from the server and workstations.
One aspect of the application is to update data from MySQL server.
I have successfully setup WAMP SERVER on port 80 to be accessed by workstations using the server IP address in the browser; like this

Code:

http://192.168.1.180

(SQL Server and WAMP Server are on the same PC)

the app.config file for the desktop application, allows access to SQL Server but it will not allow access MySQL Server from a workstation.

Code:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <appSettings>
    <add key="connection String" value="Data Source=\\server\SQLExpress;Initial Catalog=database;Persist Security Info=True;User ID=sa;Password=xxxx" />
    <add key="MySQLconnection String" value="server=localhost;port=3306;uid=root;database=database;pwd=xxxx" />
  </appSettings>
</configuration>

in the MySqlconnection string, I have changed localhost to 192.168.1.180 and everything else I could think of, but all in vain.

further advice and help will be appreciated.