>I'm looking into SQL Server Reporting as a company wide solution.
>It works with SQL Server data (of course!) native, via OLDEB and ODBC.
>It works with Oracle data (surprise!) native, via OLDEB and ODBC.
>
>It doesn't work with VFP data.
>Unless the data is on the same machine that Reporting Services is installed on.
>
>Anyone got any ideas?
>
>When the data is on the RS machine, it only needs 3 permissions: List Folder/Read Data, Read Permissions, Read Extended Attributes.
>I've got desperate enough to give FULL permissions to EVERYONE to the server share and folders and it still doesn't work.
What do you mean "it doesn't work"? What error(s) do you get?
If it's VFP7 or higher I think you have to use the OLEDB provider. Have you tried referencing the remote share by either UNC or a mapped drive letter?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up