Re: ODBC from Windows to Oracle 7 on UNIX
Date: Fri, 22 May 2009 11:07:56 +0200
Jonathan Kim wrote:
> I am very new with Oracle.
> This company has Oracle 7 on UNIX and I want to establish ODBC from
> The vendor who set up this system made themselves pretty clear that
> they don't want to help us set up ODBC.
> So, I need your help.
> One scenario I found was installing Oracle 8i client on Windows and
> connecting it to Oracle 7 on UNIX. Then set up ODBC to Oracle via the
Eh - you have a perfect client - why bother with
Microsoft Database Connections?
>> Initializing first test to use userid: scott, password: tiger >> Attempting to connect using userid: scott >> The test did not succeed. >> ORA-01017: invalid username/password; logon deniedSo - it's all OK, next ime try with a real user
> It still happens with legitimate login id and password.
What happens? The ORA-1017 is a response from Oracle! It tells you, 'Listen mate, nice try, but I'm not gonna grant you access'.
-- Regards, Frank van BortelReceived on Fri May 22 2009 - 04:07:56 CDT