Alternative to UDL files for Native SQL connection

[Rob]

It seems that UDL files don't work for native SQL connections (unless
I'm missing a flag or something). Is there a way to do this?

[Nicholas Paldino [.NET/C# MVP]]

Rob,

You could always put the connection string in the config file, and read
it from there.

If you have the need to use different data providers (SqlClient, OleDb,
Oracle), then I would look into using the Data Access Block in the
Enterprise Application Blocks from Microsoft. It will allow you to abstract
providers better through the config file.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Rob" <Ro*@nospam.comwrote in message
news:nm********************************@4ax.com...

It seems that UDL files don't work for native SQL connections (unless
I'm missing a flag or something). Is there a way to do this?