Solved

SQL server connection

Posted on 2014-01-28
5
292 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

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.
I have a large data set and a SSIS package. How can I load this file in multi threading?
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
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

776 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