Reputation: 474
What driver does a SQL Connection object connect to a SQL Server in order to run queries?
If I have the following code:
SQLConnection cn = new SqlConnection("server=ServerName;initial catalog=CorporateNA;Integrated Security=SSPI")
cn.Open();
Is the SQL Connection object using the ODBC driver SQL Server? I can't help but feel this is a stupid question, but Google searches for the topic are coming up fruitless. We are experiencing intermittent timeout issues on applications running on a server when they connect to the SQL Server and the DBA's are asking what driver it uses to connect. I do not know how to answer them.
Upvotes: 6
Views: 5882
Reputation: 28272
If you are using System.Data.SqlClient.SqlConnection
, your driver is the .NET Framework Data Provider for SQL Server (commonly known as SqlClient) unless you specified otherwise
Upvotes: 6