Problem solve Get help with specific problems with your technologies, process and projects.

SQL Server Database and Java

DB2/400 and DB2 UDB expert Kent Milligan explains how to access SQL Server Database with Java.

Is there a way to access the SQL Server Database without using DB2 Integrator or WEBSPHERE Integrator? Can it be done using Java?
Yes. If your programmers have Java skills, you can use Java, but it requires a JDBC type-4 driver for SQL Server. Microsoft provides such a driver, and it can be downloaded from their Web site. Extra middleware is required because SQL Server does not fully support the open group Distributed Relational Database Architecture (DRDA) standard for remote database access and interoperability like DB2 for i5/OS.

Dig Deeper on iSeries Java programming

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.