Devart Forums

Thanks, that sorts it out. For some reason the way paths get stored/handled in Delphi must have changed.

Regards
Bruce

Hi
re-installed driver for Firebird 4.8.13 and same problem persists. The error message says
can't format message 13.98 - message file c:\windows\firebird.msg not found. Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

I am using a default Firbird 2.5 installation, exactly like I have used for years and the default admin and masterkey password combination since I was having trouble. Both userid and password are defined in the sqlconnection and it does not matter whether I require a LoginPrompt or not; I still end up with the same error.

I use Delphi Pro Berlin 10.1 with C/S data pack and have been using Devart dbExpress for years until this recent problem.

Thanks
Bruce

I had to work on a lot of other things so was not able to get back to this.

I have Delphi Professional Berlin Update 2 with the c/s addon pack so am legal to use dbExpress although in this case I am just testing locally.

I have Devart dbExpress for Interbase and Firebird installed (version 4.8.13) and have Firebird 2.5 installed on my laptop.

With all this installed, I ought to be able to start the Delphi Data Explorer, open up the DevartInterbase branch and create a new database connection. When I do this, I cannot connect to the selected database and get a "can't format message" error. None of my existing connections (from older implementations) work now.

Any suggestions?

Thanks
Bruce

Where should dbexpida40.dll be located for testing data in datamodules during programming? Iknow where to put it (with the executble files) for use with a compiled Delphi program but am having trouble during coding since moving to Delphi berlin 10.1.

Thanks
Brucec

Thanks
Bruce

Okay, I think I understand. It is not that I need to not have persistent fields but rather that I need to recreate them with the Unicode setting set to True. In this case, all fields, including ASCII ones wil be treated as widestrings.

Presumably I could edit the Delphi .dfm files as text and change all string fields (or whatever they are) to widestring (or whatever). Would this work to speed up the process as I have hundreds of tables/queries with multiple string fields.

Thanks
Bruce

Hi
thanks for the suggestion but that just does not work. When using TDB.. items in both GUI and Intraweb applications one needs to have persistent fields. That seems fundamental to most database applications. I don't understand how one can ever seriously suggest removing persistent fields for database connections, etc.

Bruce

Thanks, that works for this case but what about situations where I want Unicode. All I am doing is opening a query and linking to a TDBGrid or TDBEdit field. These should be able to handle either Unicode or non-Unicode and both could come through the same SQLconnection.

I have a program which connects to a Firebird version 2.5 database to read a VarChar field. This field happens to be defined as ASCII but that is not the issue here. When using the Embarcadero version of the DbExpress driver, I have no problem connecting to and reading the contents of the VarChar field but when I use the Devart driver (latest version 3.0, dbexpida40.dll), I get an error -

Type mismatch for field 'IDFIELD', expecting: String actual: WideString.

I have not done anything unusual, just connected to the database with a TSQLConnection, a TSQLQuery and a Tclientdataset.

I use Rad Studio 2010.

Thanks
Bruce