I have 2 computers. Both with w7 as os. I have installed wampserver on one of them. I have mysql database on wampserver. Then I have made a vb.net program to connect to mysql database. I have put the program on both computers. What I want to do is for those two programs to see the same database that is on one computer. For them to be able to add, delete, update that 1 database. How do I do that? How do I network the mysql database? Do I also have to install wampserver on the other computer? What do I do? Please enlighten me.
A:
MySQL is a database management system which will respond to ODBC (and equivalent) connections. Get the name of your computer that is running the MySQL database, and go to http://www.connectionstrings.com/mysql to find an appropriate connection string to use in the System.Data.OleDBConnection connection string.
Michael Rodrigues
2010-03-23 04:50:17
yeah, I already know that. I already have the program. Do I have to install connector.net to the 2nd computer which doesn't have wamp server installed to make this work?
2010-03-23 07:18:38
Yes - the original WAMP server aleady has the required stuff (it came with MySQL), but the 2nd computer needs to have the interface driver (i.e. Connector/Net) to handle the communication between .NET and MySQL
Michael Rodrigues
2010-03-23 23:18:12
I already installed connector/net to the 2nd computer(w/c does not have wampserver installed)I also opened port 80 for both tcp and udp. In the 1st computer(w/wampserveer). Do I also need to open port 80 on the 2nd pc?what do I do next?
2010-03-23 23:44:01