iDB2 connection String permenant solution

11245 pts.
Tags:
DB2 connectivity
i series
SQL Server 2008
VB.NET
I have a DB2 connection string to our i-Series that works. "DataSource=10.10.10.10;userid=LIVEXML;password=LIVE1;DefaultCollection=DATALIB031;" We have been developing a lot of apps and web services that use this type of connection. My problem is when our i-Series software is upgraded (about every 12 months) there is a new data library. This means going back and changing all the apps and web services and re-publishing them. Is there a way to have the connection string use the library list defined in the user profile instead of specifying a library? The profile is changed by the upgrade process and would eliminate all our code changes on the VB side if we can use the LIBL. I tried setting DefaultCollection to QGPL hoping it would move to the LIBL in the profile if the file was not found in QGPL but no luck.

Software/Hardware used:
SQL Server 2008, i-Series, VB.net

Answer Wiki

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

Discuss This Question: 1  Reply

 
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
  • TomLiotta

    Is there a way to have the connection string use the library list defined in the user profile instead of specifying a library?

    For other readers, it should be noted that a library list isn't specified in a user profile. Instead, a job description object is specified as an attribute of a user profile. A job description is an object that is external to the user profile object and may be shared by many user profiles. An 'initial' library list may be specified in a job description.

    With that out of the way, the question becomes one of how to associate a connection with the library list of the connection user's associated job description.

    An old Four Hundred Guru article, Control the Library List from a SQL Server Linked Server Definition, has a very good basic discussion of some library list elements for remote database connections. Although the environment doesn't seem the same, remote database access drivers are pretty much the same.

    If the description of ways to use '*USRLIBL' in a connection string isn't helpful, post back; and more discussion can be added.

    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