How to connect and use FoxPro with QODBC

Open Visual FoxPro from the Start Menu:

FoxPro started:

Open "Command Window" from Windows Menu:

"Command Window" Opened. You can execute FoxPro commands from the "Command Window."

You need to write FoxPro commands in the "Command Window" & execute them by hitting the "Enter" key on the keyboard.

First, we will connect to QuickBooks from FoxPro using the SQLCONNECT command. Write the command below & hit the "Enter" key on the keyboard.

CN = SQLCONNECT('QuickBooks Data', '', '')

Now, we will execute the query to QuickBooks from FoxPro using the SQLEXEC command. Write the command below & hit the "Enter" key on the keyboard.

SQLEXEC(CN , "SELECT TOP 10 Name FROM Customer","csrCust")

Note: The above query is for testing purposes only. You can change the query as per your requirement.

Now, we display query results in FoxPro using the BROWSE command. Write the command below & hit the "Enter" key on the keyboard.

BROWSE

Query Result:

You can disconnect the connection to QuickBooks from FoxPro using the SQLDISCONNECT command. Write the command below & hit the "Enter" key on the keyboard.

SQLDISCONNECT(CN)