hi,
I used MySQL database server and VB.Net for my project and need to make a client-server connection.
can anyone help me? i have successfully connected my 2 laptops as server and client using ODBC connector.., but when I tried to access the database on the remote laptop, "Unknown database 'database_name' " appears. Can anyone tell me what is missing or wrong with my connection or configuration?
...
ivory
Last Activity: Jan 17 '13, 05:03 PM
Joined: Dec 17 '12
Location:
-
Unknown database ('database_name')
-
ivory started a topic How to configure Server-Client peer to peer connection using XAMPP MySQL server?in MySQLHow to configure Server-Client peer to peer connection using XAMPP MySQL server?
Our group are trying to make a Server-client peer-to-peer connection using 2 laptops, and we used VB.Net and MySQL Xampp as the database. The network connection was fine, the 2 laptops successfully ping each other. But when we tried the server-client connection, it was not working. The actions being done on client PC was not recorded on the Server laptop. This is our connection codes in the Global Configuration in VB.Net:
...Code:Private con
Last edited by zmbd; Dec 17 '12, 12:44 PM. Reason: [Z{Please use the <CODE/> button to format posted code/html/sql}] -
ivory replied to How to connect MySQL server using ODBC connector? how to configure ODBC connector 3.5in MySQLhi johny10151981,
I've already tried assigning static IP ADD, both pc has static IP. 192.168.1.1 is the SERVER IP while 192.168.1.2 is the client IP address.
Still server-client connection is not working, though network connection is just fine. -
ivory replied to How to connect MySQL server using ODBC connector? how to configure ODBC connector 3.5in MySQLHow to configure Server-Client peer to peer connection using XAMPP MySQL server?
Our group are trying to make a Server-client peer-to-peer connection using 2 laptops, and we used VB.Net and MySQL Xampp as the database. The network connection was fine, the 2 laptops successfully ping each other. But when we tried the server-client connection, it was not working. The actions being done on client PC was not recorded on the Server laptop....Leave a comment:
-
ivory started a topic How to connect MySQL server using ODBC connector? how to configure ODBC connector 3.5in MySQLHow to connect MySQL server using ODBC connector? how to configure ODBC connector 3.5
What values should I put in every open fields? I previously used XAMPP and here's the Global config:
How to change this configuration if I'm going to use the ODBC connector and stand alone MySQL rather than XAMPP?Code:Private con As New MySqlConnection("Server=localhost; Port=3306; Database=payrolldb; User Id=root; Password=''; ")
please help as I'm not familiar with the ODBC connection.
I have to connect to peer-to-peer...Last edited by zmbd; Dec 17 '12, 01:32 PM. Reason: [Z{Please use the <CODE/> button to format posted code/html/sql}]
No activity results to display
Leave a comment: