dcroghan

Thank you both for your replies. Much appreciated. Dan

Are there any tutorials for interacting with the iOS Island sing FireMonkey? Is it even feasible? Thank you. Dan

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.

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

Thank you both!

Hello, I am looking for recommendations on how best to handle implementing Database structure changes and importing existing data within client application. Currently I use NexusDB and have for years, it is a great product. The current project I am working on requires I use Interbase. The reason I referenced NexusDB is because it has a handy tool and functions to generate the code that represents the new database schema. One can then "build and evolve", in Nexus terms, which applies the new database structure against the current (old) database and imports in all the data. It is not perfect, but it works well for the projects I had been working on. I am looking for a similar tool(s)/library that could provide the same type of functionality. It would need to be able to be used for the IBLite, IBToGO and IBServer. I recognize the multi-user access aspect of the server edition that would need to be addressed, but that's expected. Thanks for any pointers. Dan

Thank you both for your help!

Hello, Has anyone had success with a data connection to a remote Derby DB service? I would certainly consider a 3rd party library/component. I'm using D11.2 but could ever use a different version of Delphi if needed. The remote Derby engine is on a Windows 11 computer. Thank you for any help or insight.

Hello, My application uses a TAdoConnection and TAdoTable objects. Delphi 10.4.1 reports the error "Current Provider does not support necessary interface for index functionality" when I try to assign an IndexName to a tadoTable object in design mode. The tAdoConnection is currently active prior to assigning any properties to the tAdoTable. The MS SQL Server is 2019. The TAdoConnection is currently using the SQLOLEDB.1 provider. This application did not previously have issue when compiled in Delphi 2010 and using SQL Server 2005 and the SQL Native Client provider. Thanks you