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 upgra

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
I wanted to see if anyone else has had the same issue. Thanks, Scott

DBD::DB2 install failure

2019-09-18 Thread Scott Stark
t_opt_'? __out_opt ^ _Out_opt_ C:/PROGRA~1/IBM/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 arou

Re: DBD::CSV and skip_first_line

2013-01-29 Thread Scott R. Godin
On 11/26/2012 11:56 AM, H.Merijn Brand wrote: >> I still think it would be easier if skip_first_line were not presumed >> > (forced to) false if col_names is set, but rather presumed false only if >> > not set explicitly true. > > We agree, investigating what is actually required (and should be > d

Re: DBD::CSV and skip_first_line

2012-11-26 Thread Scott R. Godin
08|6|0 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,

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" > 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, "Sco

Re: DBD::CSV and skip_first_line

2012-11-26 Thread Scott R. Godin
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" >> wrote: >> >>> I've run into an issue where I need both col_names set and >>> skip_first_line s

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

2012-05-02 Thread Stricker, Scott (IS)
$p_Target, 20) 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. Scot

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

2012-05-02 Thread Stricker, Scott (IS)
rget) 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"; $sth->execute(); Hoping it is something really simple. Thanks for any help E. Scott Stricker @ Work

Maintaining simultaneous support for two Oracle versions in DBI

2011-12-03 Thread Scott Smith
e second? Are there others I should have included? Thanks for any help, Scott Smith

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

2011-10-05 Thread Scott Stansbury
ake sense at all? ;) Once again, thanks for taking the time to help... Scott...

Re: :ODBC fails, SQL*Plus works

2011-10-05 Thread Scott Stansbury
that was a contributing factor. Thanks for your help! Scott...

Re: :ODBC fails, SQL*Plus works

2011-10-05 Thread Scott Stansbury
uld not resolve the connect identifier 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
. What is the 10.128 ? > > -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 fo

DBD::ODBC fails, SQL*Plus works

2011-10-05 Thread Scott Stansbury
ot;$oracle_passwd"); It returns (after a few seconds) with an ORA-12154 error: TNS:could not resolve the connect identifier specified ( SQL-08004). Thanks for any 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. Wit

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

2010-04-30 Thread Stricker, Scott (IS)
CSMDA','PASSWORD',... and all is well. Thanks for the help. 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 Mess

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

2010-04-30 Thread Stricker, Scott (IS)
l 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,

Having a problem conneting to an Oracle 11gr2 RAC

2010-04-29 Thread Stricker, Scott (IS)
\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora Used HOSTNAME adapter to resolve the alias Attempting to contact (DESCRIPTION=(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))

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

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

2009-12-15 Thread Scott Smith
ocess 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: Retrieving warnings after executing a MySQL INSERT statement

2009-08-02 Thread Saccone, Scott
t;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
er value: 'sdc' for column 'age' at row 1 | +-+--+--+ 1 row in set (0.00 sec) If I do the same thing in the DBI, I don't seem to see any errors or warnings raised: $code=<do($code) or die "Error loading data: $DB

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

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-

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

2009-06-26 Thread Scott Stansbury
(Wstat: 256 Tests: 65 Failed: 1) Failed test: 56 Non-zero exit status: 1 Files=21, Tests=445, 33 wallclock secs ( 0.02 usr 0.26 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
lanned 11 tests but ran 10. Files=21, Tests=444, 30 wallclock secs ( 0.02 usr 0.28 sys + 0.35 cusr 2.49 csys = 3.14 CPU) Result: FAIL Failed 2/21 test programs. 3/444 subtests failed. make: *** [test_dynamic] Error 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: $CPAN/authors/id/T/TI/TIMB/DBI-1

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...@easysof

RE: unable to write from a select into outfile

2009-05-15 Thread Stricker, Scott E (IS)
earlier versions of dbd-odbc yet. Any light 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: 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 > > Ente

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 th

5.8.9 eating up memory with AUTOLOAD

2009-04-01 Thread Scott T. Hildreth
The only problems I had when 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

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: &g

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 wro

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? > >>

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

2009-03-25 Thread Scott T. Hildreth
his? We are moving to 11g now and I am having 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. >

Re: NULL = undef, even in Perl list?

2009-03-10 Thread Scott Smith
that point, or one of your triggers is at play. Best, 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 seve

Re: How to iterate through database tables

2009-02-03 Thread Scott Smith
uses Oracle's "execute immediate" to effectively "eval" the SQL there.. Scott Dale wrote: On Tue, Feb 3, 2009 at 8:47 AM, Deviloper 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

Re: Perl 5.10.0

2008-06-05 Thread Scott Ryan
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

Re: Recursive SQL query? - Ah hah!

2008-04-16 Thread Scott Webster Wood
he first with a value for each? SW - 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

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

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 >descri

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: catego

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 &g

Re: DBD::Oracle - execute_array core dumps intermittently

2008-03-07 Thread Scott T. Hildreth
i, 2008-03-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 i

Re: DBD::Oracle - execute_array core dumps intermittently

2008-03-07 Thread Scott T. Hildreth
d love to hear them! 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 r

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 calli

Looking for a good explanation of select function in perl dbi

2007-09-17 Thread Scott Mohnkern
ELECT function? I took a look at: http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html But it kind of lost me. Scott Mohnkern

Question that may not have an answer

2007-09-17 Thread Scott Mohnkern
ut the data into. I 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

Bundle::DBI Failure

2007-08-01 Thread Scott T. Hildreth
cd into the build directory, 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
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

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

2007-07-19 Thread Scott T. Hildreth
there anyone around with access to an oracle database 10.* and > running perl 5.8.* who could run the test code I provided earlier? The > one that just connects? It would be interesting to know how strongly > dependent it is to just my specific setup... I know you asked for Oracle 10, but here is the result of Perl: 5.008006(i686-linux) OS : linux (8.0) DBI : 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 <[EMAIL PROTECTED]>

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. /home/x703299/downloads/extracted/DBD-ODBC-1.13

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

2007-06-22 Thread Peter Scott
gt; subroutine scoped lexicals are not cleared when the subroutine exits, > but persist (consuming memory) until the subroutine is reentered? $ ./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&#

Duplicate table structure

2007-06-06 Thread Peter Scott
. They're both Oracle, but there's no chance of a cross-database link here. -- Peter Scott http://www.perlmedic.com/ http://www.perldebugged.com/

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-t

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

2007-05-04 Thread Scott Smith
acle must reverse out all changes 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

Re: environment variable

2007-01-19 Thread Scott Smith
the variable setting or override in your general shell session. i.e. LD_PRELOAD=/usr/lib/special_old_library.so /usr/bin/oldprogram Scott Smith Genome Sequencing Center

DBD::Proxy - getting unitialized error for $numFields

2007-01-18 Thread Scott T. Hildreth
x27;m sure it is something simple I am missing here... Thanks. -- Scott T. Hildreth <[EMAIL PROTECTED]>

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

RE: MySQL upgrade caused Perl coredumps...

2006-11-04 Thread NIPP, SCOTT V \(SBCSI\)
:CSV: 0.22 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

RE: MySQL upgrade caused Perl coredumps...

2006-11-04 Thread NIPP, SCOTT V \(SBCSI\)
AIL PROTECTED] Sent: Saturday, 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

MySQL upgrade caused Perl coredumps...

2006-11-04 Thread NIPP, SCOTT V \(SBCSI\)
ARGE_FILES Locally applied patches: defined-or Built under hpux Compiled at Jun 1 2005 13:42:32 @INC: /opt/perl/lib/5.8.7/PA-RISC2.0 /opt/perl/lib/5.8.7 /opt/perl/lib/site_perl/5.8.7/PA-RISC2.0 /opt/perl/lib/site_perl/5.8.7 /opt/perl/lib/site_perl . >

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 ver

Re: code needed

2006-09-04 Thread Scott T. Hildreth
TED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > <http://learn.perl.org/> <http://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: > If you have a pre-compiled module, then I think your problem is the absence of DB2 Connect (IIRC) or its equivalent. The basic connectivity requirement for DBD::DB2 on all

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 09/06/0

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 (http://tldp.org/HOWTO/DB

RE: Oracle connect hangs forever

2006-04-25 Thread Scott T. Hildreth
istener to date.l > > -- > 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 &g

Oracle connect hangs forever

2006-04-25 Thread Scott T. Hildreth
R-2006 15:27:25 Thanks, STH -- Scott T. Hildreth <[EMAIL PROTECTED]>

Re: DBD:Oracle

2006-04-11 Thread Scott T. Hildreth
ation in error, please resend this > communication to the sender and delete the original message or any copy > of it from your computer system. > > 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 packages

Re: Re: Upgrade.. DBI

2006-03-29 Thread Scott T. Hildreth
eplies like this when some posts to dbi-users. > -- Scott T. Hildreth <[EMAIL PROTECTED]>

Re: Upgrade.. DBI

2006-03-29 Thread Scott T. Hildreth
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ > countries) for 2¢/min or less. -- 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
- > Relax. Yahoo! Mail virus scanning helps detect nasty viruses! -- Scott T. Hildreth <[EMAIL PROTECTED]>

Re: Strange error when doing insert into DB

2006-02-20 Thread Scott T. Hildreth
$sth; > > Waiting for your help..Also wud like to know how i can add myself in this Go to the link below, http://lists.cpan.org/showlist.cgi?name=dbi-users > list .. > > Regards, > -Hemlata Lalwani > > - Original Message - > From: "Scott T. H

RE: Strange error when doing insert into DB

2006-02-20 Thread Scott T. Hildreth
Which i got when i insert the mail into databse..this mail actually > bouced back... > > Regards, > -Hemlata Lalwani > Hemlata Lalwani | Linux Administrator ( Systems ) I Webdunia.Com > (India) Pvt Ltd | 582 MG Road Indore MP | Work +91-731-398-3426 | > Mobile +91-93

Re: trouble installing DBD:DB2

2006-02-07 Thread Dan Scott
Hi: Since you're running on a 64-bit platform, is there any chance that you are trying to link 32-bit Perl libraries against 64-bit DB2 libraries? "file /home/db2inst1/sqllib/lib/libdb2.so.1" will tell you the DB2 library bitness. Dan On 2/7/06, Jason S. Friedman <[EMAIL PROTECTED]> wrote: > Hi

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 s

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? > > > &g

DBD::AnyData & dbish

2006-01-06 Thread Scott T. Hildreth
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? Thanks, STH -- Scott T. Hildreth <[EMAIL PROTECTED]>

Re: Connect to DB2

2006-01-05 Thread Dan Scott
B2 home directory 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 u

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: Bareword "DBI::SQL_INTEGER" not allowed while "strict subs"

2005-12-12 Thread Scott T. Hildreth
> BEGIN failed--compilation aborted at /Users/TheBucket/genome/bin/ > PartiGene_db.pl line 4. > > > > 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
localport',1521) > called at ./testProxy0.pl line 5 > - > > Now, changing the port to a free value (1521 is used by Oracle) gets > rid of the error. Is this the way to go? Is this 'free' port the value > that the DBI:Proxy 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 a

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 : li

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 >

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: 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? > >

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.

Re: DBD::Oracle & 10.1 client

2005-10-25 Thread Scott T. Hildreth
with another 10g Db. The only difference is the one db was on an Alpha and the other one (the one that worked) was on a Linux server. -- Scott T. Hildreth <[EMAIL PROTECTED]>

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 the

Re: DBD::Oracle & 10.1 client

2005-10-21 Thread Scott T. Hildreth
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 ru

  1   2   3   4   5   >