I would like to use my AS/400 as an application server and SQL as a database server. Is there any driver available which gives me the connectivity for this purpose.
I'm assuming by the term SQL you meant that you would like to use SQL server from Microsoft as your database server.
I would strongly recommend you to reconsider your decision due to stability and scalability issues however if you insist :) :
1. You can use JDBC from the AS/400 using pure Java JDBC driver (there are available to all major db).
2. You can use the data joiner product from IBM (pricey !! but works).
This was first published in May 2001