RE: Invalid authorization specification (SQL-28000)

2006-08-01 Thread Reidy, Ron
No, permissions on some file at the OS level. You never make it into the DB. -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Monday, July 31, 2006 3:46 PM To: Reidy, Ron; DBI-Users Subject: RE: Invalid authorization specification (SQL-28000) Do you mean

RE: Invalid authorization specification (SQL-28000)

2006-08-01 Thread Loo, Peter # PHX
. Peter Loo -Original Message- From: Rob Biedenharn [mailto:[EMAIL PROTECTED] Sent: Monday, July 31, 2006 4:13 PM To: Loo, Peter # PHX Cc: DBI-Users Subject: Re: Invalid authorization specification (SQL-28000) Peter, Try changing that to: $dbh = DBI-connect(dbi:ODBC:testdb, testid

RE: Invalid authorization specification (SQL-28000)

2006-08-01 Thread Loo, Peter # PHX
completes. Thanks everyone. Peter Loo -Original Message- From: Loo, Peter # PHX Sent: Monday, July 31, 2006 3:24 PM To: 'Rob Biedenharn' Cc: DBI-Users Subject: RE: Invalid authorization specification (SQL-28000) Hi Rob, Thanks for the input. What I did was I hard coded the database

Re: Invalid authorization specification (SQL-28000)

2006-08-01 Thread Martin J. Evans
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) Depending on how the ODBC provider is configured, the 'testuser' may not be used (nor the supplied password

Re: Invalid authorization specification (SQL-28000)

2006-08-01 Thread Martin J. Evans
]Invalid authorization specification (SQL-28000)(DBD: db_login/SQLConnect err=-1) at /usr/local/apps/common/devl/bin/GlobalRoutines.pm line 51 How can I check what ODBC it is using? Thanks. Peter Loo Sorry, I should have said. Can you run odbconfig -j and that will return version and locations

RE: Invalid authorization specification (SQL-28000)

2006-08-01 Thread Loo, Peter # PHX
-Users Subject: Re: Invalid authorization specification (SQL-28000) Loo, Peter # PHX wrote: Hi Martin, The only way that I know that unixODBC is involved is by the indication within the error message. As soon as I create a .odbc.ini file in my home directory, the program spits out

Invalid authorization specification (SQL-28000)

2006-07-31 Thread Loo, Peter # PHX
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

RE: Invalid authorization specification (SQL-28000)

2006-07-31 Thread Reidy, Ron
Permissions on something? -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Monday, July 31, 2006 3:20 PM To: DBI-Users Subject: Invalid authorization specification (SQL-28000) Hi All, I don't know what is causing the following error, but I can successfully

RE: Invalid authorization specification (SQL-28000)

2006-07-31 Thread Loo, Peter # PHX
: RE: Invalid authorization specification (SQL-28000) Permissions on something? -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Monday, July 31, 2006 3:20 PM To: DBI-Users Subject: Invalid authorization specification (SQL-28000) Hi All, I don't know what

Re: Invalid authorization specification (SQL-28000)

2006-07-31 Thread Rob Biedenharn
]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

RE: Invalid authorization specification (SQL-28000)

2006-07-31 Thread Loo, Peter # PHX
- 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) Depending on how the ODBC provider is configured, the 'testuser' may not be used (nor the supplied password

Re: Invalid authorization specification (SQL-28000)

2006-07-31 Thread Rob Biedenharn
, 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) Depending on how the ODBC provider