>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

Use a connection string instead. ie:

lcDBCFullpath = "\\servername\sharename\extrapath\testdata.dbc"
lcConStr="DSN=Visual FoxPro Database;"+;
    "SourceDB="+lcDBCFullpath+";"+;
    "SourceType=DBC;Exclusive=No;BackgroundFetch=Yes;"+;
    "Collate=Machine;"
lnHandle = SQLStringConnect(lcConStr)     
SQLExec(lnHandle, "select * from customer","crsResult")
SQLDisconnect(lnHandle)

If you put the data on an NT server directory with 'list directory contents' disabled for users you can almost hide it. For further control you might use winapi to log a special user with RW rights instead of just blocking dir listing.
Cetin