472,950 Members | 2,160 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,950 software developers and data experts.

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 5759

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

Similar topics

5
by: richard | last post by:
I have a simple test to pass information from a client to a server using named pipe. what I really want is: when I type a line on the client, the server will output the line immediately. but to my...
0
by: Nick | last post by:
hi,all I have a question about named pipe. How does the pipe server know the client closed the connection? We can refer the example for CreateNamedPipe() function in MSDN. In block mode, once...
18
by: Jon Delano | last post by:
Hey all I am building a new computer. I have Windows XP Pro with SP2 and all the updates. I installed VS 2003. Then copied a project from my old computer to the new one. When I try and run...
3
by: vincent Blain | last post by:
Does anyone know a way to creating a Named Pipe from VB.Net. Vince
0
by: EricR | last post by:
I am trying to use .NET to "tap into" a named pipe created by a non .NET 3rd party application. Specifically, the application is a table loading utility. It opens a named pipe and waits for input....
0
by: DBC User | last post by:
Hi All, I am trying to create a named pipe for two of my process to communicate. I wrote bunch of unit test to make sure the funcationality works the way it is supposed to be. In this app I am...
0
by: jeb2000 | last post by:
I am rather new to pipes, but I have two c# programs that are communicating via a named pipe. This is working fine on two of my XP Pro SP2 machines. However, when I port to a third machine (also XP...
1
by: SHEHU ABDUL | last post by:
How can I connect WAMP server to the php page?
5
by: prafullvyas272 | last post by:
I want to connect wamp:phpmyAdmin: mysql database with my netbeans java project. i wrote all connection code and also connect "mysql-connector-java-5.1.11-bin" and there is no error but when i'm...
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.