I've written a program that utilizes a view of an OBDC source to store data. But when I built an executable out of the file, it prompts me for a .dbf file. I tried replacing the statement in-program with the SQL displayed when I looked at the SQL of the View, but that doesn't work.
Here is the program line that works in foxpro with the ARRESTSVIEW view:

SELECT ALLTRIM(TICK_NUM) AS TICKUPD FROM ARRESTSVIEW INTO Cursor existingrecs_cursor TICK_NUM = alltrim(ARREST_SRC.TICK_NUM)

Here is the SQL statement that defines Arrestsview connection:
SELECT *;
FROM SFHL_DATA.ARRESTS Arrests

How can I write this to work form an executable, so that it knows and recognizes the ODBC connection?