UDL Files and Password Encryption


I have created a ".UDL" file and have set both a username and password.

When I open the .UDL file in 'Notepad' the password is in a human readable form.

Is there a way to encrypt the password so it is unreadable? or Is there some similar technology I can use to store DB connection information in a file that can encrypt the password..?

Thanks Ian  
Who is Participating?
TimCotteeConnect With a Mentor Head of Software ServicesCommented:

That is the nature of UDL files, they cannot store the password as encrypted. In order to do so you would have to manage it yourself, of course you have to remember that any decryptable password stored anywhere in a file could be decrypted (obviously if your application can decrypt it then so can anyone else given time and resources). There is really no surefire way to do this, all you can do is to make it as hard as possible to find the elements required to decrypt the password.

Tim Cottee
They even stored the windows xp serial key in the registry decrypted as DigitalProductId and thats been hacked :) as you most likely know, I mean thats prolly how magic jelly bean key finder works :)
ooppss I mean encrypted NOT Decrypted, cos obviously it has to get decrypted to be readable or to make sense !
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

ISCAuthor Commented:

Thanks for the comments...

I have decided to go down the route of creating a 'UDL' containing the password and implement the security at the file level i.e., only certain people can open the file....

Regards Ian
TimCotteeHead of Software ServicesCommented:

That is a reasonable approach, again it is not entirely secure but as nothing ever is, making it as difficult to get at as possible is the best you can hope for.

ISCAuthor Commented:

The solution is not perfect but in the time constraints I have to complete development and that it meets our audit standards this will have to do....

Thanks for your help...Ian
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.