Page 1 of 1
ORA-01017: invalid username/password: Logon denied
Posted: Tue Jun 17, 2008 1:38 pm
by kirankota79
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
Posted: Tue Jun 17, 2008 1:46 pm
by Krazykoolrohit
Check if the DSN name you are using actually points to the Database you want to run your SQLS from.
Posted: Tue Jun 17, 2008 2:08 pm
by kirankota79
i am not able able to run the test connection. the tns service name is correct and i am giivng the DSN of my wish
Re: ORA-01017: invalid username/password: Logon denied
Posted: Tue Jun 17, 2008 2:51 pm
by sreddy
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.
Posted: Tue Jun 17, 2008 8:00 pm
by keshav0307
if you have oracle client, then why are you doing ODBC?
Posted: Tue Jun 17, 2008 8:16 pm
by Minhajuddin
Have you added the DSN in your datasources. You can check that in:
start==>control panel==>administrative tools ==>Data sources