Problem solve Get help with specific problems with your technologies, process and projects.

Connecting to SQL Server using Visual Studio

SQL Server expert Eric Brown provides some helpful information on connecting to SQL Server using Visual Studio.

How can I connect to SQL Server?

You would think this would be easy to answer, but there are multiple ways to connect to SQL Server. Depending on which version of Visual Studio you're using, with different levels of complexity, Visual Studio 2003 and 2005 have made using SQL Server data much more straight forward.

Basically, there are two parts to connecting and working with SQL Server. The connection looks something like:

Dim yourdbCnn As ADODB.Connection
Set yourdbCnn = New ADODB.Connection

Dim strdbCnn As String
strdbCnn = "Provider=SQLOLEDB;Driver={SQL Server};"
strdbCnn = strCnn & "Server=YourSQLServerName;"
strdbCnn = strCnn & "Database=YourdatabaseName;"
strdbCnn = strCnn & "uid=YourUser;pswd=YourPassword;"

yourdbCnn.ConnectionString = strCnn

For additional help, check out the Microsoft center for data access technologies and this SQL Server Express resource.

Dig Deeper on SQL Server Database Modeling and Design