VStudio Clone puzzle, also, persistent record lock

[Ruslan Zasukhin]

On 11/10/11 5:32 PM, "Robert Nichols" <robert at formworkusa.com> wrote:

Hi Robert,

> I'm trying to use the current version of Valentina Studio to clone a database.
> 
> First problem: I try to do the clone on the machine where Office Server is
> running, but I shut down Office Server and try to open *.vdb file locally.
> VStudio says it cannot open file. Strange, as Server was successful in opening
> and serving database.
> 
> Second problem: So, I start Office Server, use VStudio to connect to served db
> via localhost. All good. When I invoke the "Clone" command, I am asked to name
> new file. I do, then VStudio does a little work, then complains that the file
> I named "does not exist". Funny, since I was expecting VStudio to create the
> file. Kernel error: 0xffffffd5.
> 
> Finally, I am trying to clone because a record remains locked even after
> stopping and restarting Office Server. I can start the server, go straight to
> VStudio, execute a very simple sql statement "select *, recid from phases
> where recid = 1163" requesting RW cursor and get an error message indicating
> record is locked. Restart serverŠsame result.
> 
> Grateful for any help.

1) As I remember Clone() do not works for dbs under vserver.

2) strange that vstudio refuse to open that db.

Try may be COPY that db to desktop or other folder,
And try again open it locally

To open also It should be possible just drag and drop .vdb file into window
of Schema Editor when it is in the COLUMN mode ...

Your db has .vdb ext ?


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]