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.

This was last published in January 2006

Dig Deeper on SQL Server Database Modeling and Design

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.