SQL Server is using Oledb or native client- how to find?

is there a way to check if the SQL Server 2008 R2 is currently accepting/operating on generic OLEDB drivers or Native Client 10.0 or both?
Who is Participating?
Surendra NathConnect With a Mentor Technology LeadCommented:
the OLEDB driver is set on a deprication path... it will be depricated soon.
check the below link for more information...

so, you have to use the native client for any of your new development...

Now coming to your question, whether you are using the native client or the OLEDB...
it can be figured out from the connection string you are using...

if you are using native client, the connection may look like below

if you are using the OLEDB the connection string may look like below ones
25112Author Commented:
thank you-
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.