Installation - How?

[markeaston]

Hi,

We are using C++ Builder XE Enterprise.

We are interested in purchasing a number of your tools. So downloaded this dbExpress driver to use with our FireBird database. But the documentation is confusing and we dont know what to do.

It says that we need to have the InterBase Client installed. We dont use InterBase - we use FireBird. So do we need to buy InterBase so that we can use your tool for FireBird?? Strange.

Under windows installation it also goes on about ... "The standard TSQLConnection component in RAD Studio 2007 and higher provides exactly the same functionality like TCRSQLConnection does. ..." ... so do we have to compile something here before we can use your driver?

Then how do we get it installed into C++ Builder?

We have not found your documentation helpful - are there some simpler instructions?

Mark

[markeaston]

One of the reasons we thought we would use your driver is that it would make our database coding easier. Is that right?

[AndreyZ]

Hello,

You don't have to buy and install InterBase, you can use dbExpress driver for InterBase to work only with Firebird. The TCRSQLConnection component is needed to overcome restrictions of dbExpress on Delphi versions earlier than RAD Studio 2007. As you are using C++Builder XE, you don't have to compile anything.
You can use our dbExpress driver for InterBase in the same way as the standard dbExpress drivers supplied by Borland. For additional information, please refer to the description of the TSQLConnection component in the help. To setup SQLConnection in order to use dbExpress driver for InterBase, you should set the TSQLConnection.ConnectionName property to "Devart InterBase" in design-time.

[AndreyZ]

dbExpress driver is an independent library that implements the common dbExpress interfaces for processing queries and stored procedures for each supported server. You can find more information about dbExpress in the Delphi help.
Using our dbExpress drivers is similar to using standard dbExpress drivers, but our drivers have higher performance, extended options for advanced behaviour, and ability of monitoring query execution.
Maybe you will be interested in using IBDAC components that are intended for working with InterBase, Firebird, and Yaffil database servers. You can find more information about IBDAC here: http://www.devart.com/ibdac

[markeaston]

Thanks for the help.

[markeaston]

Ok, I see the dbExpress entry now for DEVARTINTERBASE. But when I try to use it I get the following:

System.IO.FileNotFoundException: Could not load file or assembly 'Devart.DbxMda.DriverLoader, Version=1.0.0.5001, Culture=neutral, PublicKeyToken=09af7300eec23701' or one of its dependencies. The system cannot find the file specified.

I have exactly the same issue with your dbExpress MySQL driver.

[AndreyZ]

It seems that you are using Data Explorer. The point is that dbExpress driver for Interbase doesn't support Data Explorer of RAD Studio XE, because Data Explorer is a .NET application, and dbExpress driver for Interbase doesn't support .NET under RAD Studio XE. You can use the TSQLConnection component to connect to a Firebird database. Here is a code example:

Code: Select all

SQLConnection.ConnectionName := 'Devart InterBase';
SQLConnection.DriverName := 'DevartInterBase';
SQLConnection.GetDriverFunc := 'getSQLDriverInterBase';
SQLConnection.LibraryName := 'dbexpida40.dll';
SQLConnection.VendorLib := 'fbclient.dll';
SQLConnection.Params.Values['Database'] := 'database';
SQLConnection.Params.Values['User_Name'] := 'username';
SQLConnection.Params.Values['Password'] := 'password';
SQLConnection.LoginPrompt := false;
SQLConnection.Open;