london.pm Digest, Vol 30, Issue 38
Hemant Verma
Hemant.Verma at ons.gsi.gov.uk
Thu Apr 10 09:17:44 BST 2008
Hi,
This is in the response of Ovid <publiustemp-londonpm at yahoo.com>.
Actually Perl exeucte die command.
I have following command. It shows "Can't connect to TM V6 (dsn=$my_dsn)"
message in the browser. It means it is not able to connect with this
database.
If I execute this script in komodo itself then it is able to connect with
the database successfully.
That's what I want if there is any extra restriction on using cgi or perl
script from browser.
$tmdb = new Win32::ODBC("DSN=$my_dsn; UID=USER; PWD=pwd") or die "Can't
connect to TM V6 (dsn=$my_dsn)\n";
Thanks & Regards,
Hemant Verma
Steria India
----------------------------------------------------------------
Office for National Statistics, Southampton.
Mob: 07715759776, Direct CUG: 8889776
Ext: 0132-981-3575
london.pm-request at lo
ndon.pm.org To: london.pm at london.pm.org
Sent by: cc:
london.pm-bounces at lo Subject: london.pm Digest, Vol 30, Issue 38
ndon.pm.org
09/04/2008 17:35
Please respond to
london.pm
Send london.pm mailing list submissions to
london.pm at london.pm.org
To subscribe or unsubscribe via the World Wide Web, visit
http://london.pm.org/mailman/listinfo/london.pm
or, via email, send a message with subject or body 'help' to
london.pm-request at london.pm.org
You can reach the person managing the list at
london.pm-owner at london.pm.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of london.pm digest..."
Today's Topics:
1. Error on connecting database using Perl (Hemant Verma)
2. HTML reporting for Test::Builder related modules
(Ismail, Rafiq (IT))
3. [ANNOUNCE] May social (David Cantrell)
4. [ANNOUNCE] London.pm May meeting - Thursday 8 May 2008
(Kake L Pugh)
5. Re: HTML reporting for Test::Builder related modules (Dave Cross)
6. Re: Error on connecting database using Perl (Jonathan Stowe)
7. Re: Error on connecting database using Perl (Ovid)
8. RE: HTML reporting for Test::Builder related modules
(Ismail, Rafiq (IT))
9. Re: [ANNOUNCE] May social (Nicholas Clark)
10. Re: [ANNOUNCE] May social (Peter Corlett)
----------------------------------------------------------------------
Message: 1
Date: Wed, 9 Apr 2008 14:44:19 +0100
From: Hemant Verma <Hemant.Verma at ons.gsi.gov.uk>
Subject: Error on connecting database using Perl
To: london.pm at london.pm.org, birmingham-pm at pm.org
Message-ID:
<OF666C9699.72786220-ON80257426.004AFED6-80257426.004
B7820 at ons.gsi.gov.uk>
Content-Type: text/plain; charset="us-ascii"
Hi,
I have a cgi script which tries to connect to oracle 92 database using
ODBC.
On running this cgi script through internet browser it gives an error and
unable to make connection using odbc.
If I run this script in Komodo using Ctrl + R command then it runs
successfully.
My setting are fine as I am able to run simple perl scripts which do not
require any database connection.
I am using c:\perl\bin\perl.exe "%s" %s for .cgi and .pl file type under
properties configuration in IIS server.
Please let me know if I need to make any specific setting.
Thanks & Regards,
Hemant Verma
Steria India
----------------------------------------------------------------
Office for National Statistics, Southampton.
Mob: 07715759776, Direct CUG: 8889776
Ext: 0132-981-3575
For the latest data on the economy and society consult National Statistics
at http://www.statistics.gov.uk
*********************************************************************************
Please Note: Incoming and outgoing email messages are routinely monitored
for compliance with our policy on the use of electronic communications
*********************************************************************************
Legal Disclaimer : Any views expressed by the sender of this message are
not necessarily those of the Office for National Statistics
*********************************************************************************
The original of this email was scanned for viruses by the Government Secure
Intranet virus scanning service supplied by Cable&Wireless in partnership
with MessageLabs. (CCTM Certificate Number 2007/11/0032.) On leaving the
GSi this email was certified virus free.
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.
------------------------------
Message: 2
Date: Wed, 9 Apr 2008 14:47:47 +0100
From: "Ismail, Rafiq \(IT\)" <Rafiq.Ismail at MorganStanley.com>
Subject: HTML reporting for Test::Builder related modules
To: "London.pm Perl M[ou]ngers" <london.pm at london.pm.org>
Message-ID:
<0F354FDFECA12647B75F7B154EC382850B65E528 at LNWEXMB58.msad.ms.com>
Content-Type: text/plain; charset="us-ascii"
I was wondering if anyone knows of any modules which extend/wrap
Test::More, et.al. to render pretty reports in HTML?
Thanks,
Raf
--------------------------------------------------------
NOTICE: If received in error, please destroy and notify sender. Sender does
not intend to waive confidentiality or privilege. Use of this email is
prohibited when received in error.
------------------------------
Message: 3
Date: Wed, 9 Apr 2008 15:01:16 +0100
From: David Cantrell <david at cantrell.org.uk>
Subject: [ANNOUNCE] May social
To: london.pm-announce at london.pm.org
Message-ID: <20080409140115.GA754 at bytemark.barnyard.co.uk>
Content-Type: text/plain; charset=us-ascii
This year, May is the only chance that the evil heretics get to tempt
you into sin and depravity by messing with the calendar. The correct
date and place etc for the social, no matter what Kake The Sinful Pub-
mistress and Greg The Sadly Fallen Into Error will tell you, is:
the date: May the 1st
the time: after work
the pub: Bread and Roses
the place: Clapham
the URL:
http://london.randomness.org.uk/wiki.cgi?Bread_And_Roses,_SW4_6DZ
Be there, or lose your immortal souls.
--
David Cantrell | http://www.cantrell.org.uk/david
I don't do .INI, .BAT, or .SYS files. I don't assign apps to files.
I don't configure peripherals or networks before using them. I have
a computer to do all that. I have a Macintosh, not a hobby.
-- Fritz Anderson
------------------------------
Message: 4
Date: Wed, 9 Apr 2008 15:02:02 +0100
From: Kake L Pugh <kake at earth.li>
Subject: [ANNOUNCE] London.pm May meeting - Thursday 8 May 2008
To: london.pm-announce at london.pm.org
Message-ID: <20080409140202.GA22634 at the.earth.li>
Content-Type: text/plain; charset=us-ascii
Hello! As you will have noticed, I'm not Greg. This is not because I've
staged a coup, but because Greg has put me in charge of announcing the
pubmeets as well as booking them. So without further ado...
The May social will be at the Shooting Star, near Liverpool Street Station,
on Thursday 8 May. We have the function room in the basement all to
ourselves.
Maps, more info, etc:
http://london.randomness.org.uk/wiki.cgi?Shooting_Star,_E1_7JF
Standard blurb:
Social meets are a chance for the various members of the group to meet
up face to face and chat with each other about things - both Perl and
non Perl - and newcomers are more than welcome. The monthly meets tend to
be bigger than the other ad hoc meetings that take place at other times
and we make sure that they're in easy to get to locations and the pub
serves food (meaning that people can eat in the bar if they want to.)
They normally start around 6.30pm (or whenever people get there after
work) and a group tends to be left come closing time.
If you're a new comer or other first timer (even if you've been lurking
on the mailing list or on IRC) then please seek Greg out - we have a
tradition that the leader of this motley crew buys the new people a
drink (alcoholic or not, either's fine) and introduces them to people.
------------------------------
Message: 5
Date: Wed, 09 Apr 2008 15:09:16 +0100
From: Dave Cross <dave at dave.org.uk>
Subject: Re: HTML reporting for Test::Builder related modules
To: london.pm at london.pm.org
Message-ID: <20080409150916.xinlhodts080g0oo at webmail.mag-sol.com>
Content-Type: text/plain; charset=ISO-8859-1;
DelSp="Yes";
format="flowed"
Quoting "Ismail, Rafiq \(IT\)" <Rafiq.Ismail at MorganStanley.com>:
> I was wondering if anyone knows of any modules which extend/wrap
> Test::More, et.al. to render pretty reports in HTML?
How about Test::TAP::HTMLMatrix?
http://search.cpan.org/dist/Test-TAP-HTMLMatrix/
Dave...
------------------------------
Message: 6
Date: Wed, 09 Apr 2008 15:23:11 +0100
From: Jonathan Stowe <jns at gellyfish.com>
Subject: Re: Error on connecting database using Perl
To: "London.pm Perl M[ou]ngers" <london.pm at london.pm.org>
Cc: birmingham-pm at pm.org
Message-ID: <1207750991.6594.33.camel at coriolanus>
Content-Type: text/plain
Hi,
On Wed, 2008-04-09 at 14:44 +0100, Hemant Verma wrote:
>
>
> london.pm at london.pm.org,
> birmingham-pm at pm.org
Please don't cross post questions like this.
If you have a technical question and want to reach the widest possible
audience please use perlmonks or comp.lang.perl.misc
/J\
------------------------------
Message: 7
Date: Wed, 9 Apr 2008 07:36:39 -0700 (PDT)
From: Ovid <publiustemp-londonpm at yahoo.com>
Subject: Re: Error on connecting database using Perl
To: "London.pm Perl M\[ou\]ngers" <london.pm at london.pm.org>,
birmingham-pm at pm.org
Message-ID: <885590.88451.qm at web65711.mail.ac4.yahoo.com>
Content-Type: text/plain; charset=iso-8859-1
--- Hemant Verma <Hemant.Verma at ons.gsi.gov.uk> wrote:
> Hi,
>
> I have a cgi script which tries to connect to oracle 92 database
> using
> ODBC.
> On running this cgi script through internet browser it gives an error
> and unable to make connection using odbc.
What's the error? Tough to comment without that :)
If you are unsure of the error, it would help if you could show us the
relevant entry from your error logs. Failing that, try *temporarily*
adding the following to your CGI program:
use CGI::Carp qw/fatalsToBrowser/;
That will usually (not always) display the actual error message in the
browser. However, you will want to remove that for production. If
people see the error messages they, they may get enough information to
use that to try to hack into your box.
Cheers,
Ovid
--
Buy the book - http://www.oreilly.com/catalog/perlhks/
Perl and CGI - http://users.easystreet.com/ovid/cgi_course/
Personal blog - http://publius-ovidius.livejournal.com/
Tech blog - http://use.perl.org/~Ovid/journal/
------------------------------
Message: 8
Date: Wed, 9 Apr 2008 16:13:53 +0100
From: "Ismail, Rafiq \(IT\)" <Rafiq.Ismail at MorganStanley.com>
Subject: RE: HTML reporting for Test::Builder related modules
To: "London.pm Perl M[ou]ngers" <london.pm at london.pm.org>
Message-ID:
<0F354FDFECA12647B75F7B154EC382850B65E59F at LNWEXMB58.msad.ms.com>
Content-Type: text/plain; charset="us-ascii"
Many Thanks! Looks good.
Cheers,
R.
> -----Original Message-----
> From: london.pm-bounces at london.pm.org
> [mailto:london.pm-bounces at london.pm.org] On Behalf Of Dave Cross
> Sent: 09 April 2008 15:09
> To: london.pm at london.pm.org
> Subject: Re: HTML reporting for Test::Builder related modules
>
> Quoting "Ismail, Rafiq \(IT\)" <Rafiq.Ismail at MorganStanley.com>:
>
> > I was wondering if anyone knows of any modules which extend/wrap
> > Test::More, et.al. to render pretty reports in HTML?
>
> How about Test::TAP::HTMLMatrix?
>
> http://search.cpan.org/dist/Test-TAP-HTMLMatrix/
>
> Dave...
>
--------------------------------------------------------
NOTICE: If received in error, please destroy and notify sender. Sender does
not intend to waive confidentiality or privilege. Use of this email is
prohibited when received in error.
------------------------------
Message: 9
Date: Wed, 9 Apr 2008 17:21:40 +0100
From: Nicholas Clark <nick at ccl4.org>
Subject: Re: [ANNOUNCE] May social
To: london.pm at london.pm.org
Message-ID: <20080409162140.GL9809 at plum.flirble.org>
Content-Type: text/plain; charset=us-ascii
On Wed, Apr 09, 2008 at 03:01:16PM +0100, David Cantrell wrote:
> This year, May is the only chance that the evil heretics get to tempt
> you into sin and depravity by messing with the calendar. The correct
Next year is far more sinful, getting off to a great start with Thursday
8th
January!
> date and place etc for the social, no matter what Kake The Sinful Pub-
> mistress and Greg The Sadly Fallen Into Error will tell you, is:
>
> the date: May the 1st
> the time: after work
Daves, Ladies or Gentlemen of leisure should not claim that "after work" is
an undefined time for them and thus an excuse not to attend. Work, being
the
curse of the drinking classes, is merely an excuse for everyone else not to
be there at 11am.
> the URL:
http://london.randomness.org.uk/wiki.cgi?Bread_And_Roses,_SW4_6DZ
>
> Be there, or lose your immortal souls.
But on the other hand, be careful lest you lose your mortal body on the
"interesting" tube stations:
http://flickr.com/photos/ollycourtney/232075853/
http://flickr.com/photos/paulsmith/60836329/
(only zone 2. The Royal Oak was also zone 2 on the Northern Line, and lots
of
people came to that*)
Nicholas Clark
* Creative misinformation - it was also only 10 minutes walk from a zone 1
station.
------------------------------
Message: 10
Date: Wed, 9 Apr 2008 17:34:58 +0100
From: Peter Corlett <abuse at cabal.org.uk>
Subject: Re: [ANNOUNCE] May social
To: "London.pm Perl M[ou]ngers" <london.pm at london.pm.org>
Message-ID: <20080409163458.GA18748 at cabal.org.uk>
Content-Type: text/plain; charset=us-ascii
On Wed, Apr 09, 2008 at 05:21:40PM +0100, Nicholas Clark wrote:
[...]
> (only zone 2. The Royal Oak was also zone 2 on the Northern Line, and
lots
> of people came to that*)
I've been mostly unsuccessful in proposing the Sloaney Pony on Parsons
Green. It's seven minutes from Zone 1. They have an upstairs room which we
can have if we drink at least GBP250 of booze, thus avoiding the sloanes.
They have Golden Pride. What is there not to like?
------------------------------
_______________________________________________
london.pm mailing list
london.pm at london.pm.org
http://london.pm.org/mailman/listinfo/london.pm
End of london.pm Digest, Vol 30, Issue 38
*****************************************
This email was received from the INTERNET and scanned by the Government
Secure Intranet anti-virus service supplied by Cable&Wireless in
partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) In
case of problems, please call your organisation’s IT Helpdesk.
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.
The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) On leaving the GSi this email was certified virus free.
Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.
More information about the london.pm
mailing list