August 31, 2005 at 4:02 pm
Fellas: i'm trying to migrate a access db to sql server 2000 and my old connection was with a .udl file, but now my dba force me to use a secure connection. Can I use a udl file yet, o I should to change to another way ? Can you help me, He suggest me to encrypt my password or my connection string, in that case, how can do that?
thanks. Marcelo from Argentina.-
September 1, 2005 at 12:09 pm
A. It depends on what you are using to make the connection; ADO, ADO.NET, OLEDB, ODBC, etc. UDL files are a ODBC concept that are also supported by OLEDB, ADO, and ADO.NET (when the OLEDB connection classes are used). ADO.NET with the SQLServer classes do not support this.
B. If you are using Windows security on SQLServer then there are no passwords stored in the UDL file, if you need to connect with a SQLServer account, the password will be stored in plain easy to read text. Not a good idea.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy