OLE DB using Library List

50 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
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
  • TG
    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
    50 pointsBadges:
    report
  • TomLiotta
    We are using SQL to access iSeries... We already knew that since you told us about using OLEDB, but what SQL? Is this your own programming? Or are you using someone else's program such as Word or Excel? A job description and library list are used by all jobs -- your problem is that you aren't setting them when your session starts so you're using the defaults from the server job. Depending on how you're invoking OLEDB, you can do it as part of the connection or you can do it through explicit programming. But you'll need to tell us how your programming works before we can suggest how it might be changed. Tom
    125,585 pointsBadges:
    report

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
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

Thanks! We'll email you when relevant content is added and updated.

Following