CODEWITHSUNDEEP
gojdbcdb2ibm-midrangedb2-400
finalight
finalight

Reputation: 21

AS400 querying with Golang JDBC

I tried using the ODBC driver but it says error communicating due to protocol issue on "TCPIP". Upon further checking, I realize that for AS400 I Series, it requires a license to communicate with ODBC driver. However, it's too expensive and thus I'm trying to find a way to do it with JDBC

May I know has anyone done it?

Upvotes: 0

Views: 1103

Answers (2)

Korinne Adler
Korinne Adler

Reputation: 676

Why not use ODBC with the IBM i Access ODBC driver instead of the Db2 Connect driver? The IBM i Access driver has no licensing required. There seem to be a couple Golang odbc interfaces: go-odbc and mgodbc.

See the "Optional platform-specific packages" section here for info on obtaining the driver.

Upvotes: 0

Charles
Charles

Reputation: 23783

ODBC, OLEDB, and .NET drivers are licensed as part of the base OS. There's no additional fee. Whomever owns the system you are connecting to should be able to get them to you.

JDBC drivers are available as part of the open source Jtopen toolkit

Upvotes: 3

Related Questions