Home » RDBMS Server » Security » ORA-01005 in ORACLE 9i to ACCESS 2000
ORA-01005 in ORACLE 9i to ACCESS 2000 [message #205074] Thu, 23 November 2006 04:26 Go to next message
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
Re: ORA-01005 in ORACLE 9i to ACCESS 2000 [message #205088 is a reply to message #205074] Thu, 23 November 2006 05:03 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It means that you provided invalid password when logging on.
Re: ORA-01005 in ORACLE 9i to ACCESS 2000 [message #205090 is a reply to message #205074] Thu, 23 November 2006 05:09 Go to previous messageGo to next message
saikatermail
Messages: 20
Registered: November 2006
Location: Hyderabad
Junior Member
Which Password you are talking about? I have connected to the SQL using system/manager@ORACLE_DB. I can access the Oracle Tables but not being able to access the ACCESS Table. Is it Access Password u r talking?
Re: ORA-01005 in ORACLE 9i to ACCESS 2000 [message #205123 is a reply to message #205090] Thu, 23 November 2006 06:51 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Unfortunately, I never connected to Access, but this is Oracle has to say about error code you received:
Oracle
ORA-01005 null password given; logon denied

Cause: An invalid password was given when logging on.

Action: Provide a valid password.

Check this OraFAQ Connecting Oracle with MS Access page which describes it step by step. Perhaps you'll find a solution there.
Previous Topic: CPU Security patching and CVSS Base Score.
Next Topic: track user's select statements
Goto Forum:
  


Current Time: Thu Mar 28 10:12:19 CDT 2024