opinions

2006-07-31 Thread Raful Mr Mitchell H
I have two database table. One has over 600 cisco devices with serial and model numbers, flash image version, and name, etc. The other has the name as well of the device as well as installed modules. The tables were generated via perl script I have. What is the most efficient way to keep these

Invalid authorization specification (SQL-28000)

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

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
Do you mean in the database? If so, both Unix IDs are using the same database ids and passwords. Peter Loo Wolters Kluwer Health (602) 381-9553 -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Monday, July 31, 2006 2:34 PM To: Loo, Peter # PHX; DBI-Users Subject:

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
Hi Rob, 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 but did for the other. $dbh = DBI-connect(dbi:ODBC:testdb, testid, testpass, { RaiseError = 1 }); Peter Loo -Original Message-

Re: Invalid authorization specification (SQL-28000)

2006-07-31 Thread Rob Biedenharn
Peter, Try changing that to: $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. -Rob Rob Biedenharn http://agileconsultingllc.com

cannot install DBD::Pg

2006-07-31 Thread LLC
Hi List; I'm trying to install DBD::Pg on a RedHat EL4 (64bit) box. I used CPAN to install DBI then I downloaded DBD::Pg and ran the make. When I run make test I get this. Any suggestions/help would be greatly appreciated... Thanks in advance $ make test PERL_DL_NONLAZY=1 /usr/bin/perl