On Wed, 9 Jul 2003 17:30:31 +0100 Thomson Bob <[EMAIL PROTECTED]> wrote:
> In the otherwise excellent documentation at : > > http://search.cpan.org/author/TIMB/DBD-Oracle-1.14/Oracle.pm# > Connection_Examples_Using_DBD_Oracle > > It's not too clear how to connect to a local database with a user > which has been set-up to authenticate via the OS (alter user > USERNAME identified externally) > > i.e. Thinking, as I did, that you can do : > > my $dbh = DBI->connect('DBI:Oracle:SID','/'); > > and getting this kind of the error : > > ORA-01004: default username feature not supported; logon denied (DBD > ERROR: OCISessionBegin) > > I think an explicit example like this would help : > > my $dbh = DBI->connect('DBI:Oracle:','/'); Many systems also disable this activity for remote logins. If I understand the mechanism that allows this sort of login, you may also need to clear $ENV{TWO_TASK} and set $ENV{ORACLE_SID}. What values do you have in those environment variables when you connect()? -- Mac :}) ** I usually forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
