English > Support
Cannot connect to database
Colin:
Hi
First of all thanks for what seems like a nice piece of software. I'm still trying to figure out how to get the best out of it, but I've only had it for three days and have managed to build a database from existing files on HDD's of 1300 movies. I've had a couple of nasty scares when trying to reopen the database... It would open ok and show all the records but without the majority of the content... all the posters gone rattings basically everything but the Title, imdb URL and the date added fields... Not really sure how I managed to get it back on track (I was panicked :( thought I'd lost it all) but it all came back :)
Then I started getting error messages like those below:
------------------------- ---------------------- -------------------------
1:I/O error for file "C:\Data\PVD\MY MOVIES.PVD" Error while trying to open file
The process cannot access the file because it is being used by another process.
Unsuccessful execution caused by a system error that precludes successful
execution of subsequent statements
Error Code: 24
Failed to open database! Exception: I/O error for file CreateFile (open) "C:\Data\PVD\My Movies.pvd" Error while trying to open file.
------------------------- ---------------------- -------------------------
I was looking in the forums and noticed the same errors, but the dialogue was a
bit over my head :( and it didn't seem to be resolved.
I am running PVD v 0.9.9.21 on Win7 64bit os
I don't believe I have Firebird installed (it's not showing in Task Manager) and I used the installer program from PVD. So am I right in saying that it is embeded, that is the RDBMS engine is in the PVD programe?
Anyway's what I found was that:
viddb.exe *32 was still running in task manager (PVD was not open)
So I end the viddb.exe *32 task and PVD opens normally
rick.ca:
Welcome, Colin.
First of all, I have to say the only way to avoid "nasty scares" with any application like this is to make regular backup. What "regular" means is up to you. If you don't mind losing a week's changes, then weekly. If you can only tolerate losing what you did today, then daily. And that backup should be automated. Otherwise, one way or another, sooner or later, you'll be blaming yourself for not making a backup when you should have. ;)
That being said, the first problem doesn't suggest anything is wrong with the data. The program does sometimes have difficulty displaying the information panel. These issues are often fixed by refreshing or changing records, but sometimes require the program be restarted.
Perhaps you know that, and you're associating the second issue with the first because it happens after you've attempted to restart the program. If the program is in serious trouble (and, from your description, it does seem more serious than the display problems I'm used to), it's quite likely it won't be able to close properly. You may need to use Task Manager to terminate the process.
This brings us to the second issue. Given that the program process is still running, this is exactly what should be expected. That process is still maintaining a connection to the database. The embedded version of Firebird doesn't support multiple connections. The error message you get when trying to start another instance of the program means exactly what it says.
This doesn't help much if the problem keeps happening. But maybe it will help you investigate further without fear you're going to lose all you data...After you've properly restarted the program, how long is it before it happens again? Does it only happen on startup? Is it ever not fixed by terminating the process and then starting the program again?
Colin:
After a bit more investigation I find that when I minimize PDV, it does not show up on the task bar. So you think it's closed. If you check Task Manager's Applications tab it isn't there. But it is still running in the Processes tab.
But this doesn't always happen... at the moment it is in the taskbar and even pops up a small window on mouseover... So I'm not really sure if it's a problem with PDV or windows. :)
Should I be running PDV in ... what's it called latency mode or something... like you sometimes have to do with winxp programs?
rick.ca:
--- Quote ---After a bit more investigation I find that when I minimize PDV, it does not show up on the task bar.
--- End quote ---
That's a "feature" provided by the PVDtoTray plugin. You can disable it (and I recommend doing so) by deleting or renaming C:\Program Files (x86)\Personal Video Database\Plugins\pvdtotray.dll.
--- Quote ---Should I be running PDV in ... what's it called latency mode or something... like you sometimes have to do with winxp programs?
--- End quote ---
You probably mean "PVD" and "compatibility mode," but no, it runs fine in Windows 7 x64. ;)
Navigation
[0] Message Index
[*] Previous page
Go to full version