![]() ![]() The model begins with an ODBC application making a call to the Driver Manager through the ODBC application program interface (API). The following figure shows the components of the ODBC model. SQL syntax based on the SQL-99 specification.Ī standard way to connect to and log in to a data source.Ī standard representation for data types. The ODBC interface defines the following:Ī library of ODBC function calls that allows an application to connect to a data source, execute structured query language (SQL) statements, and retrieve results. Therefore, the application can access any data source for which a database driver exists. ![]() A database driver is a dynamic-link library that an application can invoke on demand to gain access to a particular data source. A database driver links the application to a specific data source. The application's source code does not have to be recompiled for each data source. That driver should supportĦ4-bit and hence your 64-bit SQL Server instance can access the data stored in the Oracle table.Open Database Connectivity (ODBC) provides a standard interface that allows one application to access many different data sources. Therefore, it is better to use the ODBC driver shipped by Oracle itself. Actually, it was written based on OCI7, which is no longer supported by Oracle (for a long time). "MS ODBC Driver for Oracle" has already been deprecated. Therefore, if your SQL server is a 64-bit instance, you cannot access the data via linked server. Please note that there is no 64-bit support for "MS ODBC Driver for Oracle". ![]() You may download the OracleĬlient from Oracle website. Actually, in order to use "MS ODBC Driver for Oracle", you have to install the Oracle Client first. Actually, the MS ODBC Driver for Oracle is already included in Windows and hence you do not need to download it again. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |