Go Premium for a chance to win a PS4. Enter to Win

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

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?
0
25112
Asked:
25112
1 Solution
 
Surendra NathCommented:
the OLEDB driver is set on a deprication path... it will be depricated soon.
check the below link for more information...
http://msdn.microsoft.com/en-us/library/ms810810.aspx#bkmk_ObsoleteDataAccessTech

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
http://www.connectionstrings.com/sql-server-2005#sql-native-client-9-0-odbc-driver

if you are using the OLEDB the connection string may look like below ones
http://www.connectionstrings.com/sql-server-2005#net-framework-data-provider-for-ole-db
0
 
25112Author Commented:
thank you-
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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