Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: Accessing Microsoft Access Databases

by Fastolfe (Vicar)
on Nov 09, 2000 at 21:00 UTC ( #40742=note: print w/replies, xml ) Need Help??


in reply to Accessing Microsoft Access Databases

All the DBI module does (in this context) is send SQL queries to the server. If your SQL server is capable of activating stored procedures/queries via SQL, then yah, just send that SQL as part of your DBI request. I'm afraid I'm not very fluent with Access, but I'm sure your Access documentation will show you how to do this via SQL/ODBC. Perhaps another poster can elaborate further if they know, but otherwise, consult your Access docs. Hope this helps.
$sth = $dbh->prepare('SELECT * FROM STORED_PROCEDURE WHERE ID=?') or d +ie "prepare: $!"; $sth->execute($id); ...

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others romping around the Monastery: (6)
As of 2023-12-02 01:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What's your preferred 'use VERSION' for new CPAN modules in 2023?











    Results (13 votes). Check out past polls.

    Notices?