You may want to use Dave's Win32::ODBC to programmatically setup/edit your DSN based on a scan of the directory.
Use: File::Find to locate the desired file Win32::ODBC::ConfigDSN to edit the DSN --- At least weekly, I copy the master database to a second machine and rename it with a date in the name so I can tell them apart. I usually have several files on hand at any given time and delete the oldest ones as they start to pile up. This means I have to keep twiddling with the data source to make sure it is accessing a current file. I would like to make the Perl program able to access any of the files by simply browsing the directory and selecting a file name instead of having to create a data source for each different file that it will access. If this is not possible, perhaps the Perl program could create the source, use the file, then remove the source before terminating. I don't (yet) have a clue how to approach this part of the problem. I suppose another solution would be to create the data source with a dummy name then rename or copy the file I wish to use and give it the name referenced by the DSN but that seems inelegant. _______________________________________________ Perl-Win32-Admin mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
