| ORA-01005 in ORACLE 9i to ACCESS 2000 [message #205074] |
Thu, 23 November 2006 04:26  |
saikatermail
Messages: 20
Registered: November 2006
Location: Hyderabad
|
Junior Member |
|
|
Hi,
I am getting ORA-01005 at the time follwoing SQL
"SELECT * FROM EMPLOYEE@ACCESS_DB"
1. Public Database Link : ACCESS_DB
2. System DSN of MS ACCESS : ACCESS_DSN
3. D:\ORACLE\ORA92\HS\INITHSOBDC.ORA
HS_FDS_CONNECT_INFO = ACCESS_DSN
HS_FDS_TRACE_LEVEL = OFF
4. LISTENER.ORA
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = MY_SERVER)
(PORT = 1521)
)
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC=
(SID_NAME=ORACLE_DB)
(ORACLE_HOME = D:\ORACLE\ORA92)
(PROGRAM = HSODBC)
)
)
5. TNSNAMES.ORA
ORACLE_DB.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MY_SERVER)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORACLE_DB)
)
)
ACCESS_DB.WORLD=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TEXTILE)(PORT = 1521))
)
(CONNECT_DATA = (SID = ORACLE_DB))
(HS=OK)
)
Please suggest me the solutions
Saikat
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
