Search results for query: *

Great, thank you. I will look into the permissions first. If that does not resolve it, I will plan to have the files deleted. Thanks so much!

I have a legacy Visual FoxPro application with flat tables that I needed to access the tables from SQL. I create a Linked server on SQL Server Management studio. The created a Database. Create a stored procedure that copies certain tables to the database using openquery. I scheduled a job to run...

I have a legacy Visual FoxPro application with flat tables that I needed to access the tables from SQL. I create a Linked server on SQL Server Management studio. The created a Database. Create a stored procedure that copies certain tables to the database using openquery. I scheduled a job...

I think I follow. I'm not sure how to grant permission to a non domain account to the flat table share. Also, what do you mean by "session 0(without Login)" Is this a setting on th Linked Server?

Thank you for the responses. There are apps using the data. Currently the individual is accessing the flat table date at a 3 minute interval, so pretty frequently. He is using MS Access linked tables to access the tables. He has started receiving errors connecting to some of the tables and is...

I have an Visual FoxPro application which uses flat tables. I need to be able to query those tables using SQL Server 16 (64 bit). I know VFP OLEDB Provider does not support 64bit. It was suggested in another post that it may be possible to use Linked server on SQL 64bit to SQL 32bit and...