Re: idb2Connection Connection String error.

Mark

This article points to the IBM docs about "breaking changes" in the V6R1 provider, and the IBM docs show a possible work-around (point the .config file to the correct version of the provider that you want):

http://systeminetwork.com/article/whats-new-ibm-v6r1-net-provider

Craig Pelkie



----- Original Message ----- From: "Mark Walter" <mwalter@xxxxxxxxxxxxxxx>
To: "Web Enabling the AS400 / iSeries" <web400@xxxxxxxxxxxx>
Sent: Thursday, September 17, 2009 10:32 AM
Subject: Re: [WEB400] idb2Connection Connection String error.

Right.

Here's what I'm doing to try to debug this thing.

First I create the connection string just using the DataSource parameter, and it works. No exception. However, when I add UserID, it throws the exception putting showing UserID in the MessageDetail argument of the exception class. So, I put Password in front of UserID in the connection string, and it throws the exception again showing Password as the MessageDetail argument of the exception class.

Ok, so I put UserID first in the connection string, and it throws the exception, showing UserID as the MessageDetail argument of the exception class.

I'm catching the iDB2InvalidConnectionStringException explicitly.

This is getting very irritating.



Mark Walter
Business to Business Data Integration Specialist
Certified IBM System i Specialist
Paragon Consulting Services, Inc
mwalter@xxxxxxxxxxxxxxx
717-764-7909 ext. 126


-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Richard Schoen
Sent: Thursday, September 17, 2009 12:59 PM
To: web400@xxxxxxxxxxxx
Subject: Re: [WEB400] idb2Connection Connection String error.

I seem to remember an issue on the DefaultCollection with V6R1 not
working, however it sounds like you're having the reverse issue since
the problem is with V5R4.

Regards,
Richard Schoen
RJS Software Systems Inc.
"Get the information you need. Now!"
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT

------------------------------

message: 2
date: Thu, 17 Sep 2009 08:33:37 -0400
from: Mark Walter <mwalter@xxxxxxxxxxxxxxx>
subject: [WEB400] idb2Connection Connection String error.

I have an application that uses the ibm.data.db2.iseries library. When I
install the application on a computer running iSeries Access Version
6.1, which is iseries.dll version 12.0.0.0, it works fine, but when I
try to run on a computer running iSeries Access Version 5.4, which is
iSeries.dll version 10.0.0.0, I get an invalid connection string error.
The same connection string is utilized. This is the Connection String:
DataSource=myserver.paragon-csi.com;User
Id=userid;Password=pwd;DefaultCollection=MPFCUST;

Any insight would be appreciated.

Thanks,

Mark

Mark Walter
Business to Business Data Integration Specialist Certified IBM System i
Specialist Paragon Consulting Services, Inc mwalter@xxxxxxxxxxxxxxx
717-764-7909 ext. 126

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.