Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

a better solution

by g00n (Hermit)
on Jan 27, 2004 at 04:16 UTC ( #324348=note: print w/replies, xml ) Need Help??

in reply to Re: Flattening Access DB to XML
in thread Flattening Access DB to XML

the above should really only be attempted for those who have nothing to do. the real solution relies on using 'the most excellent', DBD-AD0-2.83 (the current version) and look what we read in the *suprise* README file ....

    $sth = $dbh->ado_open_schema( $QueryType, @Criteria ) or die ...;
the file continues ...

This method can be used to obtain database schema information from the provider. It returns a valid statement handle upon success.

the DBD::ADO perldoc online is here.

so what does this mean? It means that you can now find out the schema programatically for unknown Access databases. I found this by checking installing MSDN, searching on COM and IDBSchemaRowset. In an article, Data Access for the Masses Through OLE DB, Josť A. Blakeley, MSDN. You can get the catalog information through the IDBSchemaRowset interface.

In ADO the connection object supports this interface (OpenSchema). Behind this is a COM explanation. For those interested in this try reading OLE DB for the ODBC Programmer, Michael Pizzo and Jeff Cochran, MSDN.

This means you can query the "... types, tables, triggers, views etc ..." for any given Access database.

I should know all this stuff. The real credit goes to Tim Bunce and Phlip for good documentation. Oh, dont forget TMTOWTDI.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://324348]
[Discipulus]: eh, at the end i cannot compete with brother choroba, i just profited he is at lunch
[pra]: What is the best way to determine if a given string is a valid color?
[Discipulus]: context pra? tk html console naturla language?
[Corion]: Or HTML color like #c0ffee ?
[pra]: Perl/Tk. I want to input a file that will contain color names, but users might not know what names are valid

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (5)
As of 2017-10-17 11:41 GMT
Find Nodes?
    Voting Booth?
    My fridge is mostly full of:

    Results (226 votes). Check out past polls.