Q

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.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close