Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tool to open and modify DBF file?
Message
 
À
02/12/2008 21:09:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01365258
Message ID:
01365298
Vues:
19
>>>>>I need to modify a couple of tables residing on customer server. I connect to the server via VPN. I don't want to install a full version of VFP on the server. Does anybody know if there is an .EXE tool that I can copy to the custom server, run it there and open and modify (hack) some tables? I would copy the tables to my PC and modify on my PC but the files are quite big. If I don't find the right tool to do it on the server, I will have to copy the files back and forth.
>>>>>
>>>>>Thank you.
>>>>
>>>>If you are connecting via VPN then you should be able to use your VFP on your computer as long as you are connecting using an account with rights to the read/write the files.
>>>
>>>I do have rights to the server (full rights). But I am not sure how I would point to the server drive from my PC. For example, if I have Command prompt of my VFP open, how would I call "USE MYTABLE" where the MYTABLE reside on the server and not on a mapped drive. Are you suggesting that I can map the server drive to my PC? Then how?
>>>
>>>Thank you.
>>
>>You should be able to map a drive or use a UNC as a direct path to the files. If you can find the UNC path to your file (ie \\servername\sharename\folder\subfolder\filename) you should be able to use it directly.
>>
>>Depending on the VPN, you may not have DNS resolution in order to specify the server by name - instead you may have to use \\serverIPaddress\sharename\folder\subfolder\filename.
>>
>>for example, to access a table on my network from my contractor VPN, you might use..
>>
>>USE \\CURLYQLINK\Projects\VFP\COMPANYB\DATA\thistable.dbf exclusive
>>
>>or, if DNS doesn't resolve CURLYQLINK, use the IP address instead..
>>
>>USE \\10.0.0.251\Projects\VFP\COMPANYB\DATA\thistable.dbf exclusive
>
>Hmm, if the tables are large this could be painfully slow. People get used to LAN speeds of 100Mbit/s or even 1Gbit/s when accessing Fox tables. A lot of VPNs have effective throughput only a few percent of that e.g. 1 to 5 Mbit; every operation could take 20, 100 or even more times longer.
>
>I think Dmitry should look hard at options for getting a remote console, if at all possible (RDP, TS, VNC etc.)

That would be faster, although it limits the toolset. It depends on what he needs to do and how much data has to move across the wire.
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform