B4J Question ODBC Connector

[moore_it]

Hi all,

It's possible to connect to an ODBC driver with b4j ?
The ODBC driver is created via windows administrative tools.

Thanks in advice

 

[Erel]

The JDBC - ODBC bridge driver was removed in Java 8.

The ODBC driver is created via windows administrative tools.

Which database are you trying to access?

 

[moore_it]

try to access into AS400 DB via IBM client access

 

[Erel]

Seems like there is a jdbc driver available: http://www-01.ibm.com/support/docview.wss?uid=swg21398042

 

[moore_it]

Please, a little help to implement it.

How i do for work with JDBC and B4J ?

Thanks

 

[Erel]

SQL Tutorial

 

[moore_it]

Thanks EREL,

this is the solution:

download jt400.jar
add #AdditionalJar: jt400.jar
add jSQL library
define myODBC like SQl
myODBC.Initialize2("com.ibm.as400.access.jdbcClient.Main","jdbc:as400:system-name","user","password")

This is all

Thanks again

 

[moore_it]

p.s.

put jt400.jar into library of b4j application.