How many connections will ISeries for Windows allow simulatenously using ODBC System DSN on Windows 2000 Server?

Posted on 2006-04-06
Last Modified: 2011-08-18
We have an application running on a W2K Server that uses SQL statements to query a IBM DB2 Database on an AS/400.  I loaded ISeries for Windows Client Access from the AS/400 onto the W2K server.  Connectivity seems to work fine for one connection, but when I configure my application for multiple connections, I still can only have one simultaneous session.  I have tried finding a way to change max connections, but I think that Client Access must only support one connection.  Is there a way to configure Client Access for more than one connection (preferably 30)?  Do we need to go with another client other than ISeries for Windows?  
Question by:myjohnson23
    LVL 7

    Accepted Solution

    you should use DB2 Connect Client on Win2K server to connect to DB2/400

    see this:

    Author Comment

    I actually found that the Client Access software does provide more than one connection.  After a second reboot, I no longer have the problem of just one connection.


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
    Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now