using ppm from behind a firewall

Hi, Earlier, I had to set 3 environment variables (HTTP_proxy, HTTP_proxy_user, and HTTP_proxy_pass) and I could access the ActiveState repository at the office through a proxy server. Of late,however, these 3 environment variables didn't seem to help. So I deleted all of them and set a new environ

Re: problems in installing DBD-Oracle for ActiveState Perl 5.8.8 build 822 through ppm

is the name of my script and the line at which it is choking is the DBI connect line. jagdish eashwar On 8/20/07, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote: > > Send Perl-Win32-Users mailing list submissions to > perl-win32-users@listserv.ActiveState.com > > To s

problems in installing dbd-oracle through ppm

hi, I downloaded ActiveState Perl today. Thereafter, I could install dbd-mysql using ppm. But when I tried to install dbd-oracle, I kept getting the error "| invalid switch", and then ppm would end abruptly. Is this something that has to be corrected at the ActiveState end? jagdi

Re: trouble connecting to Oracle (Dan Jablonsky)

Hi Jablonsky, Try : $dbh=DBI->connect ('dbi:Oracle:host=192.168.55.116;sid=ORCL;port=1521','testusr','testpwd') || die "Database connection not made: $DBI::errstr"; Just a long shot. That syntax works for me. ja

Re: Perl-Win32-Users Digest, Vol 11, Issue 10

Hi, I got an idea after your suggestion that I should explore the Text::Wrap module. If I can get perl to split the string after every so many characters, I'll have achieved what I want. Is that possible? jagdish eashwar On 6/20/07, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote:

control characters in perl

Hi, Do word processors insert any character for word wraps like they do for new lines(\n)? If yes, what is the corresponding perl control character? I need to split a multi line string from a word table cell at the word wraps. jagdish eashwar ___ Perl

updating a mysql table from an oracle table through perl dbi

isconnect(); If I use $dbh1 in the 'do' statement, it says that the jag.names table doesn't exist. If I use $dbh2 in the 'do' statement, it says that the sush.family_mastertable doesn't exist. How can I reference the two tables from two different database handles in the same sta

problem with printing messages to the screen

the messages are put out at the same time after the file is processed. If I put a \n at the end of the first message, the messages are output one by one with the requisite time lag in between, but the " Done" comes on the next line. How can I get Perl to put

Win32::OLE - filtering out ms word formatting characters

Hi, I am attempting to transfer data from a word table to Excel using Win32::OLE. I am able to do it with the following piece of code, but I am getting two little boxes after the text in each of the Excel cells. I presume these are Word formatting characters. How can I filter these out? I am usin

PDK - 7

ry or dll isn't installed where expected at ora2xl.plx line 14 I then modified the script to pick up the current_date from MySql. The corresponding .exe works without complaining on other PCs too. Which dll do I have to add in the case of the Oracle scri

Re: win32::ole can't call method select on an undefined value

Hi, I don't know if this is of much help, but your code is working for me after I include the usual incantations for loading WIN32::OLE at the top. jagdish eashwar ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.c

Re: OLE : transferring data from Oracle to Excel

Trosper <[EMAIL PROTECTED]> wrote: I found this link http://www.perlmonks.org/?node_id=153486 to be very useful for working with Excel spreadsheets. Thans to cacharbe from perlmonks for posting it. Gary Trosper RTSC *"jagdish eashwar" <[EMAIL PROTECTED]>* Sent by: [EMAIL

OLE : transferring data from Oracle to Excel

name in a macro on one of the worksheet objects, I get an error if the named cell is not on the same worksheet. But if I put the same piece of code in a macro in the ThisWorkbook object, it works fine. So what I need is the Perl Win32::OLE syntax for addressing the w

RE: OLE : Unable to pick up value of Excel cell if Mround function used

instance of Excel instead of starting a new one, I am able to pick up values even from cells in which the mround function has been used. That solves my immediate problem, but I still wonder why the Analysis Toolpak add-in is not getting activated when I use a new instance of Excel. Jagdish

RE: OLE : Unable to pick up value of Excel cell if Mround function used

in the new location because the original cell now temporarily has "###" as its value. I think we need some way to activate the Analysis Toolpak add-in when we access Excel through Perl. Jagdish Eashwar Quoting Phil Rafferty <[EMAIL PROTECTED]>: > -Original Message

OLE : Unable to pick up value of Excel cell if Mround function used

2::OLE invoke the Analysis Toolpak addin? Jagdish Eashwar ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Re: OLE - GETTING EXCEL CELL NAMES

Hi Bill, It worked! Your suggestion worked! Thank you very much. But I don't understand why the syntax has to be different for the cell name. Maybe I'll come to know as I go along. Thanks so much. jagdish eashwar Quoting $Bill Luebkert <[EMAIL PROTECTED]>: > jagdish eashw

OLE - GETTING EXCEL CELL NAMES

As('myworkbook'); print "My workbook name is $Book->{Name}\n"; print "My worksheet name is $Sheet->{Name}\n"; print "My cell name is $cell->{Name}\n"; $Book->Save; #End of script The output I am getting is :