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 "Command Window".

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

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

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

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

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

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

Now, We display query result in FoxPro using BROWSE command. Write below command & hit "Enter" key from the keyboard.

BROWSE

Query Result:

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

SQLDISCONNECT(CN)