Home > IT Answers > AS/400 > OLE DB using Library List
Help

Question

  Asked: Feb 20 2008   11:49 PM GMT
  Asked by: TG

OLE DB using Library List


AS/400, DB2, DB2 universal database

Hi,
Do any one use OLE DB to connect to iSeries?
Is OLE DB capable of using Library List provided by Job Description?
Because when I used it, I have to specify the library name / schema and object name.
Please advice...

Thank you

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Feb 21 2008  6:19 AM GMT  by TSCHMITZ




You should specify your goals and what kind of program you use (excel, Word, ... access).

Have you tried to simply use Client Access ODBC connection ?

If you use tools like BIRT (eclipse), data are accessible through JDBC-ODBC.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on AS/400 and Database.

Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

TG  |   Feb 22 2008  12:39AM GMT

Hi TSCHMITZ,
We are using SQL to access iSeries, to ganin access to the object we have to specify the lib and object name….
Can we do it without specifying libname, get it from libl??

Tq