Advertisement

07.07.2008 at 01:04PM PDT, ID: 23544578
[x]
Attachment Details

Using Library List in connection string (DB2 iseries)

Asked by weimha in AS / 400, DB2 Database

Tags:

I have a web application that uses iDB2 to connection the the AS400 (iSeries).  The connection works fine except that the library list isn't working.  

We have the following:

<add name="AS400" connectionString="DataSource=AS400; userid=TEST; password=TEST123; default collection=LIB1, LIB2; librarylist=LIB1, LIB2"/>

Only files in LIB1 are being found.  When we try to use a file in LIB2 it says file not found.  If we qualify the name in the SQL statement (LIB2.File1) then it works.

How do we use library lists?Start Free Trial
[+][-]07.07.2008 at 01:15PM PDT, ID: 21948308

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: AS / 400, DB2 Database
Tags: C#, ASP.Net, AS400, iSeries
Sign Up Now!
Solution Provided By: Kdo
Participating Experts: 3
Solution Grade: A
 
 
[+][-]07.07.2008 at 01:58PM PDT, ID: 21948618

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]07.07.2008 at 02:28PM PDT, ID: 21948834

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628