Use Local ODBC Connection in .NET Application?

Hopefully this is an easy one... I'm just starting an application and I'd like to use one of the ODBC connections specified under Data Sources in the Administrative Tools section of the Control Panel in Windows.

How would I go about setting up a database connection to use those details?

Thanks, Sonny

Answers


It should be as simple as setting the connection string as:

"Dsn=DsnName; Uid=UserName;Pwd=Password;"

So in code..

OdbcConnection connection = new OdbcConnection("Dsn=DsnName; Uid=UserName;Pwd=Password;");

Need Your Help

What is the from uri= when you are defining the Camel route in xml?

java apache-camel

I have several services that I would like to add Camel routes. The examples in xml I see are like so:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.