dcroghan

Thank you. Let me give that a try

Installed Bruno and first attempt worked perfectly. What I wonder is (outside of using something like Wireshark) is there a way to see the request that RESTDebugger is sending? Since I know is works with other REST tools, it must be something in how RESTDebugger is preparing or sending the request. Does RESTDebugger properly prepare the BODY element? I have tried both the populating the Custom Body memo box and adding individual BODY type Parameters without success.

Thank you ALL for the responses. I will give them a try and provide updates.

Hello, I am able to prepare a Postman request that produces an expected result, which is a token. When I attempt to use the same URL/URI, Authorization parameters, Headers, Body in RESTDebugger, I receive a 400 Bad Request error. I am trying to determine what is different between how the 2 tools are preparing their respect requests. Since, both tools are on the same server, firewall should not be a factor. The Error 400 indicates to me that the request is making it to the API service. The request should be sending with Content-Type of "application/x-www-form-urlencoded". I cannot verify that this format is being sent. The request requires 3 elements in a "Body" structure that I have entered into the "Custom body" edit box. Since the format is "application/x-www-form-urlencoded", I have entered the 3 required body elements as key1=value1&key2=value2&key3=value3. I have tried a multitude of scenarios without success. The service requires Basic authentication, and I have provided the Username and Password. Is there a way for RESTDebugger to display or log the request that is being sent to the server? Thanks for any help or advice. Dan

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