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;
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
| |
For: |
|
Use: |
| & | | & |
| < | | < |
| > | | > |
| [ | | [ |
| ] | | ] |
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.