Subject Embedded .vs. Full Server
Author munster77054
Hi all...

Well I have to say, ooopppsss! In a previous post I said, "Since yesterday, when I do the above, I get an error saying that the DB can't be opened because it is in use. This is the FIRST TIME this has EVER happened with FB, and it was only after upgrading to 2.5."

Well, here's mud on my face. I found out why it happened. I have the full version (2.1.3.18185) installed, and to test the embedded version (mainly for compacting the db), I put the embedded version on my application DEBUG folder. The app works fine. Then the problem happens after I compact the database, using the local (DEBUG FOLDER) copy of the server (EMBEDDED) - it's coded to force the use of the EMBEDDED server at this point... I mean the run command used "..\gbak.exe (rest of the command string)", which forces it to use the GBAK.EXE in the DEBUG FOLDER (and when installed on the user's computer, the one in he APP folder). Here is my problem.

Is there anyway, to force my program to use the embedded server, like through one of the configuration files, and not the installed server? The reason I ask this, is there is a chance that a user might have FB full installed, which might be a different version, and I don't want things to mess up on their comupter.

I noticed that if I use FB2.5 on a DB, then try to access the same database with 2.1.3.18185... version 2.1.3.18185 tells me that the on disk structure is different and can't access it.

So, I hope now that I've wiped the mud off my face, one of you kind folks can help me, and tell me how to force the use of the embedded server over the installed server.

Thanks load all...