Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: Handling pictures with DBI and Access

by zebedee (Pilgrim)
on Jul 26, 2001 at 12:06 UTC ( #99914=note: print w/replies, xml ) Need Help??


in reply to Handling pictures with DBI and Access

Using ADO seems easier than using DAO/Jet. Here is a bit that reads a database (never got as far as looking at writing, let alone writing a blob, so might not help much).
#Using ADO from PERL use Win32::OLE; my $Conn=Win32::OLE->new('ADODB.Connection') or die "Unable to create +ADODB.Connection"; #NB.You will need to set up the DSN in the ODBC Data Manager (Control +Panel) # MUST be done on the System DSN tab, you may to enter user name an +d password #Don't or die on these methods - it dies every time! $Conn->Open("<db name in Data Manager>","<optional userid>","<optional + password>"); $RS=$Conn->Execute("SELECT * FROM <table>"); $RS->MoveFirst(); until ($RS->Eof()) { print $RS->Fields->{'Name'}->Value,"\n"; $RS->MoveNext(); } $RS->Close; $Conn->Close;

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (2)
As of 2021-09-24 05:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?