Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

SQL server connection

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
Varshini S
Asked:
Varshini S
  • 2
  • 2
1 Solution
 
Tony303Commented:
ODBC.

Sounds and looks like a homework question.
0
 
Varshini SAuthor Commented:
System.Data.SqlClient   is  ADO.net provider for SQL Server not ODBC... am I correct ?
0
 
Surendra NathTechnology LeadCommented:
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
 
Varshini SAuthor Commented:
For using ODBC connection , I need to use System.Data.Odbc instead of System.Data.SqlClient
in the connecting string. Am I correct ?
0
 
Surendra NathTechnology LeadCommented:
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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now