View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0002859||VALENTINA SERVER||API||public||2007-11-23 03:39||2007-11-24 06:02|
|Reporter||Fabian||Assigned To||Ivan Smahin|
|Target Version||Fixed in Version||3.5|
|Summary||0002859: LoadDump does not work with Vserver|
|Description||myDB.LoadDump("\\Server\_DMXPData\Configuration.SQL","",kSQL) does work fine in local mode but not with VServer. The returned error is 365826 (&H59502, File not found). Configuration.SQL holds the dump of one table. Behaviour tested with 3.0.2 AND 3.5!|
Using VCOM under VB6
|Tags||No tags attached.|
I have tried it with vStudio and it works without any issue. Are you sure that file exists and available?
As far as i get it 'Server' is some computer where vServer runs - right?
In this case you do some overhead copying file to the server and then call LoadDump.
Look - any dump operation works in terms of client computer.
So it would be as easy as myDB.LoadDump("c:\Configuration.SQL","",kSQL).
Let's discover how it works. vClient reads the file and send it to the server as well as other parameters. Most probably it would be compressed data sending over the net. Note - server is able to handle another clients at the moment. Then vServer reads the packet and gets dump-file content into some temporary location. And finally runs kernel mechanic to load dump from that temporary location.
So it is very efficient way to operate with files in client-server environment.
1. Client operates with files in nature manner - no difference - local or client mode.
2. Compression aloows to reduce traffic and network loading.
3. Dump operation is performed for some temporary location on server side. So it would be as fast as in local mode.
Yes file exists. It works with myDB.LoadDump as far as I use local mode. But as soon as I switch to server mode I get error 365826. It is interesting that ErrorString is empty.
I use LoadDump only occasionally to exchange a configuration table. The dump was done after each backup to save the latest properties of my application
1) so 2 computers are in game?
ONE with VSERVER
SECOND with VCLIENT
or ONE computer is in game?
or 3 computers are in game?
2) DUMP file is located on VCOM computer?
I checked this on one computer. One time running the code under VServer the other time under VClient. I tried several different paths (\\ROM\_DMXPData\DBBKUP\Configuration.SQL or C:\_DMXPData\DBBKUP\Configuration.SQL) but with no luck under VServer. No other application has a connection open or have access to the Configuration.SQL file.
BTW: Before proceeding with LoadDump I check if the file exists in my application!
Basic things like connection, open DB and so on are OK because I use this small app for a lot of utility functions like printing DB stats, reindexing ...
|2007-11-23 03:39||Fabian||New Issue|
|2007-11-24 00:14||Ivan Smahin||Note Added: 0002962|
|2007-11-24 00:58||Fabian||Note Added: 0002963|
|2007-11-24 01:09||Ruslan Zasukhin||Note Added: 0002964|
|2007-11-24 01:34||Fabian||Note Added: 0002965|
|2007-11-24 06:02||Ivan Smahin||Status||new => resolved|
|2007-11-24 06:02||Ivan Smahin||Fixed in Version||=> 3.5|
|2007-11-24 06:02||Ivan Smahin||Resolution||open => fixed|
|2007-11-24 06:02||Ivan Smahin||Assigned To||=> Ivan Smahin|