I think you need both DBI and DBD::ODBC. Timothy Johnson <[EMAIL PROTECTED]> wrote in message C0FD5BECE2F0C84EAA97D7300A500D5002581294@SMILEY">news:C0FD5BECE2F0C84EAA97D7300A500D5002581294@SMILEY... > > Oops. I think that was DBD, not DBI. > > -----Original Message----- > From: Timothy Johnson [mailto:[EMAIL PROTECTED]] > Sent: Sunday, April 07, 2002 11:51 AM > To: 'Dan '; [EMAIL PROTECTED] > Subject: RE: Microsoft Access/Running program as a service on Win2k > > > > To access (no pun intended) the Access database, you might want to look into > Win32::ODBC or one of the DBI modules (I haven't had to use them so I can't > be more specific). You can get Win32::ODBC at http://www.roth.net/perl, or > from the PPM repository at http://www.roth.net/perl/packages. > > As for the second part, what context do you want the script to run under. > You can use Win32::Lanman's NetScheduleAdd() function to add scheduler > entries that will run under the system context. Keep in mind, of course, > that the LocalSystem account cannot access UNC paths, so drives must be > mapped under a user context if you're planning on doing anything over a > network. I haven't had sufficient time to play with them, but there are two > modules specifically for working with the Task Scheduler (NetScheduleAdd > uses or simulates the old AT commands). These are Win32::Scheduler, which > you can get at the PPM archive above, and there is also one on SourceForge > that was working pretty well the last time I saw it. Check out > http://sourceforge.net/projects/taskscheduler/. The advantage of these two > is that they directly interface with the Task Scheduler and allow you to set > the user account under which to run, retrieve exit status, etc. > > -----Original Message----- > From: Dan > To: [EMAIL PROTECTED] > Sent: 4/7/02 7:31 AM > Subject: Microsoft Access/Running program as a service on Win2k > > > Hello all, > > Is it possible to export an Access query on an Access database to a text > file. So what I want to do is connect to an Access database then simply > run an SQl query on the database/table. From there I need the results of > that query to be exported to a comma delimited text file. Has any one > done this before? > > Also I know I can easily create a perl script that will run as a daemon > on a Unix machine, but can I do the same but have my perl script run as > a service on a Windows2000 machine? I need a script to run every > 24hours without any user interaction? Is this possible ? s I am > unfamiliar with what Active Perl/Windows can actually do? > > Regards, > > Dan > > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -------------------------------------------------------------------------- -- > ---- > This email may contain confidential and privileged > material for the sole use of the intended recipient. > If you are not the intended recipient, please contact > the sender and delete all copies. > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -------------------------------------------------------------------------- ------ > This email may contain confidential and privileged > material for the sole use of the intended recipient. > If you are not the intended recipient, please contact > the sender and delete all copies.
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
