Connecting ODBC database to a LAN network

Finally i found out how, for those who have the same problem here’s the answer. I’m still new at this so maybe there’s another way how to do this, but this is how i do it :D

First i download this mysql-connector-odbc-3.51 and this MySQL GUI and you should have mySQL Database and install it.
Then go to Control Panel -> Administrative tools -> Data Source (ODBC ) in User or System DSN (sorry don’t know what’s the difference between these two) go to Add -> Scroll down to mysql ODBC 3.51 Driver. Now this is where i get confused at…

If you want this computer to be the server or the main database, you should just put the usual… mine goes :
Datasource name : Any name
Description : Any Description
Server : localhost
user : root
password : root
database : anydatabase

Then u Have to make an account to connect up Mysql GUI, find in mysql administrator -> User account, make an account in here and set your schema privileges (default database)

Then in the Remote computer or the computer you want to connect with, just install mysql-connector-odbc-3.51 then use the steps above where you go to data source (ODBC) then here’s my setting to connect :

Datasource name : Any name
Description : Any Description
Server : user : username password :passworddatabase : anydatabase

There you go it’s connected! well this is my way, i just found out maybe there’s another way to do this…

Subscribe to You Live What You Learn

Don’t miss out on the latest issues. Sign up now to get access to the library of members-only issues.
[email protected]