Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02068: following severe error from LNK -(Prob with HS ODBC pls. help)

401812Aug 24 2003 — edited Aug 31 2003
HI Every one...

Please help me out...
Problem in d/b link using generic connectivity of oracle to connect MS Access here are the details ...

ORACLE VERSION - Oracle8i Release 8.1.7.0.0
OS - WINDOWS 2000 Service Pack 3
MSAccess 2000

I sussessfully created System DSN steps....
ODBC Data Source Administrator -> System DSN -> ADD -> (select) Microsoft Access

Driver [*.mdb] Version- 4.00.6200.00 -> ODBC Microsoft Access Setup (Data Source

Name = dbq and selected the MS Access database file. and OK -> OK
_________________________________
HS parameter file...
Location .... D:\oracle\ora81\hs\admin
Name........ initdbaccess.ora

HS_FDS_CONNECT_INFO =dbq
HS_FDS_TRACE_LEVEL =off

___________________________________

listener.ora
Location.... D:\oracle\ora81\network\ADMIN

(SID_DESC =
(SID_NAME = dbaccess)
(ORACLE_HOME = D:\oracle\ora81)
(PROGRAM = hsodbc)
)

__________________________________
TNSNames.ora
Location.... D:\oracle\ora81\network\ADMIN

DBACCESS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = dbaccess)
(HS = OK)
)
)
_____________________________________
I stop the listener and start it again.... then on sqlplus.....

SQL> connect qu3/qu3@mysys
Connected.
SQL> create database link lnk using 'DBACCESS';

Database link created.

SQL> select * from t_emp_main@lnk;
select * from t_emp_main@lnk
*
ERROR at line 1:
ORA-02068: following severe error from LNK
ORA-03114: not connected to ORACLE



Why this Error is comming.... any solution pls......
Thanks in advance....
SMG


Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 28 2003
Added on Aug 24 2003
1 comment
352 views