Hello..
I'm trying to connect to MS Access Database, but I'm facing a problem and I'm not able to solve it..
OS: Windows8 64bit
Database: Oracle 11g
Microsoft Office 2013
-----------
I've done the following configurations:
1. Configured the ODBC in system DSN
2. Edited the listener.ora as the following:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = dg4odbc)
(ORACLE_HOME = E:\OraDb11g\product\11.1.0\db_1)
(PROGRAM = dg4odbc)
)
)
3. Edited the tnsnames.ora as the following:
acctest =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Disi)(PORT = 1521))
(CONNECT_DATA = (SID = dg4odbc))
(HS=OK)
)
4. Edited the initdg4odbc.ora as the following:
HS_FDS_CONNECT_INFO = db1
HS_FDS_TRACE_LEVEL = 255
5. Created a database link (create public database link accdb using 'acctest';)
Now when I connect to system user (which has created the database link) and select from the the table in MS Access DB I get this error:
SQL> SELECT ENAME FROM EMP@ACCDB;
SELECT ENAME FROM EMP@ACCDB
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
ORA-02063: preceding 2 lines from ACCDB
And when I connect to another user (eg: scott) and select from the table I get this error:
SQL> SELECT ENAME FROM EMP@ACCDB;
SELECT ENAME FROM EMP@ACCDB
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
ORA-02063: preceding 2 lines from ACCDB
--------------------------
The following statement is working fine:
SELECT TABLE_NAME FROM ALL_TABLES@ACCDB;
TABLE_NAME
------------------------------
MSysAccessStorage
MSysACEs
MSysNameMap
MSysNavPaneGroupCategories
MSysNavPaneGroups
MSysNavPaneGroupToObjects
MSysNavPaneObjectIDs
MSysObjects
MSysQueries
MSysRelationships
EMP
-------------------------
Any help will be appreciated..
Thanks..