Using a UDL [RESOLVED]

[Bombdrop]

HI pretty new to C# comming from a strong VB6 background and have decided to go C# rather than VB. No i have been playing around with DataAccess in C# and was trying to use a udl when using SQLCLient I could use a uDL when using OLeDb. So to cut to the chase can ione use a UDL in SQLClient as i do not like hardcoding connection strings in code.

[DevGrp]

Whats a UDL

[Bombdrop]

Universal Data Link.

Basically it a file with iethe a connection string or a connection to a DSN.

[Bombdrop]

Found this on the MSDN site. Bugger!!!

Using UDL Files
The OLE DB .NET Data Provider supports Universal Data Link (UDL) file names in its connection string. You can pass the connection string by using construction arguments to the OleDbConnection object, or you can set the connection string by using the object's ConnectionString property.

Note The SQL Server .NET Data Provider does not support UDL files in its connection string. Therefore, this approach is available to you only if you are using the OLE DB .NET Data Provider.
For the OLE DB provider, to reference a UDL file with the connection string, use "File Name=name.udl."