How to connect and use FoxPro with QODBC

Open Visual FoxPro from 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 it by hitting the "Enter" key on the keyboard.

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

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

Now, We will execute the query to QuickBooks from FoxPro using the SQLEXEC command. Write the below command & hit the "Enter" key from 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 below command & hit the "Enter" key from the keyboard.

BROWSE

Query Result:

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

SQLDISCONNECT(CN)