Set MySQL in VFP from internet VFP version 8

Asked By altha tuller 0 points N/A Posted on - 01/30/2013

 

Hi, I deliberated if anyone could help, I have a MySQL database that is hosted on a UNIX server on the internet I wanted to connect to it with Visual FoxPro Vr 8 from a Windows PC. Is this probable, How do I set mysql in VFP to do this ?

• Status: Open
• Question Views: 819
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Schneider Matthew 0 points N/A #171840

Set MySQL in VFP from internet VFP version 8

Hi Altha Tuller,

It is possible to connect VFP with MySQL database in Windows. In order to do that, you should install MySQL ODBC.

 

And make sure that your UNIX system is reachable from the Windows System.

 

You can download MySQL ODBC driver from here. The latest version is 5.2.3.

 

Below is a sample code for setting up MySQL connection using VFP.

 

lcServer="IP address of the server where mysql is installed"

lcDatabase="Your MySQL database name"

lcUser = "Username"

lcPassword = "Password"

lcStringConn="Driver={MySQL ODBC 5.2.3 Driver}"+; //If you are using 'MySQL ODBC 5.2.3 Driver'

             ";Server="+lcServer+;

             ";Database="+lcDatabase+;

             ";Uid="+lcUser+;

             ";Pwd="+lcPassWord

lnHandle=SQLSTRINGCONNECT(lcStringConn)

 

Hope it helps.

About Schneider Matthew

Questions
3

Answers
107

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 01/30/2013
• Question Category: MySQL Server