Home > IT Answers > Microsoft Windows > Access SQL Server 2003 database from ISeries
Orozcojoe
0 pts.
 Access SQL Server 2003 database from ISeries
Access, AS/400, Database, DB2 Universal Database, RPG, SQL Server
Hello everyone, I have searched the web for SQL Server/ISeries connectivity and have come across some interesting options: java, JDBC etc. But they have not been very clear. I understand that it is not a simple task, but has anyone successfully accessed an SQL Server database from ISeries using SQL and Java or any other method. I would really appreciate any help with this challenge.

Software/Hardware used:
ASKED: November 8, 2005  10:51 AM
UPDATED: November 18, 2009  4:55 PM
RELATED QUESTIONS
Answer Wiki:
use upper search-for with iseries sql server search in all search400, you will find many tips, first look at "Accessing MS SQL Server database from the iSeries "
Last Wiki Answer Submitted:  November 9, 2005  1:39 am  by  JPLamontre   0 pts.
All Answer Wiki Contributors:  JPLamontre   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

The real answer ought to be to install the ODBC driver that the database vendor supplies. And since Microsoft chose to implement their own variation of a subset of DRDA and call it “ODBC”, you’d think they’d be happy to supply a driver.

Why more people don’t demand a driver from them, I can’t guess.

Tom

TomLiotta
 107,995 pts.
 

Blue Pheonix (formerly ASNA) has a terrific tool for accessing MS SQL data bases. Name is something like DataGate for MS SQL.

WoodEngineer
 5,525 pts.