Re: db or file access?

2005-04-11 Thread Ing. Branislav Gerzo
Ron Savage [RS], on Sunday, April 10, 2005 at 10:23 (+1000) made these points: RS IMHO data goes in databases and files go in directories. RS Raving about speed is simply premature optimization, and hence is a design fault. ok, thanks, will store that into files, I will know in future. Is there

Re: db or file access?

2005-04-11 Thread Peter J. Holzer
On 2005-04-10 10:23:38 +1000, Ron Savage wrote: IMHO data goes in databases and files go in directories. Isn't that a bit a circular definition? If you store an image in a file, it's a file and goes in a directory. If you store it in a database, it's data. Raving about speed is simply

Installing and trying DBD::Sybase 1.05

2005-04-11 Thread Miguel Covas O'Ryan
I've just downloaded DBD::Sybase 1.05 on my personal platform Mac OS X 10.3.8. I usually end up installing tested versions on HP-UX 11.x machines. I've been using DBD:.Sybase 1.04 plus DBI-1.48 with no problems (except those created by myself) on OS X. I've been able to generate the module,

Re: db or file access?

2005-04-11 Thread Ing. Branislav Gerzo
Peter J. Holzer [PJH], on Monday, April 11, 2005 at 09:56 (+0200) wrote: PJH Consistency: Do you need to ensure consistency between this data and PJH other data? If you store data in files, then somebody can remove or PJH alter the files without updating the meta-data in the database. yes, I

Re: t/05threadclone.t fails

2005-04-11 Thread Tim Bunce
On Sun, Apr 10, 2005 at 06:13:26PM -0400, Philip M. Gollucci wrote: Tim Bunce wrote: If you, or someone, has something like valgrind handy (or any other tool that would help with malloc/threads debugging) that would be a big help. Same thing with 5.8.0, 5.8.6 both with ithreads I'm

Re: db or file access?

2005-04-11 Thread Ron Savage
On Mon, 11 Apr 2005 08:58:20 +0200, Ing. Branislav Gerzo wrote: Hi ok, thanks, will store that into files, I will know in future. Is there any web page about storing images in db vs. files ? I don't know of any particular articles discussing this, but I've seen the issues raised a number of

Re: db or file access?

2005-04-11 Thread Ron Savage
On Mon, 11 Apr 2005 09:56:21 +0200, Peter J. Holzer wrote: Hi Peter On 2005-04-10 10:23:38 +1000, Ron Savage wrote: IMHO data goes in databases and files go in directories. Isn't that a bit a circular definition? If you store an image in a file, it's a file and goes in a directory. If you

Errors while inserting into long data type

2005-04-11 Thread Mallik
Hi Friends, I am using oracle database and I have column of long data type. I insert the data into this column thru perl script. If the inserted data exceeds 4000 chars, it is giving me the following error. DBD::Oracle::st execute failed: ORA-01704: string literal too long (DBD ERROR:

Re: db or file access?

2005-04-11 Thread Ing. Branislav Gerzo
Ron Savage [RS], on Monday, April 11, 2005 at 21:06 (+1000) thoughtfully wrote the following: RS Also, I'm glad you did not take my comments as criticism of yourself. I did not RS use the word 'you' which would have implied you personally were raving. that's ok. I'd like to know both sides of

Re: db or file access?

2005-04-11 Thread Chuck Fox
Sample database code supplied with Sybase stores pics :p I'm sure someone somewhere will store them in databases. -- -- Your Friendly Neighborhood DBA, Chuck

Re: t/05threadclone.t fails

2005-04-11 Thread Philip M. Gollucci
I'm running perl -Mblib t/05thrclone.t in a loop using v5.8.6 built for i386-freebsd-thread-multi and I've had no failures yet. * Whats the uname -a you've got ? * Did you link against libc_r or libpthread. I'll retest this tonightish. Thanks!

RE: Errors while inserting into long data type

2005-04-11 Thread Ronald J Kimball
Mallik [mailto:[EMAIL PROTECTED] wrote: Hi Friends, I am using oracle database and I have column of long data type. I insert the data into this column thru perl script. If the inserted data exceeds 4000 chars, it is giving me the following error. DBD::Oracle::st execute failed:

install_driver(Sybase) failed: DBD::Sybase initialize:

2005-04-11 Thread Desai, Anand (HP-GDIC)
Help.. I have been struggling to get DBI to work on my server... Here is the code.. #! /usr/bin/perl #use strict; BEGIN { $ENV{SYBASE} = /opt/sybase11.9.2; } use DBI; print Here's a list of DBI drivers:\n; my @available_drivers = DBI-available_drivers('quiet'); my $driver; foreach $driver

Re: install_driver(Sybase) failed: DBD::Sybase initialize:

2005-04-11 Thread Chuck Fox
Anand, It appears that your environment is not correctly setup. Check that you have sourced in the SYBASE.sh located at /opt/sybase11.9.2. It appears that DBD::Sybase attempted to call ct_init in the Sybase libs and failed to find it. Check the SHLIB_PATH. Use isql to connect to verify that

Re: t/05threadclone.t fails

2005-04-11 Thread Tim Bunce
On Mon, Apr 11, 2005 at 09:28:02AM -0400, Philip M. Gollucci wrote: I'm running perl -Mblib t/05thrclone.t in a loop using v5.8.6 built for i386-freebsd-thread-multi and I've had no failures yet. * Whats the uname -a you've got ? It's 4.10-STABLE (old, I know, and destined to be radically

Re: t/05threadclone.t fails

2005-04-11 Thread Philip M. Gollucci
It's 4.10-STABLE (old, I know, and destined to be radically upgraded within a month or three). Ahah! thats before the kernel SMPng ! Thats a _BIG_ difference... I'll stress it tongiht. (FBSD 6.0-current w/ libpthread) -- END

Re: Installing and trying DBD::Sybase 1.05

2005-04-11 Thread Michael Peppler
On Mon, 2005-04-11 at 10:16, Miguel Covas O'Ryan wrote: I've just downloaded DBD::Sybase 1.05 on my personal platform Mac OS X 10.3.8. I usually end up installing tested versions on HP-UX 11.x machines. I've been using DBD:.Sybase 1.04 plus DBI-1.48 with no problems (except those

Re: install_driver(Sybase) failed: DBD::Sybase initialize:

2005-04-11 Thread Michael Peppler
On Mon, 2005-04-11 at 14:58, Desai, Anand (HP-GDIC) wrote: Help.. I have been struggling to get DBI to work on my server... Here is the code.. #! /usr/bin/perl #use strict; BEGIN { $ENV{SYBASE} = /opt/sybase11.9.2; } nstall_driver(Sybase) failed: DBD::Sybase initialize: ct_init(1100)

Re: Errors while inserting into long data type

2005-04-11 Thread Ovid
Oh, and I see you *did* send this to the DBI list. Never mind my previous comment :) Cheers, Ovid --- Mallik [EMAIL PROTECTED] wrote: Hi Friends, -- If this message is a response to a question on a mailing list, please send follow up questions to the list. Web Programming with Perl --

Re: Errors while inserting into long data type

2005-04-11 Thread Ovid
Hi Mallik, I suspect you'll get more help on a DBI list, but right off the bat, I'm wondering why it says string literal too long. Are you adding the data directly to an SQL query? In other words, are you doing something like this? INSERT INTO TABLE (name) VALUES ('$some_var'); Not only is

DBD-Oracle

2005-04-11 Thread Christian Braeuner
Dear perl dbi team, I need a windows binary for the DBD-Oracle, but it seems the esoftmatic link is invalid. Do you know any different sources or whether the esoftmatic is only temporarily unavailable? Kind Regards, Christian Braeuner

Re: db or file access?

2005-04-11 Thread Kevin Carothers
On Apr 11, 2005 12:56 AM, Peter J. Holzer [EMAIL PROTECTED] wrote: On 2005-04-10 10:23:38 +1000, Ron Savage wrote: IMHO data goes in databases and files go in directories. [--- good stuff snipped ---] RDBMs are generally optimized for lots of small data items which are organized into

RE: Accessing MS Access

2005-04-11 Thread Moreno, Javier
Ok. I have tried ADO as well with no luck. Please help! snip # Include CPAN modules for DB communication use DBI; #use DBD::ODBC; use DBD::ADO; #use Win32::OLE; # Use these pragmas to code correctly use strict; # Include custom functions require Functions.pl; # Debug $::DEBUG=1; # Connect to

Re: Accessing MS Access

2005-04-11 Thread Kevin Carothers
On Apr 11, 2005 12:35 PM, Moreno, Javier [EMAIL PROTECTED] wrote: Ok. I have tried ADO as well with no luck. Please help! snip # Include CPAN modules for DB communication use DBI; #use DBD::ODBC; use DBD::ADO; #use Win32::OLE; # Use these pragmas to code correctly use strict; #

Re: Accessing MS Access

2005-04-11 Thread amonotod
From: Kevin Carothers [EMAIL PROTECTED] Date: 2005/04/11 Mon PM 03:06:59 CDT On Apr 11, 2005 12:35 PM, Moreno, Javier [EMAIL PROTECTED] wrote: Ok. I have tried ADO as well with no luck. Please help! snip my ($path_to_mdb_file) = '\\slpmxwtstandclu\testdata$\Data_2.mdb'; Aha! You are

RE: DBD-Oracle

2005-04-11 Thread Jeff Urlwin
Please, temporarily, change ftp.esoftmatic.com to 24.249.249.7. I'm still working on resolving the DNS issues since moving ISPs and my current ISP is relatively deaf. I probably have to bit the bullett and put DNS on my server(s), which I'm not thrilled about ;) Jeff -Original

RE: Errors while inserting into long data type

2005-04-11 Thread Mallik
Hi Philip, Thanks for your reply. It worked with bind_param. I have one more question, how to set the LongReadLen parameter in a perl script? Thanks, Mallik. -Original Message- From: Philip Mikal [mailto:[EMAIL PROTECTED] Sent: Monday, April 11, 2005 11:36 PM To: 'Mallik'; [EMAIL