hi i am trying to create an ODBC connection from DS server on windows 2003 to an oracle database on win XP. i keep on getting the error ORA-01017: invalid username/password: Logon denied. But with the same id and password i am able to login through sqlplus. Any suggestions here?
Thanks
ORA-01017: invalid username/password: Logon denied
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
Re: ORA-01017: invalid username/password: Logon denied
Hi Kiran
I think you are using downloaded version of Oracle 9i/10G from Oracle website. That makes TNS problems;
you have to correct the TNSname.ora File
Then you can access your UVrep and load the data.
I think you are using downloaded version of Oracle 9i/10G from Oracle website. That makes TNS problems;
you have to correct the TNSname.ora File
Then you can access your UVrep and load the data.
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Have you added the DSN in your datasources. You can check that in:
start==>control panel==>administrative tools ==>Data sources
start==>control panel==>administrative tools ==>Data sources
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>