What Is Oledb In Sql Server

Oledb is a common wait type in sql server indicating a significant amout of wait time accumulation.

What is oledb in sql server.

Sqloledb has been deprecated for some time but is provided for backwards compatibility in modern windows operating systems as part of windows data access components. The ole db provider for sql server in mdac 2 7 mdac 2 8 and windows dac 6 0 has a dynamic property called allow native variants which as the name implies allows developers to access the sql variant in its native form as opposed to a dbtype variant. Linked server queries remote procedure calls bulk insert operations full text search and queries to external data sources for example excel all contribute to oledb wait type. Note that there is a known issue since sql server 2000 with rolled back operations through linked servers where the linked server is not sql server.

Since all other database platforms had odbc interfaces microsoft obviously had to provide one for. This interface is called msdasql microsoft ole db provider for odbc. It seems that sometimes if the remote system does not terminate the link properly the sql server connection remains open showing oledb as the wait type and the only way to solve the problem is to restart sql server. Sql server data access technologies.

This wait type indicates that an spid has made a function call to an ole db provider and is waiting for the function to return the required data. Connection strings using sqloledb for connections to sql server sql server 2000 and sql server 7 0. Ole db is part of the microsoft data access components mdac stack. The ole db driver for sql server is a stand alone data access application programming interface api used for ole db that was introduced in sql server 2005 9 x.

Oledb is an api used by sql server when retrieving data from a remote server or datasource. Both the sql server native client 10 0 ole db provider sqlncli10 and sql server ole db driver sqloledb are ole db providers shipped by microsoft. Denali is the last to include an ole db provider for sql server but support will continue for 7 years. Microsoft s release of sql server 2012 internal code.

Since sql server is 1 made by microsoft and 2 the microsoft database platform both odbc and ole db are a natural fit for it. Ole db includes not only the structured query language sql capabilities of the microsoft sponsored standard data interface open database connectivity odbc but.