DBD::Sybase 1.09 build error on perl 5.10.0

2008-12-28 Thread Matthew Persico
I have a failure building DBD::Sybase 1.09 in the xblk stuff, which I really don't use, but maybe you want to investigte anyway. I am building perl 5.10.0 on Solaris, threaded (yes, threaded, please don't try to talk me out of it.). DBI is 1.607. Sybase server is Adaptive Server

Re: Recursive SQL query?

2008-04-16 Thread Matthew Persico
If the singular is The syntax of the command is The command has two syntaxes The command has two syntacies (like incidies) On Wed, Apr 16, 2008 at 9:24 AM, Scott Webster Wood [EMAIL PROTECTED] wrote: - Original Message From: Colin Wetherbee [EMAIL PROTECTED] My goal was as a

Re: Recursive SQL query?

2008-04-16 Thread Matthew Persico
syntactical forms I prefer 1 or 5. Either way, just pick one. It's not like this is French or something where the bloody government has to vote on the language... On Wed, Apr 16, 2008 at 1:50 PM, Matthew Persico [EMAIL PROTECTED] wrote: If the singular is The syntax of the command is The command

Re: Recursive SQL query?

2008-04-16 Thread Matthew Persico
http://encarta.msn.com/encnet/features/dictionary/DictionaryResults.aspx?refid=1861717794 On Wed, Apr 16, 2008 at 1:54 PM, Matthew Persico [EMAIL PROTECTED] wrote: Bloody keyboard Anyway, If the singular is The syntax of the command is Then the plural possibilites

Re: Recursive SQL query?

2008-04-16 Thread Matthew Persico
http://en.wiktionary.org/wiki/syntax http://encarta.msn.com/encnet/features/dictionary/DictionaryResults.aspx?refid=1861717794 On Wed, Apr 16, 2008 at 2:03 PM, Matthew Persico [EMAIL PROTECTED] wrote: http://encarta.msn.com/encnet/features/dictionary/DictionaryResults.aspx?refid=1861717794

Re: Recursive SQL query?

2008-04-15 Thread Matthew Persico
http://www.google.com/search?hl=ennewwindow=1safe=offrlz=1T5GGLL_enUS258US259q=joe+celkobtnG=Search On Tue, Apr 15, 2008 at 6:55 PM, Colin Wetherbee [EMAIL PROTECTED] wrote: Scott Webster Wood wrote: You shouldn't really need to go recursing through a data tree to come up with all the

Fwd: DBD::Sybase, serverType

2007-10-04 Thread Matthew Persico
Sorry, forgot to include the list... -- Forwarded message -- From: Matthew Persico [EMAIL PROTECTED] Date: Oct 3, 2007 12:16 PM Subject: Re: DBD::Sybase, serverType To: [EMAIL PROTECTED] [EMAIL PROTECTED] On 10/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: In 1.08 the only

DBD::Sybase, serverType

2007-10-02 Thread Matthew Persico
From the docs: serverType Tell DBD::Sybase what the server type is. Defaults to ASE. Setting it to something else will prevent certain actions (such as setting options, fetching the ASE version via @@version, etc.) and avoid spurious errors. Where can we find a list of the other types aside

Re: DBD::Sybase, serverType

2007-10-02 Thread Matthew Persico
On 10/2/07, Tim Bunce [EMAIL PROTECTED] wrote: On Tue, Oct 02, 2007 at 03:07:39PM -0400, Matthew Persico wrote: From the docs: serverType Tell DBD::Sybase what the server type is. Defaults to ASE. Setting it to something else will prevent certain actions (such as setting options

Re: Announce: Slides for Advanced DBI Tutorial 2007

2007-07-31 Thread Matthew Persico
Any chance somebody recorded the audio for a Pod/Perlcast? On 7/30/07, Tim Bunce [EMAIL PROTECTED] wrote: file: $CPAN/authors/id/T/TI/TIMB/DBI_AdvancedTalk_200708.pdf size: 494172 bytes md5: bc04cc4f1780457cccbede8529c8726b 119 pages... Enjoy! Tim. -- Matthew O. Persico

Re: 100 levels deep in subroutine calls!

2007-06-19 Thread Matthew Persico
On 6/19/07, Ron Savage [EMAIL PROTECTED] wrote: Hi Peter 100 levels deep in subroutine calls! Is this strictly a Perl debug error message or is this a generic Perl error message? Is there a way around this limitation? I saw something while searching on the Internet about setting the

Re: DBD::Sybase 1.07_06

2007-04-10 Thread Matthew Persico
On 4/10/07, Michael Peppler [EMAIL PROTECTED] wrote: All, I'm finally getting closer to releasing the DBD::Sybase 1.08, which will have a number of fixes. I would like to encourage those of you who have the time and the resources to please download and install version 1.07_06 from

ppms

2007-03-07 Thread Matthew Persico
Does anyone know of an up-to-date ppm repository for DBD-Sybase 1.07, Win32, activestae 5.8.8? I can't seem to make Google gurgle one up. Thanks. -- If I caught someone blessing into class 0 at my work he'd have to give such a damned good reason that I wouldn't use his eye sockets for USB ports.

Re: ppms

2007-03-07 Thread Matthew Persico
On 3/7/07, Matthew Persico [EMAIL PROTECTED] wrote: Does anyone know of an up-to-date ppm repository for DBD-Sybase 1.07, Win32, activestae 5.8.8? I can't seem to make Google gurgle one up. Thanks. Update: Is http://www.peppler.org/downloads/ActiveState/DBD-Sybase-1.07_01.zip still legit

Re: Fwd: Can't connect to Sybase Rep server

2006-11-24 Thread Matthew Persico
On 11/24/06, Matthew Persico [EMAIL PROTECTED] wrote: On 11/23/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi Matthew, The real problem is that there is no way to detect that we're trying to connect to a rep server, so DBD::Sybase still tries to use teh ct_option() calls, and to get

Re: Fwd: Can't connect to Sybase Rep server

2006-11-24 Thread Matthew Persico
On 11/23/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi Matthew, The real problem is that there is no way to detect that we're trying to connect to a rep server, so DBD::Sybase still tries to use teh ct_option() calls, and to get the version of the server (via select @@version). Obviously

Fwd: Can't connect to Sybase Rep server

2006-11-22 Thread Matthew Persico
-- Forwarded message -- From: Matthew Persico [EMAIL PROTECTED] Date: Nov 20, 2006 12:45 PM Subject: Re: Can't connect to Sybase Rep server To: Michael Peppler [EMAIL PROTECTED] Well, it's been more than a week. :-) No, I have not been on jury duty THAT long, but now

Re: ANNOUNCE: DBI 1.52 - plus PDF of What's New presentation

2006-08-09 Thread Matthew Persico
http://www.cpan.org/modules/by-authors/id/TIMB/DBI_WhatsNewTalk_200607.pdf Very nit picky, but is there a version of this that I can print without killing all the black ink in my printer? -- Matthew O. Persico

Re: Possible to get field names and types in a table without executing a query?

2006-06-27 Thread Matthew Persico
On 6/27/06, Jordan Sissel [EMAIL PROTECTED] wrote: iirc, you can use $dbh-table_info() or tables() or type_info() functions to pull that information without having to do a hack where you select 0 rows just to poll for column names. Right? Yes. Unless you want the information for a

DBD::Sybase misleads me?

2006-06-23 Thread Matthew Persico
I have a commercial program that accesses a Sybase 12.5 server. It has an option to change the packet size of the communucation frame with the server, but you have to know what size you want. Sooo, in my perl program, I connect to the database with DBD::Sybase, execute a sp_configure 'max

Re: DBD::Sybase misleads me?

2006-06-23 Thread Matthew Persico
On 6/23/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I suspect that this should really be addressed to a Sybase list. Sorry about that. However, what may happen is that the server doesn't have enough network memory available and therefore is not able to allow the client to connect with

Re: multiple perl installs - OT

2006-06-22 Thread Matthew Persico
On 6/22/06, LLC [EMAIL PROTECTED] wrote: Hi List; does anyone know how to install a new instance/version of perl on a Linux box (RHEL4) which already has more than one instance installed and force scripts to not only use the new perl executable but the new perl libs, modules, etc? Thanks in

Re: DBI-1.14

2006-05-11 Thread Matthew Persico
On 5/10/06, Jon Baldassari [EMAIL PROTECTED] wrote: I recompiled PERL from source, to have it use gcc. The installation went fine. I installed the following PERL Modules: DBD-1.28 DBD What? DBD-Oracle? DBD-Sybase? MIME-Lite-3.01 libnet-1.19 All of the above modules installed fine. When

Fwd: Can't connect to Sybase Rep server

2006-03-02 Thread Matthew Persico
-- Forwarded message -- From: Matthew Persico [EMAIL PROTECTED] Date: Mar 2, 2006 10:21 AM Subject: Re: Can't connect to Sybase Rep server To: [EMAIL PROTECTED] [EMAIL PROTECTED] On 3/2/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Here's the code that checks to see

Re: Can't connect to Sybase Rep server

2006-03-01 Thread Matthew Persico
On 2/28/06, Matthew Persico [EMAIL PROTECTED] wrote: Message d'origine De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Date: mar. 28.02.2006 07:54 À: [EMAIL PROTECTED] Cc: dbi-users@perl.org Objet: Re: Can't connect to Sybase Rep server This is a known

Re: Can't connect to Sybase Rep server

2006-03-01 Thread Matthew Persico
On 3/1/06, Matthew Persico [EMAIL PROTECTED] wrote: On 2/28/06, Matthew Persico [EMAIL PROTECTED] wrote: Message d'origine De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Date: mar. 28.02.2006 07:54 À: [EMAIL PROTECTED] Cc: dbi-users@perl.org Objet: Re: Can't

Re: Can't connect to Sybase Rep server

2006-03-01 Thread Matthew Persico
. Are you sure it is reasonable to expect a DBI driver for Sybase ASE to work correctly with Rep Server? Maybe Sybperl is the way to go if you want your perl program to talk to a Rep Server. Good luck, Mark Matthew Persico wrote: This simple test program: use strict

Re: Can't connect to Sybase Rep server

2006-03-01 Thread Matthew Persico
Edited for brevity On 3/1/06, Matthew Persico [EMAIL PROTECTED] wrote: On 3/1/06, Matthew Persico [EMAIL PROTECTED] wrote: On 2/28/06, Matthew Persico [EMAIL PROTECTED] wrote: Message d'origine De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Date: mar

Re: Can't connect to Sybase Rep server

2006-02-28 Thread Matthew Persico
Message d'origine De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Date: mar. 28.02.2006 07:54 À: [EMAIL PROTECTED] Cc: dbi-users@perl.org Objet: Re: Can't connect to Sybase Rep server This is a known problem, and has been fixed in either 1.07 or 1.07_01. Must be

Can't connect to Sybase Rep server

2006-02-27 Thread Matthew Persico
This simple test program: use strict; use warnings; use DBI; my $dbh = DBI-connect('dbi:Sybase:server=REPP', 'REPP_login', 'REPP_passwd', {RaiseError = 1}); my $dummy = 6; causes this: Server message number=17001 severity=10 state=0 line=0 server=REPP text=No SRV_OPTION handler

Re: Can't connect to Sybase Rep server

2006-02-27 Thread Matthew Persico
. Good luck, Mark Matthew Persico wrote: This simple test program: use strict; use warnings; use DBI; my $dbh = DBI-connect('dbi:Sybase:server=REPP', 'REPP_login', 'REPP_passwd', {RaiseError = 1}); my $dummy = 6; causes this: Server message number=17001 severity=10 state=0 line

Re: DBD::Sybase and IQ anomaly.

2006-02-21 Thread Matthew Persico
Yeah. It looks like a typo. Suspend this thread until I get a short program with no typos that exhibits the incorrect behavior. On 2/21/06, Terence J. Young, D.C. [EMAIL PROTECTED] wrote: Aren't you missing the.. my $sql = $self-{load_statement}; part in the main code?? Matthew Persico

Re: Future versions of DBI to require perl = 5.8

2006-01-27 Thread Matthew Persico
On 1/27/06, Darren Duncan [EMAIL PROTECTED] wrote: [snip] Even if you can't move, its not like 5.8 is becoming a hard dependency, rather just a soft dependency, as I recall. The minute Tim writes a piece of code with a construct that is new to 5.8 because a) its cool b) he can c) its probably

Off topic, but on-community...

2005-09-16 Thread Matthew Persico
Within the past few months, I read an article which presented a Perl module running under Apache that reads a config file to generate a web interface for updating a table in a database, complete with the ability to use reference tables, specify explicit SQL, etc. I cannot for the life of me

Re: Reg. perl module installation

2005-05-24 Thread Matthew Persico
On 5/24/05, shanthi nagarajan [EMAIL PROTECTED] wrote: Dear Friend, I am shnathi Nagarajan working as a computer operator in Bioinformatics centre, Pondicherry University, India. Presently I am trying to connect perl and mysql. I have downloaded DBI-1.25.tar module and extracted into

Re: DBI-disconnect is not a DBI method. Read the DBI manual. at ff.pl line 224

2005-05-24 Thread Matthew Persico
a disconnect method to the subclass class that does just that. It's ugly and kludgy, but going back and rewriting MDISS::DB properly would require cycles that we just don't have. On 5/23/05, Matthew Persico [EMAIL PROTECTED] wrote: On 5/23/05, Matthew Persico [EMAIL PROTECTED] wrote: On 5/23/05

Re: DBI-disconnect is not a DBI method. Read the DBI manual. at ff.pl line 224

2005-05-23 Thread Matthew Persico
On 5/20/05, Tim Bunce [EMAIL PROTECTED] wrote: On Fri, May 20, 2005 at 10:08:36AM -0400, Matthew Persico wrote: Has anyone ever seen this message? I have a valid handle - all of my database commands work. The command is simply $dbh-disconnect(); I'd guess that $dbh contains the string

Re: DBI-disconnect is not a DBI method. Read the DBI manual. at ff.pl line 224

2005-05-23 Thread Matthew Persico
) there is some deep magic in DBI 2) the () changes the signature of the disconnect call in such a way that it does not match the prototype given in DBI and that since MDISS::DB is a subclass of DBI and not a DBI, we've confused perl in a bizzare way. -Original Message- From: Matthew Persico

Re: DBI-disconnect is not a DBI method. Read the DBI manual. at ff.pl line 224

2005-05-23 Thread Matthew Persico
On 5/23/05, Matthew Persico [EMAIL PROTECTED] wrote: On 5/23/05, Hemanth Kumar [EMAIL PROTECTED] wrote: What happens when you replace $dbh-disconnect(); with $dbh-disconnect; hth Hemanth Son-of-a-monkey's-uncle, that worked! Okay, now I'm lost. Does anyone want to explain

DBI-disconnect is not a DBI method. Read the DBI manual. at ff.pl line 224

2005-05-20 Thread Matthew Persico
Has anyone ever seen this message? I have a valid handle - all of my database commands work. The command is simply $dbh-disconnect(); What level should I use if I turn on tracing? TIA -- Matthew O. Persico

Extend DBD::Oracle?

2005-03-18 Thread Matthew Persico
I had an occasion to use the func('plsql_errstr') extension of DBD::Oracle today. It didn't exactly fit my needs. The problem is that the function as currently defined returns ALL of the contents of user_errors table, some of which are very old from pacakges that are not what I am loading. As

Re: Does DBD::Sybase support a way to get the number of rows affected by a statement?

2004-12-09 Thread Matthew Persico
Check the DBI docs - I seem to remember a generic function to call for all DBDs which should be implemented to work for particular DBDs On Thu, 9 Dec 2004 14:03:57 -0800 (PST), David Goodman [EMAIL PROTECTED] wrote: I checked that DBD::Sybase documentation and did not find a way to get the

Re: Does DBD::Sybase support a way to get the number of rows affected by a statement?

2004-12-09 Thread Matthew Persico
tells you after you have fetched/processed the whole result set. Matthew Persico wrote on 12/9/2004, 7:56 PM: Check the DBI docs - I seem to remember a generic function to call for all DBDs which should be implemented to work for particular DBDs On Thu, 9 Dec 2004 14:03:57 -0800

Re: DBIx::DBH - Perl extension for simplifying database connections

2004-12-06 Thread Matthew Persico
On Mon, 6 Dec 2004 17:23:46 +, Martyn J. Pearce [EMAIL PROTECTED] wrote: On Fri, Dec 03, 2004 at 11:25:53AM +, Tim Bunce wrote: Yes. It's finely balanced though. I can see merit on both sides. The fill in a form situation is relatively common. But beyond the MySQL/Pg model of

Re: get the messages, not the rows

2003-09-11 Thread Matthew . Persico
If MSSQL Server hasn't diverged too far from being a derivative of Sybase, you would trap those messages in an error or a message handler - but that only works in sybperl and DBD::Sybase AFAIK. I don't know how you would get to the those callbacks in ODBC. HTH somewhat. -- Matt

Trying to reach sybperl list, no luck

2003-09-10 Thread Matthew . Persico
compiled and tested with no complaints. Weird, since they both use CTLib, yes? Disclosure Note: I've bcc'ed the collegue I am working with so he's in the loop but does not have his email harvsted. -- Matthew Persico Vice President Lazard 30 Rockefeller Plaza New York, NY 10020, USA Phone Number: 212

Re: ORACLE_HOME environment variable must be set

2003-08-29 Thread Matthew . Persico
. If you do get a value, then I suspect it is getting wiped out and not reset in your build process. Happy Hunting. -- Matthew Persico Vice President Lazard 30 Rockefeller Plaza New York, NY 10020, USA Phone Number: 212 632 8255 Fax Number: 212 332 5904 Email: [EMAIL PROTECTED

Re: DBD:Sybase, AutoCommit and blocking...

2003-07-17 Thread Matthew . Persico
. -- Matthew Persico Vice President Lazard 30 Rockefeller Plaza New York, NY 10020, USA Phone Number: 212.632.8255 Fax Number: 212.332.5904 Email: [EMAIL PROTECTED] ---

DBD:Sybase, AutoCommit and blocking...

2003-07-16 Thread Matthew . Persico
think of is that since AutoCommit == 0, there's an explicit open trans that I have to close after the finish() above using something like: if ($dbh-{AutoCommit}) { $dbh-commit() } Am I missing something else? --- Matthew

Re: (Fwd) Dual DBD::Oracle install on same box

2003-07-01 Thread Matthew . Persico
. --- Matthew Persico Vice President Lazard 30 Rockefeller Plaza New York, NY 10020, USA Phone Number: 212.632.8255 Fax Number: 212.332.5904 Email: [EMAIL PROTECTED

Re: test of TIMB@cpan.org

2003-03-14 Thread Matthew . Persico
Test received To: [EMAIL