dbExpress Connection Migration (FireDAC)
Go Up to Migrating dbExpress Applications to FireDAC
RAD Studio does not migrate dbExpress connection parameters automatically.
You need to modify the connection parameters for your application. To do so, choose the corresponding FireDAC database driver and review its parameters. To modify the drivers parameters of your application for FireDAC, use the table in dbExpress to FireDAC parameters translation.
dbExpress Driver Names and the Corresponding FireDAC Drivers
The following table lists dbExpress driver names and corresponding FireDAC driver identifiers:
| dbExpress DriverName | FireDAC DriverID | Comment |
|---|---|---|
| ASA | ASA | |
| ASE | ODBC | FireDAC does not have Adaptive Server Enterprise native driver. Use FireDAC ODBC Bridge driver instead. |
| DataSnap | DS | |
| DB2 | DB2 | |
| Firebird | FB | |
| Informix | Infx | |
| Interbase | IB | |
| MSSQL | MSSQL | |
| MySQL | MySQL | |
| ODBC | ODBC | |
| Oracle | Ora | |
| SQLite | SQLite |
dbExpress Driver Parameters and Equivalents in FireDAC
The following table lists the dBExpress driver parameters and the equivalent parameter in FireDAC.
| dbExpress Parameter | FireDAC Parameter | Comment |
|---|---|---|
| BlobSize | -- | Not applicable. FireDAC does not limit the size of a fetched BLOB value. |
| CommitRetain | -- | Use TFDConnection Commit or CommitRetaining, Rollback or RollbackRetaining methods. |
| Compressed | Compress | |
| ConnectionString | ODBCAdvanced | |
| ConnectTimeout | LoginTimeout | |
| Database | Database | |
| Decimal Separator | -- | Not applicable. FireDAC automatically detects the server side decimal separator value. |
| DriverName | DriverID | FireDAC uses different identifiers (see this table for more information). |
| DriverAssemblyLoader | -- | Not applicable. |
| DriverPackageLoader | -- | Not applicable. |
| DriverUnit | -- | Not applicable. |
| Encrypted | UseSSL | |
| ErrorResourceFile | -- | Not applicable. |
| FailIfMissing=True|False | OpenMode=<set of values> | <set of values> depends on a driver. For example, SQLite - CreateUTF8 | CreateUTF16 | ReadWrite | ReadOnly. |
| GetDriverFunc | -- | Not applicable. |
| HostName | Server | |
| IsolationLevel | -- | Use TFDConnection.TxOptions.Isolation or TFDTransaction.Options.Isolation properties to specify default transaction isolation level. See managing transactions for more information. |
| LibraryName[Xxx] | -- | Not applicable. |
| LocaleCode | -- | Not applicable. |
| Mars_Connection=True|False | MARS=Yes|No | |
| MaxBlobSize | -- | Not applicable. |
| MetaDataAssemblyLoader | -- | Not applicable. |
| MetaDataPackageLoader | -- | Not applicable. |
| Multiple Transaction | -- | Not applicable. FireDAC always supports multiple and/or nested transactions when a DBMS supports them. |
| OS Authentication=True|False | OSAuthent=Yes|No | |
| Password | Password | |
| Port | Port | |
| RoleName | RoleName | |
| RowsetSize | FetchOptions.RowsetSize | Default rowset size may be specified as a connection parameter or by assigning a value to TFDConnection.FetchOptions.RowsetSize property. |
| Prepare SQL | ResourceOptions.DirectExecute | Default SQL command preparation mode may be specified as a connection parameter or by assigning a value to TFDConnection.ResourceOptions.DirectExecute property. The "Prepare SQL" and ResourceOptions.DirectExecute values are inversed. |
| ServerCharSet | CharacterSet | |
| SQLDialect | SQLDialect | |
| Trim Char | FormatOptions.StrsTrim | Default characters trimming mode may be specified as a connection parameter or by assigning a value to TFDConnection.FormatOptions.StrsTrim property. FireDAC trims fixed char values only. |
| User_Name | User_Name | |
| VendorLib[Xxx] | -- | Use TFDPhysYyyDriverLink.VendorLib property or FDDrivers.ini. |
| WaitOnLocks | UpdateOptions.LockWait | Default lock waiting mode may be specified as a connection parameter or by assigning a value to TFDConnection.UpdateOptions.LockWait property. |