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
of ini files. Martin -Original Message- From: Martin J. Evans [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 01, 2006 11:00 AM To: DBI-Users Subject: Re: Invalid authorization specification (SQL-28000) Loo, Peter # PHX wrote: Hi Rob, It turns out that the IDs that would fail had

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

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
Depending on how the ODBC provider is configured, the 'testuser' may not 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 that is wrong. If *that* user can still

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