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

• CLCook

  SSC Enthusiast

  Points: 173

  More actions

  September 1, 2005 at 12:09 pm

  #586976

  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.