Make a DSN in you client too.

to create a runtime DSN

local m_x

declare integer SQLConfigDataSource in odbccp32.dll integer,integer,string,string
tcDSN='YourDSNName'
tcPath='X:\DataDirectory'

lcType='Microsoft Visual FoxPro Driver'
lcODBC='DSN='+alltrim(tcDSN)+chr(0)+;
'Description='+alltrim(tcDSN)+chr(0)+;
'SourceDB='+alltrim(tcPath)+chr(0)+;
'SourceType=DBC'


SQLConfigDataSource(0,3,lcType,lcODBC)
m_x=SQLConfigDataSource(0,1,lcType,lcODBC)

if m_x=0
return .t.
else
return .f.
endif

This example is to create a ODBC DSN to a VFP Data source. 

>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