Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can quick execute sql using oledb in network drive d
Message
From
08/03/2012 07:55:05
 
 
To
08/03/2012 03:51:35
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Environment versions
Environment:
VB 9.0
OS:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01537569
Message ID:
01537590
Views:
27
> I use vb.net , oledb to connect the visual foxpro database (.dbf file). I write a simple program to connect local database is no problem.
>But i use to connect other computer database is very slow and time out.
>( I already mount the network drvie first \\192.168.1.92\Test Escale equal to I:\ )
> Anyone know how to solve this problem? thank you all~~~
>
>
>     OleDbConnection("Provider=VFPOLEDB.1;Data Source=I:\pos.DBF")
>
>
If this is on the same network, the transfer speed should at 100 mbs. Have you checked the stats to see how long the process take to execute on that server? The first issue here would be to determine where it is slow.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform