Solved

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

Posted on 2013-06-25
2
353 Views
Last Modified: 2013-06-25
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
Comment
Question by:25112
2 Comments
 
LVL 16

Accepted Solution

by:
Surendra Nath earned 500 total points
ID: 39275407
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
 
LVL 5

Author Comment

by:25112
ID: 39275791
thank you-
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

This is about my first experience with programming Arduino.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

758 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now