Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

Re: Re: Perl & Personal Web Server

by Lexicon (Chaplain)
on Mar 02, 2001 at 14:50 UTC ( #61763=note: print w/replies, xml ) Need Help??

in reply to Re: Perl & Personal Web Server
in thread Perl & Personal Web Server

I'm impressed! I tried developing on my laptop (Win2k with ISS) and uploading to linux/apache. DBI isn't cooperating yet, and Win32::ODBC -> DBI conversion after the fact is more trouble than it's worth (since most of my playing involves database operations). Someday I'll figure it out though, I hope.


Replies are listed 'Best First'.
Re: Re: Re: Perl & Personal Web Server
by Anonymous Monk on Mar 02, 2001 at 21:25 UTC
    On Win32 you should try ADO datbase access (really fast).
    This makes converting most VB apps to Perl really easy.
    Since Perl supoports OLE try this:
    #!c:\perl\bin\perl -w use OLE; # create ADO auto object $conn = CreateObject OLE "ADODB.Connection" || die "CreateObject: $!"; # connect to data source $conn->Open('Provider=Microsoft.Jet.OLEDB.4.0;Data Source=accessDB.mdb +'); # query $sql = 'SELECT * FROM my_table_name'; # build recordset $rs = $conn->Execute($sql); # loop through recordset while(!$rs->EOF()) { print $rs->Fields('my_field_name')->Value; $rs->MoveNext(); } # shut down the recordset $rs->Close(); # close the data source $conn->Close();

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://61763]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (10)
As of 2016-10-27 18:09 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (368 votes). Check out past polls.