Search code examples
c#sql-servermsde

Connect to SQL Server with ODBC alias

I have an MSDE installed and I have a DB for it. And on a client computer an ODBC alias (x). I want to connect to this using a .NET4 program written in C#. What connection string should I use if I have only a login name (y) and a password (z)?

Or am I to extract server and database name from the registry?

Solution

  • Try this:

    Provider=MSDASQL.1;Data Source=x

    where x is your ODBC alias. You will need to add security information to this, as per normal.