By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,441 Members | 998 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,441 IT Pros & Developers. It's quick & easy.

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

P: 4
What values should I put in every open fields? I previously used XAMPP and here's the Global config:
Expand|Select|Wrap|Line Numbers
  1. 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!
Dec 17 '12 #1
Share this Question
Share on Google+
6 Replies


P: 4
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:

Expand|Select|Wrap|Line Numbers
  1. 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.
Dec 17 '12 #2

100+
P: 1,059
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.
Dec 17 '12 #3

100+
P: 1,059
What compiler are you using? if c/c++ then directly use there libraries to connect
Dec 17 '12 #4

P: 4
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.
Dec 17 '12 #5

100+
P: 1,059
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
Dec 18 '12 #6

PsychoCoder
Expert Mod 100+
P: 465
Since your 2 threads are basically asking the same thing I've merged them into a single thread.
Dec 18 '12 #7

Post your reply

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