RE: How to connect Mysql Install on windows by ODBC from the different Loaction

This is possible but the first thing you need to arrange is how your user can access your machine at all from the other state. That is matter of networking, firewalls etc. and nothing to do with MySQL.

Once you are sure you have network access arranged you will need to tell your user the IP address/URL of your machine, the name of the database, the user name to use and the password. Armed with that he should be able to set up an ODBC data source in administrative tools in control panel. With that set up he can create links to the required tables from inside Access by choosing the ODBC data source.

John Bonnett

-----Original Message-----
From: rajkumar arya [mailto:[email protected]] 
Sent: Monday, 30 January 2012 4:44 PM
To: [email protected]
Subject: How to connect Mysql Install on windows by ODBC from the different Loaction

Hi,
 
I am new to mysql, I have install mysql 5.5.16 on window 7. My one user is sitting in diffrent State and i want to give him access to mysql database using odbc, so that he/she can update/view the relevant infromation in the databast by using ms acces as front end. Please suggest how it is possible.
 
Thanks
Raj Kumar 

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc