Microsoft OLEDB Provider for DB2 locks the user

I am using Microsoft OLEDB Provider for DB2 for populating a table on DB2 running on Linux.

With my user credential I am successfully able to connect and polulate the table but when another user tries to do the same on his machine, we found that credentials are not being transferred and once that user edit the connection manager on his machine and run the package, the credentials got locked on his name and no one else can run the same package.

I googled it for 2 weeks but could not find any solution. :(

Any one can please help me for solving this issue?


more ▼

asked Mar 10, 2011 at 09:30 AM in Default

HARDIK2286 gravatar image

1 1 1 1

(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 10, 2011 at 09:30 AM

Seen: 1007 times

Last Updated: Mar 10, 2011 at 09:30 AM