Re: DBI connect error

2003-04-01 Thread Rudy Lippan
uOn Tue, 1 Apr 2003, Dan Swanson wrote: > I am getting the following error when trying to connect locally to a Postgres > database on Red Hat Linux 8. I have confirmed the database "testdb" exists and I can > query it using an sql program. Below is three lines of code. I have used similar > cod

DBI connect error

2003-04-01 Thread Dan Swanson
I am getting the following error when trying to connect locally to a Postgres database on Red Hat Linux 8. I have confirmed the database "testdb" exists and I can query it using an sql program. Below is three lines of code. I have used similar code to connect to an Informix database. Has anyone

Re: DBD::Oracle-1.14 build fails with oracle 8.0.6 ?

2003-04-01 Thread Daniel Vérité
Tim Bunce wrote: > Try the appended patch. Please let me know if it works. It builds fine with the patch applied. It doesn't work thereafter but it's obviously unrelated to the patch: inside the DBI->connect, the call to OCIEnvInit() oddly returns OCI_ERROR, I'll try to understand why th

DBD::Sybase 0.99_02

2003-04-01 Thread Michael Peppler
Additional fixes, and verified to at least build correctly against freetds... Please fetch it and build it if you have the time. Thanks! Michael On Mon, 2003-03-31 at 15:59, Michael Peppler wrote: > This is a test release - available at http://www.peppler.org/downloads/ > > If you have the tim

RE: OT: What's up with CPAN

2003-04-01 Thread Karyn Ulriksen
Haha... On the Perl-NTAdmin list, someone's got them going that the site was taken down because modules were being used for a terrorist plot. I think I'll watch. No sense me being the only sucker :) Karyn -Original Message- From: Fernando Luna [mailto:[EMAIL PROTECTED] Sent: Tuesday, Ap

RE: OT: What's up with CPAN

2003-04-01 Thread Fernando Luna
...and all the links point to http://www.cpan.org/index2.html which is the actual cpan website... Oh well... I guess geeks have to have their fun, too... :) > -Original Message- > From: William R. Mussatto [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 01, 2003 10:37 AM > To: [EMAIL P

Re: OT: What's up with CPAN

2003-04-01 Thread William R. Mussatto
> I think I've had my head buried in code too long. Why in god's creation > is www.cpan.org now going to Matt's Script Archive? > > Karyn perl.com also goes there. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061

Re: New fetchrow behavior in DBD::Sybase??

2003-04-01 Thread Michael Peppler
On Mon, 2003-03-31 at 15:25, Tim Bunce wrote: > On Mon, Mar 31, 2003 at 02:01:30PM -0800, Michael Peppler wrote: > > On Mon, 2003-03-31 at 11:36, Karyn Ulriksen wrote: > > > This worked pretty well before. But, now, it appears that if the result of > > > the query is a null set, it pukes with a: >

RE: OT: What's up with CPAN

2003-04-01 Thread Karyn Ulriksen
Jeesh. Got me. Told you my head has been buried in code too long. -Original Message- From: johnn [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:34 AM To: [EMAIL PROTECTED]; Karyn Ulriksen Subject: Re: OT: What's up with CPAN On Tue, Apr 01, 2003 at 10:26:51AM -0800, Kar

Re: OT: What's up with CPAN

2003-04-01 Thread johnnnnnn
On Tue, Apr 01, 2003 at 10:26:51AM -0800, Karyn Ulriksen wrote: > I think I've had my head buried in code too long. Why in god's > creation is www.cpan.org now going to Matt's Script Archive? Check the date... -johnnn

Re: Making script an "interactive" client for MySQL

2003-04-01 Thread Paul DuBois
At 10:14 -0800 4/1/03, b t wrote: --- Paul DuBois <[EMAIL PROTECTED]> wrote: At 9:08 -0800 4/1/03, b t wrote: >Does anyone know how to do this for the MySQL DBI >module? You could change the timeout at the SQL level: SET wait_timeout = some_number Thanks for the suggestion, but I cannot do t

OT: What's up with CPAN

2003-04-01 Thread Karyn Ulriksen
I think I've had my head buried in code too long. Why in god's creation is www.cpan.org now going to Matt's Script Archive? Karyn

RE: DBD-ODBC Strange Behavior?

2003-04-01 Thread Adam Peterson
--- Jeff Urlwin <[EMAIL PROTECTED]> wrote: > Actually, it would also help if you sent me a trace file of what's going > on. > i've attached a zip containing four text files. note i get different errors when running the same script on win2k and win2k server. i'm not sure why... system dsn are conf

Re: Making script an "interactive" client for MySQL

2003-04-01 Thread b t
--- Paul DuBois <[EMAIL PROTECTED]> wrote: > At 9:08 -0800 4/1/03, b t wrote: > >Does anyone know how to do this for the MySQL DBI > >module? > > You could change the timeout at the SQL level: > > SET wait_timeout = some_number Thanks for the suggestion, but I cannot do that for two reasons:

Re: Making script an "interactive" client for MySQL

2003-04-01 Thread Paul DuBois
At 9:08 -0800 4/1/03, b t wrote: I have a script that needs to connect to MySQL as an interactive client, so that it falls under the interactive_timeout setting instead of the wait_timeout setting. I looked through the docs, and did not see how to specify this when connecting. However looking at th

Making script an "interactive" client for MySQL

2003-04-01 Thread b t
I have a script that needs to connect to MySQL as an interactive client, so that it falls under the interactive_timeout setting instead of the wait_timeout setting. I looked through the docs, and did not see how to specify this when connecting. However looking at the code in some of mysql's C cli

RE: DBD-ODBC Strange Behavior?

2003-04-01 Thread Jeff Urlwin
Actually, it would also help if you sent me a trace file of what's going on. One way is to put the following line right before the connect: DBI->trace(9, "dbitrace.txt"); Jeff > > here's a sample piece that works when i don't include "use eggsupp;" > > hope this helps. > > #!perl.ex

OT: Announce Query Express Data Portal

2003-04-01 Thread Thomas Hilbig
This is off-topic for the DBI list, but DBI (and CGI.pm) was such a core component of this application that I just wanted to show my appreciation towards those who contributed to DBI. Thanks Tim et all! Query Express 2.4 data portal is available for downloading. This is a very elegant but power

RE: problems with version of dbi or dbd-odbc?

2003-04-01 Thread Adam Peterson
> Can you wrap it up in a small example, showing the issue? new config: dbi - 1.34 dbd-odbc 1.04 old config: dbi - 1.34 dbd-odbc .43 or lower when i run the below code on the new config i get these errors: C:\>perl\scripts\recent_claim_data_test.pl DBD::ODBC::st execute failed: [Microsoft][ODBC

RE: DBD-ODBC Strange Behavior?

2003-04-01 Thread Adam Peterson
here's a sample piece that works when i don't include "use eggsupp;" hope this helps. #!perl.exe -w use DBI; use strict; # # # # T

RE: problems with version of dbi or dbd-odbc?

2003-04-01 Thread Jeff Urlwin
> > --- Jeff Urlwin <[EMAIL PROTECTED]> wrote: > > Is it logging in the same way as the prior version? > > > > yes, seems to be the same. Can you wrap it up in a small example, showing the issue? I've got some time to work on DBD::ODBC this week and would like to get it done, if it's something

RE: oracle + mysql

2003-04-01 Thread Steve Haslam
That's what I'd generally do-- pass around a full dbi connect string rather than hardcoding in which driver to use... or if you must, pass a driver and database name. Perhaps avoid the odd array-to-hash coercing by making an array of database connection parameters, e.g.: my @def_tns = ( [ "dbi:O

RE: problems with version of dbi or dbd-odbc?

2003-04-01 Thread Adam Peterson
--- Jeff Urlwin <[EMAIL PROTECTED]> wrote: > Is it logging in the same way as the prior version? > yes, seems to be the same. > > > > > hello everyone, > > > > i recently downloaded the latest version of perl which came > > with the following that i installed via the ppm. > > new: > > ac

Re: oracle + mysql

2003-04-01 Thread S H A N
hi gurus any help? hmm... On Mon, Mar 31, 2003 at 09:22:29AM +0800, S H A N wrote: > hi, > a few dirty tricks can make it work like incorporating dbi:Oracle, dbi:mysql > into $tns itself.. but wouldn't it be labled as bad practice? :) just curious to > find something proper. > > rgds, >

Re: AIX 5.1 and DBD-Oracle1.14 syntax error

2003-04-01 Thread Tim Bunce
On Tue, Apr 01, 2003 at 11:59:10AM +0200, Davor ?eker wrote: > Hi guys, > > I had a lot of problem to connect from another machine to Oracle Database and thanks > to README and this site I fix it ,but now I need your help. > > "dbdimp.c", line 263.13: 1506-046 (S) Syntax error. Ah, a stray C++

AIX 5.1 and DBD-Oracle1.14 syntax error

2003-04-01 Thread Davor Đeker
Hi guys, I had a lot of problem to connect from another machine to Oracle Database and thanks to README and this site I fix it ,but now I need your help. What I done: On Server side: Suse Linux 8.0,Oracle server 9.2,Perl 5.8,DBI 1.34,DBD 1.12 and everything working, no

Re: Upgrade to DBD::Oracle1.14 on AIX 4.3.3

2003-04-01 Thread Jeremy.Richards
All seems well now thanks. (See attached file: DBD-Oracle-1.14_perl_Makefile-PL.txt)(See attached file: DBD-Oracle-1.14_make.txt)(See attached file: DBD-Oracle-1.14_make_test.txt)(See attached file: DBD-Oracle-1.14_make_install.txt)(See attached file: perl-V.txt) Regards Jeremy Richards Senior