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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UDL's 2
UDL Files 3
A quesion about udl file and app.config 1
Invoking UDL dialog dynamically without any physical file 1
How to Write a UDL File 3
provider is not registered 1
Cannot edit .UDL file? 2
Excel Windows Authentication to SQL Server 1

Back
Top