i have a Sample.DBC in W2K server.
ODBC is mapped to this. DNS name is 'Sample'

code inside form.init() is :

nConn = SQLCONNECT('Sample','','')
SQLEXEC(nConn,'SELECT * FROM customer','customercursor')

the above works fine if form is compiled to exe and run from server.

but if the same exe is run from a workstation ( directory of exe is mapped to a drive ) , nConn is error.

what I am trying to do is running VFP exe but the data is hidden but accessed through server ODBC ?

please guide me.

thanks