468,483 Members | 2,611 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,483 developers. It's quick & easy.

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

106 100+
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
Expand|Select|Wrap|Line Numbers
  1. 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.

Expand|Select|Wrap|Line Numbers
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <configuration>
  3.   <appSettings>
  4.     <add key="connection String" value="Data Source=\\server\SQLExpress;Initial Catalog=database;Persist Security Info=True;User ID=sa;Password=xxxx" />
  5.     <add key="MySQLconnection String" value="server=localhost;port=3306;uid=root;database=database;pwd=xxxx" />
  6.   </appSettings>
  7. </configuration>
  8.  
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.
Jul 9 '15 #1
0 4748

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by richard | last post: by
reply views Thread by Nick | last post: by
3 posts views Thread by vincent Blain | last post: by
reply views Thread by EricR | last post: by
reply views Thread by DBC User | last post: by
reply views Thread by jeb2000 | last post: by
1 post views Thread by SHEHU ABDUL | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by kmladenovski | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.