Re: debugging a DBD::Pg connection (psql and telnet)

2002-05-01 Thread Jeffrey Baker
On Wed, May 01, 2002 at 05:32:59PM -0400, Terrence Brannon wrote: > I started postmaster via: > > ./bin/postmaster -D data -p 7000 & > > but why does a > > telnet localhost 7000 > > result in a refused connection even though > > ./bin/psql -p 7000 test postgres > > works? Your post

DBI reading blob (MSSQL image) data...

2002-05-01 Thread Bill McClintock
I'm sure this has been touched on before but can't seem to find a definitive answer... Can 'blob' or (MSSQL 'image') fields be read from the database in many passes using a smaller buffer? I have a 'file repository' in MSSQL where users will be uploading files into and then reading from the d

debugging a DBD::Pg connection (psql and telnet)

2002-05-01 Thread Terrence Brannon
I started postmaster via: ./bin/postmaster -D data -p 7000 & but why does a telnet localhost 7000 result in a refused connection even though ./bin/psql -p 7000 test postgres works? Connecting via DBD::Pg is failing (with a Connection Refused error --- same thing I get when trying t

Re: Linux/perl/Oracle connect question

2002-05-01 Thread Michael A Chase
On Wed, 01 May 2002 16:04:05 -0400 Barbara Lindsey <[EMAIL PROTECTED]> wrote: > Perl 5.00503 (site_perl 5.005) > Linux 2.2.14 > Oracle 7.4.3 > Apache, but not mod_perl > DBI.pm v.1.13 > > I am getting an error at my DBI->connect statement. > The original error in the log was 'DBI->connect fai

Linux/perl/Oracle connect question

2002-05-01 Thread Barbara Lindsey
Perl 5.00503 (site_perl 5.005) Linux 2.2.14 Oracle 7.4.3 Apache, but not mod_perl DBI.pm v.1.13 I am getting an error at my DBI->connect statement. The original error in the log was 'DBI->connect failed: ORA-12154: TNS:could not resolve service na...' Then I tried adding DBI->connect_test_per

DBD::ADO and null placeholders

2002-05-01 Thread Phil Oertel
This question has been asked before but was not answered, to my knowledge. Does DBD::ADO in any way support null insertion placeholders? The following example code illustrates the problem: my $name = ""; $sth = $dbh->prepare('INSERT INTO Staff (name) VALUES(?)'); $sth->execute($name); That work

FW: Request for assistance

2002-05-01 Thread Jason Shaw
-Original Message- From: Jason Shaw [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 10:13 AM To: [EMAIL PROTECTED] Subject: Request for assistance Hi, I am trying to hunt down an answer for the following error: I suspect that it is a missing file that needs to be copied from

Re: AnyData and Virtmaps

2002-05-01 Thread Jeff Zucker
Jeff Thies wrote: > > For example, for a table with this header: > one|two|three|four|five > > INSERT INTO a_table(two) VALUES('two entry') > > yields: > |two entry And $sth->fetchrow_arrayref on that row should yield this: [undef,'two entry',undef,undef,undef] (In other words, the "miss

Re: Apache::DBI and $dbh attributes

2002-05-01 Thread John D Groenveld
> Have fun! If you're going to do some heavy overhauling of Apache::DBI please consider whether it will allow us to more easily plugin DBD specific reauthenticate functions. http://mathforum.org/epigone/modperl/khimfoplax/001101c004f0$937a1e90$c2cf180c@azathoth Thanks, John [EMAIL PROTECTED]

Re: AnyData and Virtmaps

2002-05-01 Thread Jeff Thies
> > I'm manipulating passwords and virtmaps. DBI::AnyData is so much easier > > to write/maintain than the glob of Perl this replaces! > > Great! The more I use it, the more I like! thanks! Found one more item that may or may not be a bug. INSERT only creates fields up to the last field in

Re: Compiling DBD-Infomix-1.00.PC2 On Win2k

2002-05-01 Thread paul . barker
>>The Makefile.PL seems to go OK... so is the nmake. >>But "nmake test" gives me a shitload of errors >>And the install is OK I guess. But when I try to connect to the >>DB sometimes it works >>and sometimes it doesnt(around 90% failure.) You need to build your own Perl.

Compiling DBD-Infomix-1.00.PC2 On Win2k

2002-05-01 Thread Mike Duin
Title: Message Hi all,   I am compiling (using nmake) DBD-Informix-1.00.PC2 on Win2k but cant get it working.   I have the following versions:   IBM IIF 9.30.TC1R1 ActiveState Perl 5.6 Build 631 DBI 1.14 DBD-Infomix-1.00.PC2 IFMX Client SDK 2.70   The Makefile.PL seems to go OK... so is

RE: DBD-Oracle-1.12 make fails

2002-05-01 Thread rob . leadbeater
The Oracle client is installed otherwise how would 1.06 work, unless of course 1.12 requires additional parts of the Oracle client ? Rob -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 4:34 PM To: Rob Leadbeater; [EMAIL PROTECTED]

RE: DBD-Oracle-1.12 make fails

2002-05-01 Thread Sterin, Ilya
Well, you don't have the Oracle client installed, which you must in order to compile DBD::Oracle. You can download it from technet.oracle.com Ilya -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 5/1/02 7:16 AM Subject: DBD-Oracle-1.12 make fails Hi, I'm in the

Re: DBD::Oracle problem

2002-05-01 Thread David N Murray
Put the oracle directory where libclntsh.so is located in the LD_LIBRARY_PATH. hth, Dave On May 1, Eric Ngantchjon scribed: > How can I solve the problem below ? > Can't load > '/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle/Oracle..so' > for module DBD::Oracle: ld.so.1: /us

Re: Apache::DBI and $dbh attributes

2002-05-01 Thread Tim Bunce
On Wed, May 01, 2002 at 11:57:20AM +0800, Stas Bekman wrote: > [ CC'ing Edmund on this thread in case he is not on the dbi-users list] > > Tim Bunce wrote: > > On Tue, Apr 30, 2002 at 03:34:26PM -0400, Geoffrey Young wrote: > > > >>hi Tim and all - it's been a long time :) > >> > >>Stas and I ju

Re: AnyData and Virtmaps

2002-05-01 Thread Jeff Zucker
Jeff Thies wrote: > > I'm manipulating passwords and virtmaps. DBI::AnyData is so much easier > to write/maintain than the glob of Perl this replaces! Great! > One last question. How do I predefine column names as you have done in > Passwd.pm You have three options: 1) Define them on a per

Re: DBD::Sybase Segmentation Fault

2002-05-01 Thread Michael Peppler
On Tue, 2002-04-30 at 22:17, Alima Shihabudeen wrote: > > Hi all, > > I tried to run the following script,when it tries to locate DBD::Sybase segmentation >fault is occurring.I tried to trace the error ,it is happenning at install driver >(plese check below the output of the script). > > Even

RE: DBI, Access, and DATETIME

2002-05-01 Thread Jeff Urlwin
They correct syntax for ODBC is: {ts '-MM-DD HH:MM:SS'} Jeff > -Original Message- > From: Mark Riehl [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 30, 2002 9:36 PM > To: [EMAIL PROTECTED] > Subject: DBI, Access, and DATETIME > > > All - I'm trying to use DBI to read a MS

Re: DBD::Oracle Slow cursors

2002-05-01 Thread Tim Bunce
On Wed, May 01, 2002 at 04:58:44AM -0700, Calin Medianu wrote: > That means that I'll have to install DBD::Oracle twice > once with OCI8 once without. > > Are you planning to fix this? I'll certainly look into it when I get around to working on DBD::Oracle next. Tim.

Re: DBD::Oracle Slow cursors

2002-05-01 Thread Calin Medianu
That means that I'll have to install DBD::Oracle twice once with OCI8 once without. Are you planning to fix this? Thanks, Calin > LOBS is probably the biggest loss. > > Tim. __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness

DBD::Oracle problem

2002-05-01 Thread Eric Ngantchjon
How can I solve the problem below ? Can't load '/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle/Oracle..so' for module DBD::Oracle: ld.so.1: /usr/local/bin/perl: fatal:libclntsh.so.1.0: open failed: No such file or directory at /usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLo

DBD-Oracle-1.12 make fails

2002-05-01 Thread rob . leadbeater
Hi, I'm in the process of setting up a new server to replace our production system. Production is currently running Compaq Tru64 4.0F, with DBD-Oracle-1.06 without a hitch. The new server is Compaq Tru64 5.1A. When attempting to install DBD-Oracle-1.12, I get the following # perl Makefile

DBD::Pg and Postgresql with SSL extensions (fix)

2002-05-01 Thread Terrence Brannon
--- Begin Message --- Hi there, On Mittwoch, Mai 1, 2002, at 11:15 Uhr, Terrence Brannon wrote: > Hi Marc, > > I was wondering what the proper way to de-install the postgresql > package on your entropy.ch website was? > > The SSL support is causing problems at link time when the Perl DBI > Po