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.

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 denied
So - 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 Bortel
Received on Fri May 22 2009 - 04:07:56 CDT

Original text of this message