473,387 Members | 3,821 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Using incorrect password to open an OleDbConnection succeeds

Hi all,

I’m seeing some strange behaviour when using an Unmanaged OLEDB Microsoft driver (v5.0.0.919 as supplied with Host Integration Server) to access DB2 on an iSeries (V5R3) via C# code

OleDbConnection con = new OleDbConnection(connString)
con.Open();

It’s the call to the Open method that succeeds even though the password supplied in the connString parameter is incorrect. (The username is valid)

I can not reproduce on our site against our iSeries but the client can. The driver being used in both scenarios is the same version which believes me to think it’s to do with how the driver is communicating with the back-end iSeries.(maybe something to do with PTF’s and versions of software on the iSeries)

The exception I get when trying against our iSeries with an incorrect password is shown below and this is what I would have expected to see against the client iSeries

"User does not have the authority to access the host resource. SQLSTATE: HY000, SQLCODE: -257"

Any thoughts or direction greatly appreciated.

Thanks

Raj
Jan 10 '07 #1
0 1564

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Joe | last post by:
Hi All, I am new to using the Access DB and I need some help if someone is able to give it to me. What I want to do is get the names of the columns of certain tables. Not the data in the table...
2
by: Ahmet AKGUN | last post by:
Hi; I am trying to make a server that handles db connection pool. Clients use TcpChannel to make a call to this server and get one database connection (OleDbConnection) from pool. But when I...
1
by: GrantS | last post by:
I am unable to get the connection to work with using the app.config file. the connection works when I use 'in line' connection as below:...
3
by: Sangeetha Nagaraj | last post by:
Hi Pals, I am a starter to web services. I have a requirement. I want to develop a web service, which accepts userid and password from the user and checks it with the MS Access database. If the...
3
by: -xx- | last post by:
Hi, I am new to c# and just trying out c# with ms access. First problem i encountered is how do i open up ms access that has password. Here is my current codes which working fine if there is...
15
by: yzlin04 | last post by:
Hello, I'm new in vb.net. I have a problem in inserting a new row to a MS Access database table. There is no error message comes out when i run my program, but when i check my MS Access table,...
3
by: Anil Gupte | last post by:
I am using an MDB file which I have secured using the Access 2000 security wizard. When I try to open it using a VB program I get an exception saying "Cannot start your application. The wrokgroup...
0
by: calvinkwoo3000 | last post by:
My Window application run property withour link to mdb without password. Once i set security password to mdb file, the error belor come out when i click detail. Not a valid password. and detail...
9
by: Jordi Maicas | last post by:
Hello again! I've got a typical problem validating a user/pass through an access database with C#. I tried with two functions, and both tell me that the resulting string is out of context.
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.