Delphi 12: IBLite Open error "unavailable database"

[dcroghan 0]

 

I have created a test application to perform a simple OpenOrCreate test using IBLite.  I receive this "unavailable database" message.

I receive the message when using the FireDAC Connection Editor as well.  I have included the results provided by connection manger below.  

The database file does not exist since I am attempting to do the OpenOrCreate and create the db on the fly..

 

Does this OpenOrCreate functionality work with IBLite?  

I did something nearly Identical for SQLite and it worked just fine.

 

Thanks for any help.

 

================================
Connection definition parameters
================================
User_Name=sysdba
Password=*****
OpenMode=OpenOrCreate
Database=C:\Users\Dan\Documents\ShoppingIB1.gdb
DriverID=IBLite
================================
FireDAC info
================================
Tool = RAD Studio 12
FireDAC = 29.0.50491.5718
Platform = Windows 32 bit
Defines = FireDAC_NOLOCALE_META;FireDAC_MONITOR
================================
Client info
================================
Loading driver IBLite ...
Brand = InterBase
Client version = 1405009900
Client DLL name = C:\Users\Public\Documents\Embarcadero\InterBase\redist\InterBase2020\IDE_spoof\ibtogo.dll
================================
Session info
================================
Failed to connect to DBMS !
[FireDAC][Phys][IBLite]unavailable database
 

[dcroghan 0]

Some additional info, the database is created properly when the application is executed outside of the IDE.  The problem stems from the need of IBLite to obtain exclusive access to the database.  

[Brian Evans 109]

Design time components, the database explorer and the running application all want to open the database. Only one at a time can succeed for a non-shareable file-based database.

 

I usually do most development against the client/server version of such a database so I can examine the data, develop queries etc against the live database the application is using with a tool like Database Workbench. For deployment I make the connections inactive in the IDE and bring them up in code to use the embedded database engine.