Hi : Thanks a bunch. For the first module, I would do - install dbi For the second module for the Open DB Connectivity , will I do something similar like this ? - install dbd::odbc "need to create an ODBC data source referring to the database file" - could you please explain this ? does it mean creating a db and populating tables? I appreciate all the help I get from this discussion group. Kamali
>>> "David Gray" <[EMAIL PROTECTED]> 04/19/02 08:39AM >>> > I would like to know what all needs to be done to connect to > a Microsoft Access database using perl script. 1) You need two modules: DBI and DBD::ODBC 2) You need to create an ODBC data source referring to the database file. 3) Connect to the database like this: $dbh = DBI->connect("DBI:ODBC:$DSN_NAME") or die "Couldn't connect to $DSN_NAME: $DBI::errstr\n\n"; # where $DSN_NAME is the name of the ODBC data source # you created in step 2 > 1.way I can't install dbi when I am offline? Because ppm needs a net connection so it can download the module for you > 2.Can I connect cgi with Microsoft access database " *.mdb " > and how to configure those relationship? See above > 3. Can I use Microsoft access database " *.mdb " on servers where is > supported mysql? A quick google search turned up: <http://www.google.com/search?hl=en&q=mdb+mysql+import> > 4.How can I reply on messages because I don't see button "reply"?? What mail client do you use? -dave -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]