Re: Invalid authorization specification (SQL-28000)

[Rob Biedenharn]

Peter,
Try changing that to:






-Rob

Rob Biedenharn          http://agileconsultingllc.com
[EMAIL PROTECTED]

On Jul 31, 2006, at 6:24 PM, Loo, Peter # PHX wrote:

$dbh = DBI->connect("dbi:ODBC:testdb", "testid", "wildlywrong", { RaiseError => 1 }); and see if the one user *still* works. That will tell you if the OS credentials are overriding the ones that you supply.

Hi Rob,


but did for the other.

$dbh = DBI->connect("dbi:ODBC:testdb", "testid", "testpass", {
RaiseError => 1 });


Peter Loo

-----Original Message-----
From: Rob Biedenharn [mailto:[EMAIL PROTECTED]
Sent: Monday, July 31, 2006 2:56 PM
To: Loo, Peter # PHX
Cc: DBI-Users
Subject: Re: Invalid authorization specification (SQL-28000)


be used (nor the supplied password) and the login credentials of the
current user are used instead.

On the user that works, try changing the 'testpassword' to something

or "driver manager" that I'm slinging around, but I ran into this
problem on Windows where there was a checkbox for whether to use "NT
Authorization" or a username/password)

-Rob

Rob Biedenharn          http://agileconsultingllc.com
[EMAIL PROTECTED]

On Jul 31, 2006, at 5:20 PM, Loo, Peter # PHX wrote:

Thanks for the input. What I did was I hard coded the database, userid and password in the connect string like so and still didn't work for one Depending on how the ODBC provider is configured, the 'testuser' may not that is "wrong". If *that* user can still successfully run the program, then you need to look at the configuration of your ODBC driver manager. (someone could probably give more accurate terminology to the "provider"

Hi All,

I don't know what is causing the following error, but I can
successfully complete the program as one user and not as another.
Logging into the same database with the same user id and password.
This is very strange.
The .profile on both ids are also the same.  Would someone know what
might be causing this?  Has someone experienced this before?

DBI connect('testdb','testuser',...) failed: [unixODBC]Invalid
authorization specification (SQL-28000)(DBD: db_login/SQLConnect
err=-1)
at /usr/local/apps/common/override/bin/GlobalRoutines.pm line 51

Peter Loo

smime.p7s
Description: S/MIME cryptographic signature