Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Upload SQL Server Internet form .DBF tables
Message
From
26/08/2007 12:48:20
 
 
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01250478
Message ID:
01250501
Views:
19
Carlos,

Have you thought about using a .NET Web Service instead of an ASP.NET page? I guess it depends on how much data you're sending to the server, but I think it'd be cleaner to send it from your VFP database (either in a VFP app or a .NET app on the local machine) through a Web Service. The rest of the server-side processing would be the same (except for that part where you're reading from an Access database ... you could cut out that step completely). No FTP necessary in that case.

~~Bonnie



>Hello To all :
>
>For Update a SQL server Database located at Internet server, from VFP Tables
>located in My Local Machine. I was write a beginner solution :
>
>1.- from my local machine I export .DBF file to .mdb file (Acces Format)
>2.- I FTP the .mdf File to the server, and from Internet server
>3.- I Run a single ASP.Net pages for read the record from access and Write to SQL
>
>I Think, is not the better solution.
>Please if somebody can help me to optimize this process.
>Note.- The provider Internet Hosting does not support VfpOledb
>
>Thanks Very Much.
>
>Carlos
>
>On the Road In Circle Of Life
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform