Hello,
I finally figured out what was going on or at least I think I did. It turns out that security was tightened a little bit more in our shop. The app was attempting to execute a stored procedure after log on and access to stored procedures is now limited. I guess that explains why I was able to log on but the end user could not.
Fortunately, there is an HA system available where the restrictions are not enforced (at least for now) so I redirected the app to go the HA system and now everything is working normally. This resolves the end user issue but that doesn't explain why the error at the connection was coming back as a blank string with no description at all.
In any case, thanks for the suggestions.
Antonio Mira
-----Original Message-----
From: systemidotnet-bounces@xxxxxxxxxxxx [mailto:systemidotnet-bounces@xxxxxxxxxxxx] On Behalf Of Matt Olson
Sent: Tuesday, February 12, 2013 11:59 AM
To: .net use with IBM i
Subject: Re: [SystemiDotNet] Getting an error while connecting to the iSeries...
Do you use powertech? Only thing I can think of is that something is interfering with the connection (powertech loves to do that with their exit points).
-----Original Message-----
From: Mira, Antonio [mailto:antonio.mira@xxxxxxxxxxx]
Sent: Tuesday, February 12, 2013 10:57 AM
To: .net use with IBM i
Subject: Re: [SystemiDotNet] Getting an error while connecting to the iSeries...
Yes...
She screened-shared her computer and gave me control, I ran the app on her computer and was able to log on without issues. I also ran the app on my computer and gave her access, she tried to log on but had the error. I thought that maybe she limited to one session so I had her close all open iSeries sessions that she had, then tried the app again and still got the same error.
Antonio Mira
-----Original Message-----
From: systemidotnet-bounces@xxxxxxxxxxxx [mailto:systemidotnet-bounces@xxxxxxxxxxxx] On Behalf Of Matt Olson
Sent: Tuesday, February 12, 2013 11:49 AM
To: .net use with IBM i
Subject: Re: [SystemiDotNet] Getting an error while connecting to the iSeries...
When doing the tests with one profile versus another profile was it being done on the same machine?
-----Original Message-----
From: Mira, Antonio [mailto:antonio.mira@xxxxxxxxxxx]
Sent: Tuesday, February 12, 2013 10:47 AM
To: systemidotnet@xxxxxxxxxxxx
Subject: [SystemiDotNet] Getting an error while connecting to the iSeries...
Hello,
I am running into an error while connecting to the iSeries. This is a windows-based application written in VB.NET that connects to the iSeries. The end user gets a log on screen at connection.open() as expected. She types her user profile and pwd and clicks ok. I have the application display any errors if there are any. I have the app display a message box with the error but the error is coming back blanks..
IBM.Data.DB2.iSeries.iDB2HostErrorException was caught
ErrorCode=-2147467259
Message=
MessageCode=0
MessageDetails=""
Source=IBM.Data.DB2.iSeries
SqlState=""
StackTrace:
at IBM.Data.DB2.iSeries.iDB2Connection.Open()
at XLSTestReader2.Form1.getFeeAmount() in C:\Visual Studio 2010\NSF Adjustment Processing\XLSTestReader2\Form1.vb:line 743
InnerException:
The weird thing is that I use my profile and pwd and log in fine. I compared my profile to hers and they are basically the same. I couldn't find any differences that would cause a problem at log on. She can log on to the iSeries via an emulator so her profile is not expired or disabled.
I would appreciate any suggestions or if anybody has run into this situation and has resolved it, please let me know how you did it...
Thank you in advance ...
Antonio Mira
________________________________
This E-mail and any of its attachments may contain Time Warner Cable proprietary information, which is privileged, confidential, or subject to copyright belonging to Time Warner Cable. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout.
--
This is the .net use with IBM i (SystemiDotNet) mailing list To post a message email: SystemiDotNet@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/systemidotnet
or email: SystemiDotNet-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/systemidotnet.
--
This is the .net use with IBM i (SystemiDotNet) mailing list To post a message email: SystemiDotNet@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/systemidotnet
or email: SystemiDotNet-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/systemidotnet.
--
This is the .net use with IBM i (SystemiDotNet) mailing list To post a message email: SystemiDotNet@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/systemidotnet
or email: SystemiDotNet-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/systemidotnet.
--
This is the .net use with IBM i (SystemiDotNet) mailing list To post a message email: SystemiDotNet@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/systemidotnet
or email: SystemiDotNet-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/systemidotnet.
midrange.com
