Solved

SQL server connection

Posted on 2014-01-28
5
288 Views
Last Modified: 2014-01-29
I am using following connection string to communicate to my SQL server from my web server.

What connection mechanism  I am using to communicate to my server ? Please explain.


<add name="mydb" connectionString="Data Source=10.5.0.1,1433;Initial Catalog=customer;Persist Security Info=True;User ID=JOHN;Password=password" providerName="System.Data.SqlClient"/>
0
Comment
Question by:Varshini S
  • 2
  • 2
5 Comments
 
LVL 12

Expert Comment

by:Tony303
ID: 39816775
ODBC.

Sounds and looks like a homework question.
0
 

Author Comment

by:Varshini S
ID: 39816989
System.Data.SqlClient   is  ADO.net provider for SQL Server not ODBC... am I correct ?
0
 
LVL 16

Expert Comment

by:Surendra Nath
ID: 39817021
ok, the information you have provided is a connection string, not the way you are trying to connect.

you can use ODBC connection or SQL Connection with the same connection string.
0
 

Author Comment

by:Varshini S
ID: 39818385
For using ODBC connection , I need to use System.Data.Odbc instead of System.Data.SqlClient
in the connecting string. Am I correct ?
0
 
LVL 16

Accepted Solution

by:
Surendra Nath earned 500 total points
ID: 39818686
that is correct
you have to choose the provider name as ODBC.

for your information

The providerName attribute is used to set the name of the .NET Framework data provider that the DataSource control uses to connect to an underlying data source. If no provider is set, the default is the ADO.NET provider for Microsoft SQL Server.

The .NET Framework includes the following data providers:

The System.Data.SqlClient provider is the default .NET Framework Data Provider for SQL Server.
 System.Data.OleDb provider is the .NET Framework Data Provider for OLE DB.

The System.Data.Odbc provider is the .NET Framework Data Provider for ODBC.
The System.Data.OracleClient provider is the .NET Framework Data Provider for Oracle.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now