PPM of Storable

2004-01-21 Thread Tim Howell
Does anyone have a PPM of the most recent version of Storable? I'm having DBD::Proxy problems due to Storable binary incompatibilities... --TWH

Can DBI::Proxy servers be chained?

2004-01-21 Thread daedalus
Hi all, A quick yes or no would be appreciated before I spend much time on setting up the second proxy. If the answer is "yes", a quick example of how to modify my current dsn would be *very* appreciated. ;-) ( my $dsn = "DBI:Proxy:cipher=DES;key=$key;hostname=$hostname;port=$port;dsn=DBI:Orac

String data truncation on float fields

2004-01-21 Thread paul . boutros
Hi all, I'm getting a string truncation error on a couple of unlikely tables. The error is: DBD::ODBC::st fetchrow_arrayref failed: [Oracle][ODBC]String data, right truncat ed. (SQL-01004)(DBD: st_fetch/SQLFetch (long truncated DBI attribute LongTruncOk not set and/or LongReadLen too small) er

Re: Can't make DBD: a solution on HP-UX 11.00 with Oracle 9i

2004-01-21 Thread Tim Bunce
On Wed, Jan 21, 2004 at 06:02:29PM +0100, Joel Van Boeckel wrote: > Hi Sean, > I had a lot of problems in order to build Oracle:DBD on HP-UX. > I finally ended to a very simple solution. > - recompile perl conforming to HP requirements What do you mean by "HP requirements"? > - patch DBD::Oracle

Re: Installing DBD::mysql on MacOSX 10.3.2 (panther)

2004-01-21 Thread Paul DuBois
At 15:02 -0500 1/20/04, Eric Gorr wrote: I am having great difficulty installing DBD::mysql on MacOSX 10.3.2 Server (panther). The full build log is below. The command I used to install was: perl -MCPAN -e 'install "DBD::mysql"' I am using the recent version of mysql installed from FINK. Any id

RE: Can't make DBD: a solution on HP-UX 11.00 with Oracle 9i

2004-01-21 Thread Joel Van Boeckel
Hi Sean, I had a lot of problems in order to build Oracle:DBD on HP-UX. I finally ended to a very simple solution. - recompile perl conforming to HP requirements - patch DBD::Oracle Makefile.PL Perhaps may this information help you in fixing the solution. The final environment is : Perl

RE: Query to a MS-Access 97 database using DBD::ODBC driver

2004-01-21 Thread Jeff Urlwin
> > I have problems retrieving data from a Microsoft Access 97 > database using DBD::ODBC. Using the code > ... > $sth = $dbh->prepare("SELECT table.id,table.field FROM > table WHERE > (((table.field) Like \'${variable}*\'));"); > $sth->execute; > $sth->dump_results(); T

Query to a MS-Access 97 database using DBD::ODBC driver

2004-01-21 Thread Guenter . Buehrle
I have problems retrieving data from a Microsoft Access 97 database using DBD::ODBC. Using the code ... $sth = $dbh->prepare("SELECT table.id,table.field FROM table WHERE (((table.field) Like \'${variable}*\'));"); $sth->execute; $sth->dump_results(); ... leads to "0 r

DBD::Sybase on MacOSX/ASE 12.5.1 (was: Re: Getting DBD-Sybase to Work)

2004-01-21 Thread Michael Peppler
On Tue, 2004-01-20 at 13:58, gohaku wrote: > On Jan 16, 2004, at 11:15 AM, Michael Peppler wrote: > > > I think that by default on MacOSX this directory is > > /Applications/Sybase/System. So before running "perl Makefile.PL" I > > suggest running (assuming csh): > > > > source /Applications/Sybas

Re: Encrypting Data...

2004-01-21 Thread Peter J. Holzer
On 2004-01-20 17:08:03 -0800, Tim Howell wrote: > This question isn't strictly DBI, but I wasn't sure where to ask. Is > there a preferred way to encrypt data stored in a database? I'm > developing an application that has higher security requirements than > what I've done in the past and I want t

Re: Installing DBD::mysql on MacOSX 10.3.2 (panther)

2004-01-21 Thread Remo Sanges
Fink has the problem that it place files in the directory /sw. It contains directory /bin /lib /include etc. So Perl doesn't find needed files if you install module with defaults paths value. However also with the right installation of mysql (I downloaded the installer from apple website, it uses t

ANNOUNCE: DBIx::Admin::TableInfo V 1.00

2004-01-21 Thread Ron Savage
The pure Perl module DBIx::Admin::TableInfo V 1.00 is available immediately from CPAN, and from http://savage.net.au/Perl-modules.html. On-line docs, and a *.ppd for ActivePerl are also available from the latter site. An extract from the docs: NAME DBIx::Admin::TableInfo - A wrapper around DBI's