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.
This was last published in February 2008

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: