Re: RE: PERL script - access Sybase DB

Thu, 13 Jan 2005 02:46:43 -0800

Satish,
This error is typical if you are running PPM inside a company Intranet, i.e. behind
a firewall. There are two problems to fix-

The first is fairly easy, you need to tell PPM to use your corporate proxy server.
Unfortunately I am not connected to my intranet setup at the moment and I can't
remember the exact config commands, but basically you set up a shell environment
varaible to tell PPM the name of your proxy server (this would be the same proxy
user by your web browser). Check the ActivePerl docs for the correct setup info.

Having done this you may still find you get an error saying something along the lines
of "cannot resolve hostname ppm.ActiveState.com". This is because your intranet
DNS servers will not resolve external host names. This is a pain, and so far I
have not found a nice solution. The clunky workaround I came up with when faced
with this involved manually resolving the IP address of the Activestate server, then
adding a new Repository to PPM using the IP address instead of the hostname. This
will of course break if ActiveState move the repository server to a new address at
any point.

(Note- If anyone has a cleaner solution for this i'd like to hear it).

If you hit this once you've solved your proxy setup post to the list again and I
will dig out my in-office configuration and send it to you.

Regards: Colin

Message: 1
Date: Wed, 12 Jan 2005 16:05:17 +0530
From: "Mulley, Nikhil" <[EMAIL PROTECTED]>
Subject: RE: PERL script - access Sybase DB
To: "Waghmare, Satish \(IE03x\)" <[EMAIL PROTECTED]>,
        <[EMAIL PROTECTED]>
Cc: activeperl@listserv.ActiveState.com
Message-ID:
        <[EMAIL PROTECTED]>
        
Content-Type: text/plain; charset="iso-8859-1"

set the repository to this if the error agains ActiveState Package Repository: http://ppm.ActiveState.com/cgibin/PPM/ppmserver.pl?urn:/PPMServer
by command set rep ActiveState http://ppm.ActiveState.com/cgibin/PPM/ppmserver.pl?urn:/PPMServer

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Waghmare, Satish 
(IE03x)
Sent: Wednesday, January 12, 2005 3:52 PM
To: Waghmare, Satish (IE03x); [EMAIL PROTECTED]
Cc: activeperl@listserv.ActiveState.com
Subject: RE: PERL script - access Sybase DB


How do I install DBI package. I'm getting an error: Please help me to know 
about about how install perl packages and make use of it in script.

Thanks!!

~Satish

Error:

C:\Perl\bin>ppm
PPM - Programmer's Package Manager version 3.1.
Copyright (c) 2001 ActiveState SRL. All Rights Reserved.

Entering interactive shell. Using Term::ReadLine::Stub as readline library.

Type 'help' to get started.

ppm> install dbi
Error: No valid repositories:
Error: 500 Can't connect to ppm.ActiveState.com:80 (connect: Unknown error)
Error: 500 Can't connect to ppm.ActiveState.com:80 (connect: Unknown error)
ppm>



-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Waghmare, Satish 
(IE03x)
Sent: Tuesday, January 11, 2005 9:45 PM
To: [EMAIL PROTECTED]
Cc: activeperl@listserv.ActiveState.com
Subject: PERL script - access Sybase DB



Hi Gurus:

I want to know about how to access 'Sybase' database from PERL script. I never done any database scripting in PERL.My knowledge in PERL is very limited, I only know file handling, I/O handling.
I Kindly please let me know detailed explaination with sample scipt to do so.
Looking forward to your valuable inputs and expecting help.

Thank You,

Best Regards
~Satish









-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
http://ASPN.ActiveState.com/ASPN/Mail/Browse/Threaded/activeperl/attachments/20050112/4107ee9a/attachment-0001.htm

------------------------------

Message: 2
Date: Wed, 12 Jan 2005 09:18:47 -0400
From: "Rene Morales D." <[EMAIL PROTECTED]>
Subject: Re: PERL script - access Sybase DB
To: <activeperl@listserv.ActiveState.com>
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain;       charset="iso-8859-1"

why dont you try SybPerl?

use Sybase::DBlib;

  $sqlits="select * from baseD..myTable";
   &forSybase($sqlits);
   while($dbh->dbresults != NO_MORE_RESULTS) {
   while(@data = $dbh->dbnextrow){
    ... # do what you want whit the Array returned (@data)
   }
   }

sub forSybase {
my $user="user";
my $pwd="password";
my $server="server";
my $baseD="myBD";
$dbh = new Sybase::DBlib $user, $pwd, $server, $baseD;
$dbh->dbcmd($sqlits);
$dbh->dbsqlexec;
}

----- Original Message -----
From: "Waghmare, Satish (IE03x)" <[EMAIL PROTECTED]>
To: "Waghmare, Satish (IE03x)" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Cc: <activeperl@listserv.ActiveState.com>
Sent: Wednesday, January 12, 2005 6:22 AM
Subject: RE: PERL script - access Sybase DB




How do I install DBI package. I'm getting an error: Please help me to know
about about how install perl packages and make use of it in script.

Thanks!!

~Satish

Error:

C:\Perl\bin>ppm
PPM - Programmer's Package Manager version 3.1.
Copyright (c) 2001 ActiveState SRL. All Rights Reserved.

Entering interactive shell. Using Term::ReadLine::Stub as readline


library.


Type 'help' to get started.

ppm> install dbi
Error: No valid repositories:
Error: 500 Can't connect to ppm.ActiveState.com:80 (connect: Unknown


error)


Error: 500 Can't connect to ppm.ActiveState.com:80 (connect: Unknown


error)


ppm>



-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of


Waghmare,


Satish (IE03x)
Sent: Tuesday, January 11, 2005 9:45 PM
To: [EMAIL PROTECTED]
Cc: activeperl@listserv.ActiveState.com
Subject: PERL script - access Sybase DB



Hi Gurus:

I want to know about how to access 'Sybase' database from PERL script.
I never done any database scripting in PERL.My knowledge in PERL is


very


limited, I only know file handling, I/O handling.
   I Kindly please let me know detailed explaination with sample scipt to
do so.
   Looking forward to your valuable inputs and expecting help.

Thank You,

Best Regards
~Satish














----------------------------------------------------------------------------
----




_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs





------------------------------

_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

End of ActivePerl Digest, Vol 12, Issue 8
*****************************************





_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Reply via email to