Can you add DB2 support?

xxxxxx2's profile image xxxxxx2 posted 9 years ago in General Permalink
Can you add DB2 support?
ansgar's profile image ansgar posted 9 years ago Permalink
DB2 is accessible via ODBC only, right?
xxxxxx2's profile image xxxxxx2 posted 9 years ago Permalink
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's profile image ansgar posted 9 years ago Permalink
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's profile image ansgar posted 9 years ago Permalink
Honestly, I think DB2 is so old, it's not really worth so much effort developing a new driver for it.
xxxxxx2's profile image xxxxxx2 posted 9 years ago Permalink
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's profile image ansgar posted 9 years ago Permalink
No, Delphi's components cannot connect to JDBC sources. JDBC is for Java applications only.
[expired user #10728]'s profile image [expired user #10728] posted 7 years ago Permalink

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.

[expired user #10728]'s profile image [expired user #10728] posted 7 years ago Permalink

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.

[expired user #11271]'s profile image [expired user #11271] posted 6 years ago Permalink

Hi there,

there is an ODBC-Driver (and also .dll) file written by IBM. Can it be implementated?` And yes, there are a lot of Installations for DB2 (IBM AS400 e.g.)

THX, Syncmasta

exwe's profile image exwe posted 3 years ago Permalink

Hi there,

there is an ODBC-Driver (and also .dll) file written by IBM. Can it be implementated?` And yes, there are a lot of Installations for DB2 (IBM AS400 e.g.)

THX, Syncmasta

Hey Syncmasta,

did you find a solution? :-)

best regards!

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