ODBC retained several features that were removed as part of the CLI effort. ODBC was originally developed by Microsoft and Simba Technologies during the early 1990s, and became the basis for the Call Level Interface (CLI) standardized by SQL Access Group in the Unix and mainframe field. Drivers exist for all major DBMSs, many other data sources like address book systems and Microsoft Excel, and even for text or comma-separated values (CSV) files.
#Odbc excel driver driver
Any ODBC-compliant application can access any DBMS for which a driver is installed. An application that can use ODBC is referred to as "ODBC-compliant". An ODBC driver can be thought of as analogous to a printer driver or other driver, providing a standard set of functions for the application to use, and implementing DBMS-specific functionality. The application uses ODBC functions through an ODBC driver manager with which it is linked, and the driver passes the query to the DBMS. ODBC accomplishes DBMS independence by using an ODBC driver as a translation layer between the application and the DBMS. An application written using ODBC can be ported to other platforms, both on the client and server side, with few changes to the data access code. The designers of ODBC aimed to make it independent of database systems and operating systems. In computing, Open Database Connectivity ( ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS). if the symptom returns, that's what I will try right away.ODBC, standard interface for accessing database systems It is possible that "reboot" is the real solution. Right click on Local DTC and select Properties Expand Component Services - Computers - My Computer.
#Odbc excel driver windows 7
to perform Step 7, which eluded me before because the instructions didn't match the Windows 7 GUI here are the updated instructions: 7. Interesting aside: Previously, if I used a Windows XP computer to create a folder on the Windows 7 computer, and then in that folder did dbinit/dbeng11/dbisql to create a brand new V11 database, the CREATE EXISTING TABLE would work on that database, but not another database in a folder created locally.Īnyway, this cost the better part of a day, hence the long discussion.Īfter a few runs, the symptom returned, so I returned to this page. After a reboot, the CREATE EXISTING TABLE worked on both V11 databases, not just one of them. Check to verify that Connection-oriented TCP/IP exists inĮverything was already OK, except for 5b and 5d where I had to check Allow for some choices. On the Default Protocols tab, check the following:Ī. Under each button, make sure Allow was set for everything.Ħ. In the Launch and Activation Permissions section, click theĭ. Under each button, make sure Allow was set for everything.Ĭ. In the Access Permissions section, click the Edit Limitsī. On the COM Security tab, check the following:Ī. Make sure that Default Impersonation Level = Identify orĥ. Make sure that Default Authentication Level = ConnectĬ. Make sure that “Enable Distributed COM on this computer”ī. On the Default Properties tab, check the following:Ī. Right click on My Computer and select PropertiesĤ. Expand Component Services/Computers/My Computerģ. Open the DCOM Configuration utility by going to Start -Ģ. Here are the Dead Chicken steps I took to solve the problem (slightly modified from the steps listed on that page): I just had to reach a sufficiently elevated level of frustration. which of course means it was the right advice. no more sense than waving a dead chicken over the keyboard. At several points in my search I was led to this pageīut the advice seemed so off-topic that it made no sense. Of course I STFW beforehand, and 99% of the suggestions assumed that "System resource exceeded" had something to do with exceeding system resources.īut no, it has something to do with permissions.