Personal Video Database

Here's a copy of the log:

Virus or unwanted program 'TR/Swisyn.yvl [trojan]'
detected in file 'C:\Program Files\Personal Video Database\Plugins\imdb.dll.
Action performed: Deny access

Any ideas?

Quote from: swinster on February 07, 2010, 04:40:36 am

I really appreciate all this, but I had a thought and have finally resolved the issue.

server:E:\Users Shared Folders\me\My Documents\Personal Video Database\movies.pvd

Quote from: buah on February 07, 2010, 01:09:46 am

Did you try full syntax, for instance 127.0.0.1:C:\Documents and settings\All Users\....\Data\MOVIES.PVD?

Quote from: buah on February 07, 2010, 02:05:54 am

Yes, but I meant instead "server" to enter it's address.

With those two comments above, that's exactly what I suggested, too. I never suggested to use remote path.

Again apologies. However, as it was shown earlier (and above), if the path is actually a route to server share (either UDF or a mapped drive) it won't work. The database HAS to physically be located on the machine with the instance of FB is running AND the path MUST be local to that machine. I must admit, I didn't see the WIKI entry until after the fact.

For instance, all of these refer to exactly the same location, and would be acceptable references to access the resource from each machine, but only the first one works:

server:E:\Users Shared Folders\me\My Documents\Personal Video Database\movies.pvd - FB on a remote server, local path on server - WORKS!

server:\\server\Users\me\My Documents\Personal Video Database\movies.pvd - FB on a remote server, share on the same server - DOESN'T Work
127.0.0.1:\\server\Users\me\My Documents\Personal Video Database\movies.pvd - FB on local machine, share on remote server - DOESN'T Work
127.0.0.1:Z:\My Documents\Personal Video Database\movies.pvd - FB on local machine, mapped drive to remote server - DOESN'T Work


The biggest issue for me was that as I run a server and have all the users files redirected to shares on a server, and even though these shares use off-line files (so essentially I am using a local copy), the default install of PVD creates the DB in the "My Docs" folder - which is actually a server share.

Maybe examples of what WON'T work would be as useful as what will.

I really appreciate all this, but I had a thought and have finally resolved the issue.

You can specify the remote server as indicated in the posts above, but you need to pass the physical location of the database file on the SERVER, rather then with refernce to the local machine. So, we end up with a connection string that's:


server:E:\Users Shared Folders\me\My Documents\Personal Video Database\movies.pvd


Still, I'm a little confused as to why UDF notation didn't work, as this is still accessible from the server (i,e, \\server\users\me....).

This might be useful to stick in you solved problem in case anyone else wishes to run the database from a remote location.


Many thanks all. Now I just need to figure out how it all works.

Can you open movies.pvd from mapped drive without connecting to server?

No

I get the error:

---

2:I/O error during "@1" operation for file "@2".
Error while tring to open file.
The system cannot find the path specified.
Unsuccessfully...
Error code:24

---

Did you try full syntax, for instance 127.0.0.1:C:\Documents and settings\All Users\....\Data\MOVIES.PVD?

It works for me fine.

although 127.0.0.1 refers to you local machine, I have tried

server:\\server\Users\me\My Documents\Personal Video Database\movies.pvd

and I now get the error:

---

1:unavailable database
Unsuccessful execution caused by an unavailable resource
Error Code:55

---

As said, all permissions seem fine.  

Does this help? You shouldn't need to login to Firebird.

Unfortunately not. As you say, I shouldn't need a username and password and there isn't the moption to insert them anywhere.

How, exactly, are you specifying the connection? "[server name]:[database path]" should work.

I have tried a simple ip address or machine name, UDF convention and not your suggested method (with the braces). So I have:

server:Users\me\My Documents\Personal Video Database\movies.pvd

With this I get the error message:

---

2:I/O error during "@1" operation for file "@2".
Error while tring to open file.
The system cannot find the path specified.
Unsuccessfully...
Error code:24

---

Not sure what else to try.

Well, I tried install Firebird 2.1.3 on the server but cannot connect to it from PVD. The port is open, FB is listening on the sever and can be probed (3050 I believe). So I still can't open a file stored in my re-directed "My Docs" folder.

I will try FB 2.5 and see what happens.

Ah ha. With some pointer form here and the MC forum , I believe we have got somewhere.

Is is possible that PVD doesn't like UDF file names? My "My Docs" folder is re-directed to a server share and referenced via a UDF path name. If I actually try to create a new DB on a local HDD, then finally I can get PDV to work.

I don't believe its a permissions thing. The PVD data folder in "My Docs" was created by the PVD installation, and permissions are inherited, so full access is granted.

1. Is it a normal PVD installation or you are using PVD from usb stick?

Normal

2. Does PVD and Firebird have access to "My Documents" folder?

I don't see why not - how can i tell?

3. Would it help if you fully install PVD and Firebird and then install PVD again?

Do you mean uninstall, then re-install?

OK, the most should firebird that is already installed on your machine.
1. It is a newer version which is not compatible with PVD (it can be made compatible if you change fbembed.dll and fbclient.dll in PVD directory with newer ones)
2. Your firebird could have some special configuration preventing PVD from creating the database

Could you please try my suggestion in this topic: http://www.videodb.info/forum_en/index.php?topic=1644.msg7632#msg7632

Hmm, tried 1. Didn't work. Copied all the files from the zip to the PVD directory but still the same error. However, there was no fbclient.dll file in the zip.

2. This is a fresh install. not config has been changed. Defaults were selected (apart from disabling control panel as from the firebird site it indicated that this would corrupt the control applet in Vista.