Tools we are going to use are:
Visual Foxpro (ver 6.0 up)
mysql server-5.0.x - download mysql server-5.0.81-win32.msi
mysql connector 5.1 - download mysql connector 5.1
mysql tools for 5.0(Administrator)- download mysql toos for 5.0
● Configuring mysql server
click standard configuration
root password: inv
confirm : inv
click execute
note: if the service is not successfully installed. you need to re-configure it again. otherwise you will not be able to access the mysql server
● Run mysql connector windows installer package
after installation go to control panel->administrative tools->data sources(ODBC)
under user dsn click add. select mysql connector 5.1 server
next screen
data source name: inventory
server: your computer name
(in my case i use rca)
user: inv
password: inv
database: leave blank
if you have already created a database select from the drop down list.
click ok
● run mysql tools for 5.0 installer and follow installation process