Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calling Stored Procedure
Message
De
09/01/2009 10:17:16
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01369317
Message ID:
01372354
Vues:
32
>Thanks.
>I have another problem; i try to explain it:
>1) I have my server with SQL server installed;
>2) in SQL server i have created the linked server, but foxpro tables aren't on the same server of SQL but on anotherone. I have put in datasrc the full path to point to data (for example \\server1\vfp\data);
>3) when i execute a query or open one view in SQL i receive an error message;
>4) if i put my fox tables in a local folder of my server where SQL i installed i have no problems.
>Where is the error ? There is a particular user i have to use or define on the "remote" server ? I have seen that in the properties tab of the linked server there are info about "Protection" but i inserted a user and its password to access but nothing changes.
>
>Thanks

Foxpro is a file based system. For it to work you need at least read rights to the folder where the data is on that remote computer. IOW from the computer where you have SQL server the current logon should be able to access the folder on remote.
I wouldn't use linked server to VFP when the data is on a remote computer. If you need to install something like SQL express on that machine, that instance accesses VFP and you access that SQL instance remotely.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform