Re: DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

2020-06-20 Thread Scott
On 6/20/20 1:51 PM, Scott wrote: More info, this error does not occur with DBD::Oracle 1.76. DBD::Oracle 1.80 => works with 18c client,  but fails with 19c. DBD::Oracle 1.76 => works with all client versions. On 6/19/20 5:48 PM, Scott wrote: We have run into an issue when we up

Re: DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

2020-06-20 Thread Scott
More info, this error does not occur with DBD::Oracle 1.76. DBD::Oracle 1.80 => works with 18c client,  but fails with 19c. DBD::Oracle 1.76 => works with all client versions. On 6/19/20 5:48 PM, Scott wrote: We have run into an issue when we upgraded to Oracle client 19c. Some of the

DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

2020-06-19 Thread Scott
, but I wanted to see if anyone else has had the same issue. Thanks, Scott

DBD::DB2 install failure

2019-09-18 Thread Scott Stark
SQLLIB/include/sqlext.h:1865:5: error: unknown type name '__in_ecount'; did you mean 'SAL__in_ecount'? __in_ecount(cchConnStrIn) ^~~ ... and it fails to install. Am I trying to install something out of date? Thanks for any tips. Scott

Re: Generic way of fetching a list of databases

2018-11-16 Thread Scott Webster Wood via dbi-users
convert to 'rest'ful JSON? Barack-O-phobia: The fear of politicians who think (more) government is the solution to every problem. On Thursday, November 15, 2018, 9:09:44 PM EST, Daniel Kasak wrote: Hi all. I have a project that has to support pretty much every major database

Re: DBD::CSV and skip_first_line

2012-11-26 Thread Scott R. Godin
On 11/26/2012 11:56 AM, H.Merijn Brand wrote: On Mon, 26 Nov 2012 11:49:49 -0500, Scott R. Godin scot...@mhg2.com wrote: On 11/25/2012 04:16 AM, Jens Rehsack wrote: On 25.11.12 10:00, H.Merijn Brand wrote: On Fri, 23 Nov 2012 17:43:50 -0500, Scott R. Godin scot...@mhg2.com wrote: I've run

Re: DBD::CSV and skip_first_line

2012-11-26 Thread Scott R. Godin
370501125YPF2594|P1534462|2|0 620354050CRF3119|P4438944|3|1 901228431AUF5822|P5315769|1|0 969358370QPO9757|P1523687|8|0 543692286WTA5861|P5993819|1|0 591327753QVR5452|P1013462|4|0 159204117LXL0308|P5358769|8|1 352853355KYT5615|P2810873|3|1 195099617GNE7056|P1306424|6|0 -- Scott R. Godin, Senior

Trying to use perl to call oracle stored proc to return an object.

2012-05-02 Thread Stricker, Scott (IS)
) err is $DBI::errstr\n; $sth-execute(); Hoping it is something really simple. Thanks for any help E. Scott Stricker @ Work

RE: EXT :Re: Trying to use perl to call oracle stored proc to return an object.

2012-05-02 Thread Stricker, Scott (IS)
) or die bind(target) err is $DBI::errstr; # Should I specify a bind type and if so, what type? $sth-bind_param(:p_ID,$i) or die bind(ID) err is $DBI::errstr\n; Do a bind_param_inout with the OUT and a bind_param with the IN param. E. Scott Stricker 703-561-3671 -Original Message- From

Maintaining simultaneous support for two Oracle versions in DBI

2011-12-03 Thread Scott Smith
should have included? Thanks for any help, Scott Smith

DBD::ODBC fails, SQL*Plus works

2011-10-05 Thread Scott Stansbury
the connect identifier specified ( SQL-08004). Thanks for any help... Scott...

Re: :ODBC fails, SQL*Plus works

2011-10-05 Thread Scott Stansbury
? -Original Message- From: Scott Stansbury [mailto:sstansb...@aol.com] Sent: Wednesday, October 05, 2011 9:09 AM To: dbi-users@perl.org Subject: DBD::ODBC fails, SQL*Plus works Folks, I could use a tip or lead with the following issue: I have a Windows Server 2008 R2 box with Oracle

Re: :ODBC fails, SQL*Plus works

2011-10-05 Thread Scott Stansbury
specified. I added the connection parameters and credentials to the script to see if it was windows talking to the Oracle InstantClient ODBC layer that was causing the problem... Scott...

Re: :ODBC fails, SQL*Plus works

2011-10-05 Thread Scott Stansbury
for your help! Scott...

Re: DBD::ODBC fails, SQL*Plus works

2011-10-05 Thread Scott Stansbury
for taking the time to help... Scott...

Re: Problem compiling DBD::Oracle on FreeBSD with Oracle 10g Instant Client

2010-10-05 Thread Scott T. Hildreth
On Sun, 2010-10-03 at 18:45 +0200, Eric Yellin wrote: Hi, I am trying to compile DBD::Oracle that will work with Oracle 10g on FreeBSD 6.3 Eric, Are you compiling a linux Perl? It won't work with out it. I have the port emulators/linux_dist-gentoo-stage3 installed. With a

RE: Having a problem conneting to an Oracle 11gr2 RAC

2010-04-30 Thread Stricker, Scott (IS)
to XYZ-2 XYZ-10 (edc-dbserver) box E. Scott Stricker Senior Software Engineer Northrop Grumman - Information Systems - C2SD MailStop 4S02 2340 Dulles Corner Blvd. Herndon, VA 20171 703-561-3671 703-713-1601 (fax) From: John Scoles [mailto:byter...@hotmail.com] Sent: Thursday, April 29, 2010

RE: Having a problem conneting to an Oracle 11gr2 RAC

2010-04-30 Thread Stricker, Scott (IS)
. E. Scott Stricker Senior Software Engineer Northrop Grumman - Information Systems - C2SD MailStop 4S02 2340 Dulles Corner Blvd. Herndon, VA 20171 703-561-3671 703-713-1601 (fax) -Original Message- From: Stricker, Scott (IS) [mailto:scott.stric...@ngc.com] Sent

Having a problem conneting to an Oracle 11gr2 RAC

2010-04-29 Thread Stricker, Scott (IS)
=(CONNECT_DATA=(SERVICE_NAME=edc-dbserver.nais.org))(ADDRESS =(PROTOCOL=TCP)(HOST=10.166.135.110)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)( HOST=10.166.135.112)(PORT=1521))) OK (0 msec) Any help would be greatly appreciated. E. Scott Stricker Senior Software Engineer Northrop Grumman - Information Systems

Re: Looking for clever solution: Different versions of Oracle .so files within single Perl build

2009-12-15 Thread Scott Smith
you created. (Full disclosure: I wrote the RMI modules. If they break for you please email me.) Scott jeff wrote: You make an incorrect assumption :-( Not trying to fool anyone or hide my identity, just hoping for further input. If you don't want to answer, then don't

Re: Success ! Different versions of Oracle .so files within single Perl build

2009-12-15 Thread Scott Smith
Great. Glad it works for you! jeff wrote: Thank you, Scott ! In case anyone else needs this sort of setup: I wanted to share this quick dirty successful test using Scott's RMI to connect to both oracle 10 with a wallet and oracle 8 with external authentication - no user names or passwords

RE: Retrieving warnings after executing a MySQL INSERT statement

2009-08-02 Thread Saccone, Scott
? print DBI::errstr=$DBI::errstr\n : print DBI::errstr is not defined\n; print Goodbye\n; exit 0; OUTPUT: Successful do operation: INSERT INTO people VALUES (Bob,abc); DBI::errstr is not defined Goodbye -- Scott -Original Message- From: David Goodman [mailto:dtzgd...@yahoo.com] Sent

Retrieving warnings after executing a MySQL INSERT statement

2009-07-28 Thread Saccone, Scott
, Scott Scott Saccone, Ph.D. Department of Psychiatry, Box 8134 Washington University School of Medicine 660 South Euclid Avenue Saint Louis, Missouri 63110-1093 Voice: (314) 286-2581 FAX: (314) 286-2577 Email: ssacc...@wustl.edumailto:ssacc...@wustl.edu

problems compiling DBD::mysql on solaris

2009-07-08 Thread Scott T. Hildreth
(guessed ) = 0 testdb(default ) = test testhost (User's choice) = filesrv testpassword (User's choice) = tiger testsocket(default ) = testuser (User's choice) = scott To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Using

Re: DBD::ODBC make test fails - unixODBC/Easysoft/SQL Server 2008

2009-06-30 Thread Scott Stansbury
Yes. Thank you again. Best regards, Scott... On Jun 30, 2009, at 11:52 AM, Martin Evans wrote: Scott Stansbury wrote: Getting closer :) I'm trying to connect to a SQL Server 2008 instance from a CentOS5 box: unixODBC: 2.2.14 FreeTDS:0.82 Easysoft: odbc-sqlserver-1.1.26-linux

DBD::ODBC make test fails - unixODBC/Easysoft/SQL Server 2008

2009-06-26 Thread Scott Stansbury
sys + 0.27 cusr 2.17 csys = 2.72 CPU) Result: FAIL Failed 1/21 test programs. 1/445 subtests failed. make: *** [test_dynamic] Error 255 As always, thanks! Best regards, Scott...

DBD::ODBC make test fails - unixODBC/Easysoft/SQL Server 2008

2009-06-25 Thread Scott Stansbury
255 Thanks for any insight... Best regards, Scott...

Re: Announce: DBI 1.609

2009-06-12 Thread Scott T. Hildreth
On Fri, 2009-06-12 at 14:38 -0700, Greg Eldridge wrote: How long until it moves into cpan[0] install DBD ?? typo? should be 'install DBI' or 'install Bundle::DBI' Thanks, Greg On Tue, 2009-06-09 at 16:46 +0100, Tim Bunce wrote: file:

RE: unable to write from a select into outfile

2009-05-15 Thread Stricker, Scott E (IS)
that can be shed on this would be greatly appreciated. E. Scott Stricker Senior Software Engineer Northrop Grumman - Information Systems - C2SD MailStop 4S02 2340 Dulles Corner Blvd. Herndon, VA 20171 703-561-3671 703-713-1601 (fax)

RE: unable to write from a select into outfile

2009-05-15 Thread Stricker, Scott E (IS)
that I did not pick up on it right away. E. Scott Stricker Senior Software Engineer Northrop Grumman - Information Systems - C2SD MailStop 4S02 2340 Dulles Corner Blvd. Herndon, VA 20171 703-561-3671 703-713-1601 (fax) -Original Message- From: Martin Evans [mailto:martin.ev...@easysoft.com

5.8.9 eating up memory with AUTOLOAD

2009-04-01 Thread Scott T. Hildreth
compiling DBD::Oracle was the lob-plsql test failing, otherwise everything worked fine. I don't even know if Oracle is the issue here. Should I post to P5P? Thanks Scott Summary of my perl5 (revision 5 version 8

Re: 5.8.9 eating up memory with AUTOLOAD in DBD::Oracle

2009-04-01 Thread Scott T. Hildreth
Wanted to change the subject. On Wed, 2009-04-01 at 11:11 -0500, Scott T. Hildreth wrote: Hello, I'm having a strange problem. I compiled 5.8.9 on SUSE Linux Enterprise Server 10 (x86_64), installed DBI DBD::Oracle. We are running Oracle 11g on this server. Running a program

Re: 5.8.9 eating up memory with AUTOLOAD in DBD::Oracle

2009-04-01 Thread Scott T. Hildreth
On Wed, 2009-04-01 at 12:54 -0500, Scott T. Hildreth wrote: Wanted to change the subject. On Wed, 2009-04-01 at 11:11 -0500, Scott T. Hildreth wrote: Hello, I'm having a strange problem. I compiled 5.8.9 on SUSE Linux Enterprise Server 10 (x86_64), installed DBI DBD

Re: DBD::Oracle on Oracle 11g 64 bit fedora 10

2009-03-26 Thread Scott T. Hildreth
On Thu, 2009-03-26 at 06:49 -0400, John Scoles wrote: Scott T. Hildreth wrote: On Mon, 2009-01-19 at 20:26 +, Russell, Gordon wrote: Hi. I am hoping someone can look over this install info and tell me if it is all ok? I am having some worries with a new install of fedora 10

Re: DBD::Oracle on Oracle 11g 64 bit fedora 10

2009-03-26 Thread Scott T. Hildreth
On Thu, 2009-03-26 at 11:45 -0400, John Scoles wrote: Scott T. Hildreth wrote: On Thu, 2009-03-26 at 06:49 -0400, John Scoles wrote: Scott T. Hildreth wrote: On Mon, 2009-01-19 at 20:26 +, Russell, Gordon wrote: Hi. I am hoping someone can look over

Re: DBD::Oracle on Oracle 11g 64 bit fedora 10

2009-03-26 Thread Scott T. Hildreth
On Thu, 2009-03-26 at 10:48 -0500, Scott T. Hildreth wrote: On Thu, 2009-03-26 at 11:45 -0400, John Scoles wrote: Scott T. Hildreth wrote: On Thu, 2009-03-26 at 06:49 -0400, John Scoles wrote: Scott T. Hildreth wrote: On Mon, 2009-01-19 at 20:26 +, Russell, Gordon

Re: DBD::Oracle on Oracle 11g 64 bit fedora 10

2009-03-25 Thread Scott T. Hildreth
the same issue. I originally thought it was a 11g client = 10g db problem, but I can reproduce it trying to compile DBD::Oracle using a 11g db. Oracle 11.1.0.7.0 is installed on SUSE Linux Enterprise Server 10 (x86_64). Thanks, Scott. In short, it works but produces some test errors. Not sure

Re: NULL = undef, even in Perl list?

2009-03-10 Thread Scott Smith
, Scott Brian H. Oak wrote: I *think* this used to work, but recently stopped working. I have a program that is designed to work on MS SQL Server. My program prepares an array of statement handle references by repeatedly interpolating several scalar variables with placeholders: for ( 0

Re: How to iterate through database tables

2009-02-03 Thread Scott Smith
Oracle's execute immediate to effectively eval the SQL there.. Scott Dale wrote: On Tue, Feb 3, 2009 at 8:47 AM, Deviloper devilo...@slived.net wrote: Hello there! lets assume that one has a list of tables @db_tables. (For Example one per Month) Lets assume one wants to find some data

Re: Perl 5.10.0

2008-06-05 Thread Scott Ryan
on the module. On Thu, Jun 5, 2008 at 10:44 AM, Jonathan Leffler [EMAIL PROTECTED] wrote: On Thu, Jun 5, 2008 at 12:54 AM, Scott Ryan [EMAIL PROTECTED] wrote: Hi I am struggling to build the DBD-Oracle module on mandriva 2008.1. It uses perl 5.10.0 and I get the following: [EMAIL PROTECTED

Re: Recursive SQL query?

2008-04-16 Thread Scott Webster Wood
- Original Message From: Colin Wetherbee [EMAIL PROTECTED] My goal was as a time/work saving measure (from the administration perspective) to allow 'children' elements to have blank entries where the values would get inherited down from parents. That makes sense. I haven't delved

Re: Recursive SQL query? - Ah hah!

2008-04-16 Thread Scott Webster Wood
- Original Message From: Tom To: Scott Webster Wood [EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 5:17:09 PM Subject: Re: [WLUG] OT: recursive SQL? I was thinking you would do this with one table with N joins, depending on the depth you wanted to go. ID | p_ID | name | property And outer

Recursive SQL query?

2008-04-15 Thread Scott Webster Wood
I'm trying to figure out the best way to build an heirarchial categorystructure kinda like you'd find on yahoo or ebay. Basically I amcreating a number of items and I am going to tie each item via a linktable to another link table that defines the categories and subcategories. Sample:

Re: Recursive SQL query?

2008-04-15 Thread Scott Webster Wood
You shouldn't really need to go recursing through a data tree to come up with all the parts of a single fact. Well that is unless you are wanting to inherit data from linked elements further up a link list without re-posting redundant information. Then, instead of storing property

Re: DBD::Oracle - execute_array core dumps intermittently [SOLVED]

2008-03-13 Thread Scott T. Hildreth
On Fri, 2008-03-07 at 16:36 -0600, Scott T. Hildreth wrote: This seems to be a threading error with the linux kernel version. I am running this process on newer kernels (2.6.22.x) and the error never occurs. We also are experiencing a lot the Futex WAIT issues with Oracle and the 2.6.20

Re: DBD::Oracle - execute_array core dumps intermittently

2008-03-07 Thread Scott T. Hildreth
! Thanks STH On Wed, 2008-03-05 at 15:21 -0600, Scott T. Hildreth wrote: I am not sure how to describe this, my co-worker will run his process and get a core dump (I pasted the back trace below) and then run the process again with no core

Re: DBD::Oracle - execute_array core dumps intermittently

2008-03-07 Thread Scott T. Hildreth
-07 at 11:25 -0600, Scott T. Hildreth wrote: Should have posted to users not dev. This is really a bizarre problem. I can get it to fail about every fifth iteration otherwise the process works. I ran it from another server connect to the same database and it will intermittently fail. I run

Re: Oracle procedure raises exception but looks to be successful from DBI

2008-01-25 Thread Scott T. Hildreth
Not that I am offering you a solution, but with Oracle I have found the error messages are sometimes misleading. For example I was helping a co-worker with code. He wanted to call a stored procedure, so I sent him some example code that I had which called a function. The function I was

Question that may not have an answer

2007-09-17 Thread Scott Mohnkern
recall talking to someone about perl having an internal database file where you could store the data in a file, and access it relatively easily, without having to set up an interface to an external database server. Or am I completely wrong, and there isn't such a thing? Scott Mohnkern

Looking for a good explanation of select function in perl dbi

2007-09-17 Thread Scott Mohnkern
://souptonuts.sourceforge.net/readme_sqlite_tutorial.html But it kind of lost me. Scott Mohnkern

Bundle::DBI Failure

2007-08-01 Thread Scott T. Hildreth
, rerun perl Makefile.PL make make test, everything is okay. Has anyone else had this occur? Thanks. -- Scott T. Hildreth [EMAIL PROTECTED]

Re: float bug? perl 5.8, DBI and oracle 10.2.0

2007-07-19 Thread Scott T. Hildreth
: 1.54 DBD::Sponge : 12.008696 DBD::Proxy : 0.2004 DBD::Oracle : 1.19 Oracle 9.2.0.1.0 bin: 0011100010101001011010010001101001110101110011010001 connecting bin: 0011100010101001011010010001101001110101110011010001 -- Scott T. Hildreth

Re: float bug? perl 5.8, DBI and oracle 10.2.0

2007-07-19 Thread Scott T. Hildreth
On Thu, 2007-07-19 at 09:36 -0500, Scott T. Hildreth wrote: On Thu, 2007-07-19 at 09:42 +0200, Erwan Lemonnier wrote: Hi Tim! Ah, now it's getting interesting! :) So I thought :) Are the two versions of DBD::Oracle built against the same Oracle version/installation

Error building DBD-ODBC on HPUX

2007-06-25 Thread Webber, Scott
I'm having trouble building the DBD-ODBC driver on our HPUX server. Below is the log of me running: make realclean perl Makefile.PL make Note: unixODBC is version 2.2.12 that I just built today. I have successfully created a connection with isql.

Re: perl pad.c Assertion !((sv)-sv_flags 0x00010000) failed

2007-06-22 Thread Peter Scott
? $ ./perl -wle '$q = shift; sub foo { my $x if $q; print $x // $]; \ $x = 42 } foo; $q++; foo' 0 5.009005 42 It looks like it, no? -- Peter Scott

Re: Duplicate table structure

2007-06-08 Thread Peter Scott
On Thu, 07 Jun 2007 08:47:00 +0200, Dr.Ruud wrote: Peter Scott schreef: Is there a simple way to create a new table with the same structure as a given one in a *different* database? That means the CREATE TABLE foo AS SELECT * FROM bar WHERE 1=2 method won't work. I'd need to have two

Re: Proposal for new $h-{ReadOnly} attribute

2007-05-04 Thread Scott Smith
since your set trans.. statement with each query, and might result in a snapshot too old error. I don't know if/how other databases implement this feature, and give it such a possibly misleading name. Does anyone else? Scott Smith Tim Bunce wrote: I've just added this to the DBI docs

Re: Proposal for new $h-{ReadOnly} attribute

2007-05-04 Thread Scott Smith
Tim Bunce wrote: On Fri, May 04, 2007 at 08:15:53AM -0500, Scott Smith wrote: Doing set transaction read only on Oracle has additional side-effects besides making the connection unable to write: it switches the read consistency level from per-statement (the default) to per-transaction

Re: environment variable

2007-01-19 Thread Scott Smith
general shell session. i.e. LD_PRELOAD=/usr/lib/special_old_library.so /usr/bin/oldprogram Scott Smith Genome Sequencing Center

Just In case you missed it...

2007-01-18 Thread Scott T. Hildreth
Josh Mcadams of PerlCast has posted the podcast of his interview with Tim at last summer's Oscon. http://www.perlcast.com/audio/Perlcast_Interview_038.mp3

DBD::Proxy - getting unitialized error for $numFields

2007-01-18 Thread Scott T. Hildreth
. -- Scott T. Hildreth [EMAIL PROTECTED]

MySQL upgrade caused Perl coredumps...

2006-11-04 Thread NIPP, SCOTT V \(SBCSI\)
/5.8.7/PA-RISC2.0 /opt/perl/lib/site_perl/5.8.7 /opt/perl/lib/site_perl . Scott Nipp Sr. Systems Analyst ATT Unix Administration (214) 858-1289 For non-emergency HP UNIX work /support requests please open

RE: MySQL upgrade caused Perl coredumps...

2006-11-04 Thread NIPP, SCOTT V \(SBCSI\)
, November 04, 2006 3:54 AM To: dbi-users@perl.org Subject: Re: MySQL upgrade caused Perl coredumps... At 10:35 PM -0600 11/3/06, NIPP, SCOTT V \(SBCSI\) wrote: I recently upgraded MySQL to version 5.0.4. After the upgrade, several of my Perl scripts that access the MySQL database began

RE: MySQL upgrade caused Perl coredumps...

2006-11-04 Thread NIPP, SCOTT V \(SBCSI\)
Judging by this I am already running the latest DBD::MySQL, though I am about 5 versions behind on the DBI module. I hope all of this helps. -Original Message- From: NIPP, SCOTT V (SBCSI) Sent: Saturday, November 04, 2006 12:02 PM To: 'Darren Duncan'; dbi-users@perl.org Subject: RE: MySQL

List tables in MS Access

2006-09-11 Thread Berthold, Scott
How can I list all of the table names in an access database? Thanks, Scott Berthold

RE: switching perl version

2006-09-08 Thread NIPP, SCOTT V \(SBCSI\)
I would definitely look to Oracle rather than Perl as your culprit. I don't have anything to back this up, just a suspicion. -Original Message- From: Oscar Gomez [mailto:[EMAIL PROTECTED] Sent: Friday, September 08, 2006 10:04 AM To: dbi-users@perl.org Subject: switching perl

Re: code needed

2006-09-04 Thread Scott T. Hildreth
://learn.perl.org/first-response -- Scott T. Hildreth [EMAIL PROTECTED]

Re: DBI/DBD::DB2

2006-06-24 Thread Dan Scott
On 24/06/06, Jonathan Leffler [EMAIL PROTECTED] wrote: On 6/23/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: snip If you have a pre-compiled module, then I think your problem is the absence of DB2 Connect (IIRC) or its equivalent. snip The basic connectivity requirement for DBD::DB2 on

Re: DBD::DB2 execute and finish problem

2006-06-09 Thread Dan Scott
WAG here: will the DBD::DB2 driver implicitly finish the resources if you try calling $sth-fetchrow_array() again? I don't know if DBD::DB2 can know whether there are more rows left in the result set until you try fetching the next row, ergo it keeps the statement handle active. Dan On

Re: DBD::DB2 where to get a client library

2006-06-01 Thread Dan Scott
Hi Martin: You'll need the Application Development Client, which is a free download from http://ibm.com/db2/udb/support/downloadv8.html. The clients are installed as RPMs on Linux using the db2setup program (part of the client); you might want to check out the DB2 HOWTO

RE: Oracle connect hangs forever

2006-04-25 Thread Scott T. Hildreth
-- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Scott T. Hildreth [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 2:28 PM To: dbi-users@perl.org Subject: Oracle connect hangs forever I plan on using Sys::SigAction to wrap an alarm around the connect

Re: DBD:Oracle

2006-04-11 Thread Scott T. Hildreth
. Thank You. -- Scott T. Hildreth [EMAIL PROTECTED]

Re: DB2.pm for Perl 5.8 needed

2006-03-31 Thread Dan Scott
This is a nice thought, but the latest release of DBD::DB2 is actually 0.78 (released a long time ago), but ActiveState wasn't interested in updating their version of the package because DBD::DB2 prereqs the DB2 Runtime Client. Apparently ActiveState has made it a policy to avoid offering

Re: Upgrade.. DBI

2006-03-29 Thread Scott T. Hildreth
) for 2¢/min or less. -- Scott T. Hildreth [EMAIL PROTECTED]

Re: Re: Upgrade.. DBI

2006-03-29 Thread Scott T. Hildreth
some posts to dbi-users. -- Scott T. Hildreth [EMAIL PROTECTED]

Zip Codes, Long/Lat and LAMP?

2006-02-26 Thread Scott Webster Wood
OK, I think I asked something along these lines before, but I am actually starting to code so I wanted to revise the question(s) a bit. I am looking for a good way to keep an up-to-date database (or perhaps use an XML-RPC/SOAP based service) to translate back-and-forth between information such as

Re: Spreadsheet::WriteExcel

2006-02-24 Thread Scott T. Hildreth
at this page for all kinds of perl lists, http://lists.cpan.org/ ...I would also suggest using www.perlmonks.org , that is a good place to get help. - Relax. Yahoo! Mail virus scanning helps detect nasty viruses! -- Scott

Re: Strange error when doing insert into DB

2006-02-20 Thread Scott T. Hildreth
://lists.cpan.org/showlist.cgi?name=dbi-users list .. Regards, -Hemlata Lalwani - Original Message - From: Scott T. Hildreth [EMAIL PROTECTED] To: Hemlata Lalwani [EMAIL PROTECTED] Cc: dbi-users@perl.org Sent: Monday, February 20, 2006 8:59 PM Subject: RE: Strange error when

Re: need DBD-DB2.ppd, DBI.ppd from www.esoftmatic.com, but server is unreachable.

2006-01-31 Thread Dan Scott
Seems to be working now for me: http://ftp.esoftmatic.com/outgoing/DBI/ Dan On 31-Jan-2006 10:09:34 CET, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello, I need DBI and DBD-DB2 packages for Activeperl, but esoftmatic server is unreachable. Can anybody help me with this problem or send me

Re: [Fwd: DBD::AnyData dbish]

2006-01-09 Thread Scott T. Hildreth
On Fri, 2006-01-06 at 10:17 -0800, Jeff Zucker wrote: Scott T. Hildreth wrote: I am missing something here (probably a few brain cells), how do I set up the dsn for DBD::AnyData (fixed format) when using dbish? Well, it's rather messy because dbish's

Re: Connect to DB2

2006-01-05 Thread Dan Scott
Hi Vincent: You just need to install the DB2 development headers and libraries (available with the free to download and use DB2 Application Development Client) on your Linux box and set DB2_HOME before compiling DBD::DB2; that will enable you to connect from your Linux box to a DB2 server running

Re: Connect to DB2

2006-01-05 Thread Dan Scott
on windows box or? Thanks in advance On 1/5/06, Dan Scott [EMAIL PROTECTED] wrote: Hi Vincent: You just need to install the DB2 development headers and libraries (available with the free to download and use DB2 Application Development Client) on your Linux box and set DB2_HOME before

Re: Bareword DBI::SQL_INTEGER not allowed while strict subs

2005-12-12 Thread Scott T. Hildreth
. Patrick Danley, Ph.D. Postdoctoral Researcher Department of Biology University of Maryland phone 301.405.8303 fax 301.314.9358 email [EMAIL PROTECTED] http://www.life.umd.edu/biology/shawlab/patrickdanley -- Scott T. Hildreth [EMAIL PROTECTED]

Re: problems using DBI:Proxy

2005-12-09 Thread Scott T. Hildreth
should send a request to? But then, I don't understand how to tell the proxy what port is the database running at. Can you help? Thanks for your time. -- Scott T. Hildreth [EMAIL PROTECTED]

Re: [cgiapp] Best free DB for a web-based Perl app response results...

2005-12-01 Thread Scott Webster Wood
Aaron Dancygier [EMAIL PROTECTED] wrote: Just look at the list of companies that use mysql. Would google and yahoo use it if it werent up to par? Corporate entities (i.e. corporate managers) make decisions that are not always generated from the same motivations as the rest of us. Google

Re: Proxy question?

2005-11-30 Thread Scott T. Hildreth
On Tue, 2005-11-29 at 11:55 -0600, Scott T. Hildreth wrote: Whoops, trace file was to big... attached is the first 200 lines. On Tue, 2005-11-29 at 11:39 -0600, Scott T. Hildreth wrote: Perl: 5.008003(i686-linux) OS : linux (2.4.24-abi) DBI

Re: DBD::Oracle

2005-11-29 Thread Scott T. Hildreth
Correct. On Tue, 2005-11-29 at 08:33 -0700, Ian Harisay wrote: Hi, I am upgrading my Oracle client. This probably means I need to recompile DBD::Oracle. Correct? Thanks, Ian -- Scott T. Hildreth [EMAIL PROTECTED]

Re: Proxy question?

2005-11-29 Thread Scott T. Hildreth
Whoops, trace file was to big... attached is the first 200 lines. On Tue, 2005-11-29 at 11:39 -0600, Scott T. Hildreth wrote: Perl: 5.008003(i686-linux) OS : linux (2.4.24-abi) DBI : 1.48 DBD::mysql : 2.9008 DBD::Sponge

Re: anyway to determine # rows before fetch loop ends and without seperate count(*)

2005-11-16 Thread Dan Scott
On 11/16/05, Rob Craig [EMAIL PROTECTED] wrote: I am using DBD::mysql and I can get the number of rows by assigning the result of the execute to a scalar: my $rows = $sth-execute or die Couldn't execute statement: . DBI-errstr; maybe this doesn't work with DBD::Oracle? Rob When you

Re: error while trying to install DBI

2005-11-04 Thread Dan Scott
Strange -- just tried the exact same commands here and they worked as expected. Maybe there was a temporary FTP server glitch. Are you able to see the ftp.esoftmatic.com site? Dan On 11/3/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello. I just installed perl 5.8.7 from active state. (I

Re: ANNOUNCE: MySQL 5.0 now final/stable/GA

2005-10-25 Thread Dan Scott
Hi Darren: I think an update about the recommended minimum database version levels for your access modules is on-topic for this mailing list, but suspect that product advertisements are probably off-topic -- personal opinion, maybe, but I don't want to see this list become a dumping ground for

Re: DBD::Oracle 10.1 client

2005-10-25 Thread Scott T. Hildreth
(the one that worked) was on a Linux server. -- Scott T. Hildreth [EMAIL PROTECTED]

DBD::Oracle 10.1 client

2005-10-21 Thread Scott T. Hildreth
unusual. I don't know if this is an NLS-utf8 issue. Any ideas? Thanks, STH Trace- level 9 is attached. -- Scott T. Hildreth [EMAIL PROTECTED] DBI::db=HASH(0x829bca0) trace level set to 9 in DBI 1.39-nothread (pid 25442

Re: DBD::Oracle 10.1 client

2005-10-21 Thread Scott T. Hildreth
this is a known bug. I copied the table to a 9i instance and the ran the code below, and it worked fine. So it seems to be related to 10g. Thu, 2005-10-20 at 14:07 -0500, Scott T. Hildreth wrote: I am going to investigate more, but I thought I would post the question to see if anyone has run

Re: bind_param_inout + DBD::ODBC

2005-10-12 Thread Dan Scott
DBD::DB2 (http://search.cpan.org/dist/DBD-DB2/DB2.pod) supports bind_param_inout, but it would require you to use the DB2 Connect Personal Edition or DB2 Connect Unlimited for iSeries to access iSeries from your Linux, UNIX, or Windows box. Dan On 10/12/05, Stephen More [EMAIL PROTECTED] wrote:

Re: Help with DBD-DB2 and Windows...

2005-10-07 Thread Dan Scott
If you're willing to upgrade to Perl 5.8.x, then you can use the latest available version of DBD-DB2 from http://ftp.esoftmatic.com/DBI/ (it's okay to install the 5.8.4 version of DBD-DB2 on Perl 5.8.7). Dan On 10/7/05, Trent Ohannessian [EMAIL PROTECTED] wrote: Hello, I currently have Perl

Re: How to set language on DB2 on AIX

2005-09-25 Thread Dan Scott
[EMAIL PROTECTED] wrote: Hello, I'm now using Perl 5.005, DBI-1.15, DBD-DB2-0.75 on AIX 4.3. And like to upgrade them to Perl 5.8, DBI-1.48, DBD-DB2-0.78. Installation may be ok, but when I INSERT double bytes characters, I get the following error. [IBM][CLI Driver] CLI0109E String data

Re: DBD-DB2 install issue

2005-09-23 Thread Dan Scott
Dan Scott wrote: Alec Brecher wrote: My DBD-DB2 installation on Fedora Core 3 is failing because it cannot find libdb2.so.1. The Application Dev client is installed and works fine. The DB2_HOME=/home/db2inst1/sqllib I saw some post from Owen Berry on another list regarding this issue. His

Re: DBD-DB2 install issue

2005-09-22 Thread Dan Scott
Alec Brecher wrote: My DBD-DB2 installation on Fedora Core 3 is failing because it cannot find libdb2.so.1. The Application Dev client is installed and works fine. The DB2_HOME=/home/db2inst1/sqllib I saw some post from Owen Berry on another list regarding this issue. His fix: add

Re: DB2 Err Handling

2005-09-20 Thread Dan Scott
Tim Bunce wrote: On Fri, Sep 02, 2005 at 05:37:57PM -0500, johnn wrote: Capacio, Paula J wrote: my $stmt = 'select count(*) from sysibm.badTblnm '; my $sth = $dbh-prepare($stmt) or die Prepare Failed\n; DBD::DB2 doesn't seem to return false values for failures. If that's true then

  1   2   3   4   >