connect a sql db with data link file .udl with sql authetication

Question

connect a sql db with data link file .udl with sql authetication

marcelo salgado

SSC Veteran

Points: 287
More actions
August 31, 2005 at 4:02 pm

#69633

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.-

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

CLCook SSC Enthusiast Points: 173 More actions · Answer 1

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.