Re: ODBC from Windows to Oracle 7 on UNIX
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 22 May 2009 11:07:56 +0200
Message-ID: <14eca$4a166b6d$524b9d64$20139_at_cache1.tilbu1.nb.home.nl>
Jonathan Kim wrote:
> Hi,
> I am very new with Oracle.
> This company has Oracle 7 on UNIX and I want to establish ODBC from
> Windows.
> 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
> client.
Date: Fri, 22 May 2009 11:07:56 +0200
Message-ID: <14eca$4a166b6d$524b9d64$20139_at_cache1.tilbu1.nb.home.nl>
Jonathan Kim wrote:
> Hi,
> I am very new with Oracle.
> This company has Oracle 7 on UNIX and I want to establish ODBC from
> Windows.
> 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
> client.
Eh - you have a perfect client - why bother with
Microsoft Database Connections?
[snjip!]
>> 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