468,544 Members | 1,735 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,544 developers. It's quick & easy.

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

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
6 5635
ivory
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
johny10151981
1,059 1GB
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
johny10151981
1,059 1GB
What compiler are you using? if c/c++ then directly use there libraries to connect
Dec 17 '12 #4
ivory
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
johny10151981
1,059 1GB
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
465 Expert Mod 256MB
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.

Similar topics

1 post views Thread by Nikola Skoric | last post: by
7 posts views Thread by ajikoe | last post: by
5 posts views Thread by Carlo Tambuatco | last post: by
4 posts views Thread by courtney.machi | last post: by
2 posts views Thread by =?Utf-8?B?RGF2aWRF?= | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.