How to connect MySQL server using ODBC connector? how to configure ODBC connector 3.5

[ivory]

What values should I put in every open fields? I previously used XAMPP and here's the Global config:

Private con As New MySqlConnection("Server=localhost; Port=3306; Database=payrolldb; User Id=root; Password=''; ")

How to change this configuration if I'm going to use the ODBC connector and stand alone MySQL rather than XAMPP?
please help as I'm not familiar with the ODBC connection.

I have to connect to peer-to-peer network: Server-client connection using that database server, what are the configurations that i need?

Thanks in advance!

[ivory]

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:

Private con As New MySqlConnection("Server=localhost; Port=3306; Database=payrolldb; User Id=root; Password=''; ")

We tried to replace the value of Server from localhost to the IP ADDRESS of the Server PC but still not working.

please help us to solve this problem.

[johny10151981]

You said you are trying to do peer to peer then your host cant be localhost. use static ip of the server.

And dont forget to let the user to connect with that IP. You should read more about Host issue.

[johny10151981]

What compiler are you using? if c/c++ then directly use there libraries to connect

[ivory]

hi 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.

[johny10151981]

As I told you, your user would have to have ability to connect with 192.168.1.2. i.e. create the same user with same password and this host

[PsychoCoder]

Since your 2 threads are basically asking the same thing I've merged them into a single thread.