DBI pod patch (links section)

2005-06-06 Thread Burak Gürsoy
Hello, In the DBI pod section 'Security, especially the SQL Injection attack:' the link http://www.webcohort.com/Blindfolded_SQL_Injection.pdf; must be changed to either http://www.imperva.com/application_defense_center/white_papers/blind_sql_ser ver_injection.html or

Re: DBI + XML::Twig conflict (?)

2005-06-06 Thread Wiggins d'Anconia
Please don't cross post. Peter Rabbitson wrote: I have a strange problem where a database handle is being destroyed for no apparent reason. My initial idea was to parse some xml, and translate it into a database. Deleting line after line of code I came up with this short meaningles program

RE: :ODBC on Mac OSX Server 10.3.7

2005-06-06 Thread Jeff Urlwin
[added dbi-users in case there are more people who can help there] On Jun 4, 2005, at 12:44 PM, Jeff Urlwin wrote: I grabbed the latest DBD::ODBC and DBI from CPAN to do the installs, so both are the latest versions. Did you install with iODBC both times? The same version both

problem with DBD::Informix

2005-06-06 Thread Piotr Poloczek
Hello! I'm trying to compile DBD-Informix-2005-01 ( as user root )with DBI 1.48 at HP-UX 11.00 with perl 5.8.6. I have a problem with loading shared library. The requested shared library is at the right place with correct permissions. Commands perl Makefile.PL make have correct output (without

How can I...

2005-06-06 Thread Vergara, Michael \(TEM\)
Title: How can I... Hi Everyone: I want to connect to an Oracle database and test for the existence of a table. My first thought was to SELECT COUNT(*) FROM TABLE, but DBI catches the ORA-942 error and I don't know how to catch that. It throws the error during the $dbh-execute step; how

RE: How can I...

2005-06-06 Thread Reidy, Ron
The data dictionary is your friend ... SELECT 'x' FROMall_tables WHERE table_name = UPPER(:name); - Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED] Sent: Monday, June 06, 2005 2:12 PM To:

RE: How can I...

2005-06-06 Thread Reidy, Ron
Sorry, The query should read: SELECT 'x' FROMall_tables WHERE table_name = UPPER(:name) ANDowner = UPPER(:owner); - Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Reidy, Ron Sent: Monday, June 06, 2005 2:12 PM To: Vergara, Michael (TEM);

DBD::ODBC Installations Problems Mac OSX Server

2005-06-06 Thread Christopher Pryce
I'm trying to install DBD::ODBC on a Mac 10.3.7 OS X Server with the pre-installed Perl 5.8.1. I've overwritten the pre-installed iodbc driver manager with a freshly downloaded copy of iodbc 3.52.2. I've installed the FreeTDS drivers specifying --with-iodbc to make sure that it linked

Re: How can I...

2005-06-06 Thread Peter Rabbitson
On Mon, Jun 06, 2005 at 01:11:30PM -0700, Vergara, Michael (TEM) wrote: Hi Everyone: I want to connect to an Oracle database and test for the existence of a table. My first thought was to SELECT COUNT(*) FROM TABLE, but DBI catches the ORA-942 error and I don't know how to catch that. It

Success [ was Re: :ODBC on Mac OSX Server 10.3.7]

2005-06-06 Thread Christopher Pryce
On Jun 6, 2005, at 10:26 AM, Jeff Urlwin wrote: [added dbi-users in case there are more people who can help there] On Jun 4, 2005, at 12:44 PM, Jeff Urlwin wrote: I grabbed the latest DBD::ODBC and DBI from CPAN to do the installs, so both are the latest versions. Did you install with

RE: Success [ was Re: :ODBC on Mac OSX Server 10.3.7]

2005-06-06 Thread Jeff Urlwin
On Jun 6, 2005, at 10:26 AM, Jeff Urlwin wrote: [added dbi-users in case there are more people who can help there] On Jun 4, 2005, at 12:44 PM, Jeff Urlwin wrote: I grabbed the latest DBD::ODBC and DBI from CPAN to do the installs, so both are the latest versions. Did

Re: problem with DBD::Informix

2005-06-06 Thread Jonathan Leffler
Dear Piotr, The problem is the jtypalign() and jtypmsize() are not defined. If you poke around describe.ec http://describe.ec, you'll find that there is an expectation that they will be mapped to rtypalign() and rtypmsize() -- but that only happens if ESQLC_IUSTYPES is defined, and

Re: Success [ was Re: :ODBC on Mac OSX Server 10.3.7]

2005-06-06 Thread Christopher Pryce
On Jun 6, 2005, at 6:11 PM, Jeff Urlwin wrote: I'd be gratefull (and you'd be happier the next release ;) if you diagnose why Makefile.PL detects unixODBC. I think the script is looking for $ODBCHOME/*iodbc* or $ODBCHOME/lib/*iodbc*. Is there a reason that your machine doesn't detect that?