Protocol name, if Alias is not specified. Also specify User_Name and Password (see Defining Connection (FireDAC) for details).ĭatabase name, if Alias is not specified. If no aliases are configured, then you should use the Protocol, Server, Port, and Database parameters. If the DB2 client software has the DB2 connection aliases configured, an application should use the Alias parameter. There are two methods of specifying the DB2 connection attributes.
drop a TFDPhysDB2DriverLink component from the "FireDAC Links" palette page,.Sudo cp -r clidriver/* /opt/ibm/clidriverĮcho > Įcho Description =IBM DB2 ODBC Driver > Įcho Driver =/opt/ibm/clidriver/lib/libdb2o.so > Įcho DontDLClose =1 > Tar -xavf ibm_data_server_driver_for_odbc_cli_linux圆4_v*.tar.* To install the IBM DB2 64-bit ODBC driver on Linux, download it and run the following commands to install it: Data source name not found and no default driver specifiedįireDAC requires the " iSERIES ACCESS ODBC DRIVER" driver to connect to DB2 AS400.įireDAC requires the unixODBC 64-bit ODBC driver manager library and the IBM DB2 64-bit ODBC driver. If the DB2 ODBC driver has not been installed properly, an exception is raised when you try to connect: Additionally, download and install the fix packs. These can be downloaded from the following locations:Īfter downloading and unpacking, run "\bin\db2oreg1 -i" to install the ODBC driver.
You can also work with other IBM database products using FireDAC ODBC or DBX Bridge drivers.įireDAC requires the " IBM DATA SERVER DRIVER for ODBC", " IBM DB2 ODBC DRIVER", or " IBM DB2 DRIVER FOR ODBC" x86 or 圆4 ODBC driver to be installed on the workstation.
The FireDAC native driver supports IBM DB2 Enterprise, Workgroup, Express, or AS/400 editions version 8 and later.
0 kommentar(er)
