distal-attribute
distal-attribute
distal-attribute
distal-attribute

Can you add DB2 support?

xxxxxx2 posted 2 years ago in General
Can you add DB2 support?
ansgar posted 2 years ago
DB2 is accessible via ODBC only, right?
xxxxxx2 posted 2 years ago
not right. RazorSQL can access to DB2 without ODBC in portable version, he contains its own driver to access DB2, which are located in the folder with the program. it would be nice if you could do the same.
ansgar posted 2 years ago
HeidiSQL uses for example libmysql.dll for accessing MySQL, and libpq.dll for PostgreSQL.

Is there a .dll available with functions to access a DB2 server?
ansgar posted 2 years ago
Honestly, I think DB2 is so old, it's not really worth so much effort developing a new driver for it.
xxxxxx2 posted 2 years ago
he use DB2 Universal Database JDBC Type-4 Driver - db2jcc.jar
Delphi can use JDBC?
DB2 not so old. Version 10.5 released 2014-12-12.
ansgar posted 2 years ago
No, Delphi's components cannot connect to JDBC sources. JDBC is for Java applications only.
dannychase2004 posted 3 months ago

Honestly, I think DB2 is so old, it's not really worth so much effort developing a new driver for it.> Honestly, I think DB2 is so old, it's not really worth so much effort developing a new driver for it.

DB2 is alive and well in IBM shops, For example, at work I interact with a whole suite of IBM products, and DB2 is part of it due to the support from IBM. The standard tooling for accessing the database includes a mix of DBVisualizer, Squirrel, and Oracle SQL Developer, depending on how hard you want to beat your head in to the wall that day!

I for one would love to see HeidiSQL have support for DB2, break the mold! It looks like IBM's DB2 Windows client does come with an ODBC driver.

dannychase2004 posted 3 months ago

not right. RazorSQL can access to DB2 without ODBC in portable version, he contains its own driver to access DB2, which are located in the folder with the program. it would be nice if you could do the same.

Hopefully it stays up to date with IBM... I'd rather just use IBM's ODBC driver so I know everything will work correctly.

Please login to leave a reply, or register at first.