I'm using Win32::ODBC to do a bunch of stuff with my Access databases in Win2k Server. However, I'm trying to create a Database (*.mdb) file and SYSTEM Data Source Name (DSN) on the fly from the web using Perl and I've come across some serious problems that have completely stopped me in my tracks. 2 problems I need help with:
1) I have to create a SYSTEM dsn (not a USER dsn) on the 'fly' from the web. Problem is that the web server's account doesn't have administrator priveleges so I can't create ANY dsn. I have to create a SYSTEM dsn so that the database can be modified from the web and the only thing that Win32::ODBC seems to be capable of is creating a USER dsn. And even THAT only works when running the perl script from a command prompt on the server. Anyone know of any way around this?? Any way at all??
2) I can't create a valid dsn (neither USER nor SYSTEM) unless I create a blank database to point the dsn to first. Since I want to create the system database on the 'fly' and the name of the database will come from a web form (the name is unknown ahead of time), I can't create the blank database by hand. Is there a way to create a blank database (*.mdb) file straight from Perl? I tried the open(FILE,$file);close(FILE); approach but it obviously didn't work.
I'm in a world of trouble here! Is there any way to do what I'm trying to do? I don't necessarily have to use Win32::ODBC module to create the dsn and the mdb file. I don't care how I get it done, but I have to have it all done through Perl. I can't do any of this by hand. Any help will be greatly appreciated!