Open main menu
Home
Random
Recent changes
Special pages
Community portal
Preferences
About Wikipedia
Disclaimers
Incubator escapee wiki
Search
User menu
Talk
Dark mode
Contributions
Create account
Log in
Editing
Open Database Connectivity
(section)
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
===OLE DB-to-ODBC bridges=== An OLE DB-ODBC bridge consists of an [[OLE DB]] Provider which uses the services of an ODBC driver to connect to a target database. This provider translates OLE DB [[Method (computer science)|method]] calls into ODBC function calls. Programmers usually use such a bridge when a given database lacks an OLE DB provider, but is accessible through an ODBC driver. Microsoft ships one, MSDASQL.DLL, as part of the [[Microsoft Data Access Components|MDAC]] [[system component bundle]], together with other database drivers, to simplify development in COM-aware languages (e.g. [[Visual Basic]]). Third parties have also developed such, notably OpenLink Software whose 64-bit OLE DB Provider for ODBC Data Sources filled the gap when Microsoft initially deprecated this bridge for their 64-bit OS.<ref name="msdasql">''Microsoft'', "Data Access Technologies Road Map", Deprecated MDAC Components, ''Microsoft'' [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdrefodbcprovspec.asp "ADO Programmer's Guide" Appendix A: Providers, Microsoft OLE DB Provider for ODBC], retrieved July 30, 2005. {{webarchive |url=https://web.archive.org/web/20011005101137/http://msdn.microsoft.com/library/default.asp?url=%2Flibrary%2Fen-us%2Fado270%2Fhtm%2Fmdrefodbcprovspec.asp |date=2001 October 5 }}</ref> (Microsoft later relented, and 64-bit Windows starting with [[Windows Server 2008]] and [[Windows Vista SP1]] have shipped with a 64-bit version of MSDASQL.) Examples: [https://uda.openlinksw.com/oledb-odbc-st/ OpenLink OLEDB-ODBC Bridge] {{Webarchive|url=https://web.archive.org/web/20170327081146/https://uda.openlinksw.com/oledb-odbc-st/ |date=2017-03-27 }}, [https://www.progress.com/oledb/sequelink SequeLink OLEDB-ODBC Bridge].
Edit summary
(Briefly describe your changes)
By publishing changes, you agree to the
Terms of Use
, and you irrevocably agree to release your contribution under the
CC BY-SA 4.0 License
and the
GFDL
. You agree that a hyperlink or URL is sufficient attribution under the Creative Commons license.
Cancel
Editing help
(opens in new window)