Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BeatriceC

    Query VFP Table through SQL Linked server creates temp files in VFP directory

    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!
  2. BeatriceC

    Query VFP Table through SQL Linked server creates temp files in VFP directory

    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...
  3. BeatriceC

    SQL Linked server StoredProcefure job creates temp files

    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...
  4. BeatriceC

    SQL Linked server to VFP flat tables

    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?
  5. BeatriceC

    SQL Linked server to VFP flat tables

    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...
  6. BeatriceC

    SQL Linked server to VFP flat tables

    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...

Part and Inventory Search

Back
Top