Alternative to UDL files for Native SQL connection

  • Thread starter Thread starter Rob
  • Start date Start date
R

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?
 
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.
 
Back
Top