Pvd locks the Firebird database...

[raldo]

Hi,

In my effort to make a plugin for JRiver MediaCenter for PVD import, I have noticed that PVD locks the firebird database (.pvd)

Is it possible to change PVD so that other clients clients can be attached?

I.e. in PVD, disconnect after operations towards the DB are finished... Reconnect when new stuff must be done.

(I noticed that Firebird Maesto also locks the DB...)

[nostra]

If you need such functionality then you should install firebird server and connect to the database using the "connect to server" function.

[raldo]

If you need such functionality then you should install firebird server and connect to the database using the "connect to server" function.

Yes, that is one solution, but as far as I understand, a server install is hardly something a casual user would accept (with extra windows OS services etc.)?

I presume that's the reason why you use fbembed.dll too?

[nostra]

There is no way unblocking the file if not using the server.

Actually installing the server with default settings does the trick pretty good, so I think it is easy enough for the majority of users.
I do not see anything wrong with running an extra service.

[rick.ca]

I think it is easy enough for the majority of users.

True—It works for me!

Once Firebird server is running as a service and and you've "connected to server," it's done—it will do so automatically on startup. The only thing that gave me a bit of trouble was it's so seamless, it's impossible to tell whether it's connected to the server or directly. If that mattered—and it probably doesn't—I can include my computer name or IP address in the connection string, and then that will appear in the title bar. Also, if I want to switch connection methods—and this too seems pointless—I have to disconnect/close the database by opening another, then open/connect the original database.

[raldo]

Pvd still locks the database, even if I am using the server component on my side.

I can now run MC and Firebird Maestro simultaneously as long as I use a server connection on both...

I.e. with Pvd started, a can't connect to the db neither from firebird maestro nor from my plugin.

Any suggestions?

[rick.ca]

I should have mentioned... not only was I able to connect to the server from PVD, I was able to do so simultaneously with FlySpeed SQL Query. So I doubt PVD is locking the database. Are you sure you're not having the same difficulty I had—trying to connect PVD once the database is already connected directly?

[nostra]

raldo, did you use the "Connect to server" function from the Main menu?

[raldo]

raldo, did you use the "Connect to server" function from the Main menu?

Yes, I tried that (after I realized that I need to install the beta, 0.9.9.5 beta 4).

But which string should I enter in the "Connect to Server" dialog?

I have tried the path, but then it looks as if the embedded server is still used.

localhost:<path>
<computername>:<path>

-- Both of these create an exception..

[rick.ca]

Is this the problem?

if I want to switch connection methods...I have to disconnect/close the database by opening another, then open/connect the original database.

[raldo]

I'm trying to open the database from within PVD using the "Connect to server" dialog.

I've tried many strings, the last one:
   dionysus:C:\Documents and Settings\Harald\My Documents\Personal Video Database\movies.pvd

Where dionysus is my computer's name. I've also tried "\\dionysus..."

When I use just the filename, a connect from another client (My plugin or maestro) fails. It looks as if embedded client is used by PVD because fbembed.dll cannot be deleted.

Are you using just the filename?

[rick.ca]

Connect with [computer name:|ip address:]path (i.e., computer name or ip address are optional). All three ways work for me. So I don't understand why your last attempt would not work, unless...

You haven't acknowledged the possibility I've suggested several times. If PVD is connecting to your database via Firebird embedded—because that's how it was previously loaded—you have to "disconnect" by switching to another database (or by creating a new one). Then Connect to server, entering the path to your original database.

[raldo]

Connect with [computer name:|ip address:]path (i.e., computer name or ip address are optional). All three ways work for me. So I don't understand why your last attempt would not work, unless...

You haven't acknowledged the possibility I've suggested several times. If PVD is connecting to your database via Firebird embedded—because that's how it was previously loaded—you have to "disconnect" by switching to another database (or by creating a new one). Then Connect to server, entering the path to your original database.

Ok, I forgot to tell you that  I've tried that...

[nostra]

Did you install the Firebird Server in first place?
http://www.firebirdsql.org/index.php?op=files

[rick.ca]

It looks as if embedded client is used by PVD because fbembed.dll cannot be deleted.

You may have a point. I'm able to delete that with PVD running (connected to server).

I run Firebird as a service now, but until I figured out how to use it, I ran it as an application. Doing so provided a notification tool that would allow me to see if a connection I attempted was successful. If you're not already doing that, it might help you trouble-shoot.

What version of Firebird are you using? I don't know why there would be any problem using 2.1.2, but I'm using 2.0.5—because the embedded version used by PVD is 2.0.3.

I know nothing about Maestro, but this caught my eye:

With the trial version of Firebird Maestro I was able to find the option for indicating connecting to an embedded database, and then I was able to connect just fine.

Is it possible you have Maestro configured to connect to the database via Firebird embedded, instead of the server?

[raldo]

I run Firebird as a service now, but until I figured out how to use it, I ran it as an application. Doing so provided a notification tool that would allow me to see if a connection I attempted was successful. If you're not already doing that, it might help you trouble-shoot.

What version of Firebird are you using? I don't know why there would be any problem using 2.1.2, but I'm using 2.0.5—because the embedded version used by PVD is 2.0.3.

I know nothing about Maestro, but this caught my eye:

With the trial version of Firebird Maestro I was able to find the option for indicating connecting to an embedded database, and then I was able to connect just fine.

Is it possible you have Maestro configured to connect to the database via Firebird embedded, instead of the server?

I've installed 2.1.2 and I have used Maestro to connect both as an embedded client and through the server. Ditto with my own app.

Maybe I'll try 2.0.5 tomorrow...

[raldo]

Maybe I'll try 2.0.5 tomorrow...

Yup, The older version worked. Thanks, Rick!

I've got Maestro, PVD, and my own app all connected now...

[rick.ca]

While the version may very well be important, your troubles may have had more to do with a bug in the recent update to 0.9.9.5, reported here. If your connection is working, leave it alone—the problem is it cannot be changed it using Connect to server.

[raldo]

While the version may very well be important, your troubles may have had more to do with a bug in the recent update to 0.9.9.5, reported here. If your connection is working, leave it alone—the problem is it cannot be changed it using Connect to server.

Yup. It is still not working properly...