Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

OLE DB for iSeries DB2 that shows libraries

OLE DB for iSeries DB2 that shows libraries

OLE DB for iSeries DB2 that shows libraries


I realize this should go under data access but the last post there is nearly a year old and I wanted to make sure someone saw this.

I manage a crystal server for a company of about 1000. I do not have control of the "official" ODBC connections that get pushed to users and I'm tired of fighting over them. I'm spending too much time fixing users connections only to have the network guys push out something that breaks it. The network guys don't understand why I need them to be a certain way since there is nothing that they do that is affected by them. So I want to switch everything to OLE DB. SQL server databases are easy, but about 30% of the reports access an iSeries.

I was able to create an OLE DB connection for the iSeries, but I can't see the libraries. Most of my users are not going to be able to work with that. Actually, I don't want to have work with it because my only way to explore the iSeries databases is through Crystal Reports.

I'm not set on this being an OLE DB connection, what I need is an iSeries connection for crystal reports and crystal server that is not going to be messed with and changed on me where we can also see the libraries and have the files and logicals grouped... basically that looks like what our ODBC connection would look like if I had complete control of it... lol...

Thank you in advance for any suggestions, clues or recommendations.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close