SearchSQLServer
Q

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 first published in January 2006

Dig deeper on SQL Server Database Modeling and Design

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from your peers on your most technical SQL Server challenges.

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

Meet all of our SQL Server experts

View all SQL Server questions and answers

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

Search BusinessAnalytics

Search DataCenter

Search DataManagement

Search DataManagementUK

Search Oracle

Search ContentManagement

Search WindowsServer

Close