gkobler

find some other links in the google firebird-support group See the Firebird 3 release notes. Connection strings that are only a file path will now use embedded. See https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rlsnotes30.html#rnfb30-engine-modes-protocols and https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rlsnotes30.html#rnfb30-compat-winlocal Also read https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rlsnotes30.html#rnfb30-engine

OK, there are some infos about embedded from Helen and Vlad read the PDF https://www.firebirdsql.org/en/news/embedded-server-in-firebird-3/ May that have some infos for you.

Shouldn't the client library be called embeded.dll instead of fbclient.dll? And as far as I know, the Firebird installation must be in the Project.exe directory. But I could be wrong.

This options are new in D12

have the same files, i look like there where store some information of the open files

I'm just lazy and like to leave the work to the formatter

Is there an alternative for the code formatter?

I have a MSSQL Connection via FireDAC with D12 and the newest ODBC Driver 19.3.2 The connection to my MS-SQL Server 2017 is working. Many Select Statements are running well, but when i execute an Update Statement via TFDCommand component i got the follow exception. [FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt I have no problems at my developper PC, this happens on the customer PC! does anyone have any experience with this? Thankfull for any hint. Gregor

i can't check that, because on the productivity server i can't play and on my developer PC it has no made any problems. So the server on my customer and my MS-SQL Express test enviroment must have some differences.

Native driver is obsolete i think

I looked at the task and tried some of the things described there, but none of it helped.

I only had the FDQuery open and FDCommand was then executed in the While Loop. Nothing else, as shown in the example, I only deleted the Firebird statemens, but this is a different FireDAC connection. What kind of driver is it that can't even manage an open query with an UPDATE statement at the same time?

Possible, but in the doc no more info what i should set.

I tried Yes and No, No diffenrence same exception I had V17 first, then i made some changes with D12 and i got the truble. After that i updated to V19.3.2

Meanwhile i have a workaround for my problem. I changed my code to the follow fdcAmmann.Open; TRY fdqImportData.Open; fdmtImportAmmann.Data:= fdqImportData.Data; fdqImportData.Close; fdmtImportAmmann.Open; fdmtImportAmmann.First; WHILE NOT fdmtImportAmmann.Eof DO BEGIN ... some other code to store the data to a Firebird database ... fdcUpdateAmmann.CommandText.Clear; fdcUpdateAmmann.CommandText.Add(Format('UPDATE dbo.TDexAllocationTicketOut SET ReadDT = GETDATE() WHERE IDInt = %d', [fdmtImportAmmann.FieldByName('IdInt').AsInteger])); fdcUpdateAmmann.Execute; fdmtImportAmmann.Next; END; fdmtImportAmmann.Close; FINALLY fdcAmmann.Close; END; the main changes are, first i open the FDQuery and copy the data to a FDMemTable, after that i close the FDQuery and my While loop are working with the TDMemTable dataset to with the query. So i got no exception and the UPDATE Statements is working well. Strange...

Have added the TFDMoniFlatFileClientLink component, and als added the parameter to my MSSQL connection 'MonitorBy=FlatFile' But when i open my connection, i got now the follow exception You can try to run the program with F9, but it hangs. I think FBMonitoring are buggy

Same exception 😞

Unfortunately, I do not have access to the server, which is managed by another company. I can ask if they see anything and if they can turn off MARS on the server side. I'm not sure if it could have something to do with D12. Because it used to work. But with D11.3 and older ODBC drivers. And there were also Windows updates on the PC and I don't know if there were changes on the server.

Yes i did, but i can't get a specific answer fdcAmmann.Open; TRY fdqImportData.Open; WHILE NOT fdqImportData.Eof DO BEGIN ... some other code to store the data to a Firebird database ... fdcUpdateAmmann.CommandText.Clear; fdcUpdateAmmann.CommandText.Add(Format('UPDATE dbo.TDexAllocationTicketOut SET ReadDT = GETDATE() WHERE IDInt = %d', [fdqImportData.FieldByName('IdInt').AsInteger])); fdcUpdateAmmann.Execute; <<--- here i got the exception fdqImportData.Next; END; fdqImportData.Close; FINALLY fdcAmmann.Close; END; when i remark the Execute as a comment, there no exception are raises. So the connection must be active and working. The "TFDCommand.ResourceOptions.CmdExecMode" is set to "amBlocking", I think i have no Async commands. Otherwise D12 has made some changes. I tryed "MARS=Yes" and "MARS=No", still same exception.

Does anyone have experience with Firebird 4, D11.3, FireDAC and the new data type "TimeStamp with Time Zone"? I would like to show the time zone in my field, have no idea to show it. Thanks in Advanced

Watch the RSP there are a Workaround

Made an RSP at https://quality.embarcadero.com so Embarcadero can fix it

A new version is available V1.6.1.169. Support for FB5 RC1 and HDPI. Visit our Homepage and download the Trialversion: https://fbm.gksoft.ch

It was just for the beginning, after a while they opened it for all subscription members it think

Done. https://quality.embarcadero.com/browse/RSP-43311