From: "Garry" <[EMAIL PROTECTED]>
> I sure hope I am posting in the right place, the "beginners"
> definitely applies here.
>
> I have a web hosting account and my ISP has the following Perl modules
> installed:
>
> AnyDBM_File,pm
> db_file
> NDBM_File.pm
> ODBM_File.pm
> SDBM_File.pm
> gdbm_file perl5db.pl
>
> They have a statement on their "Using a Database with your web hosting
> site" page which states "web hosting account servers do not include
> direct access to an SQL, Access, or any other preconfigured database".
>
> I would like to take an existing MS Access database, load it onto my
> web hosting file area, and be able to actually interface with it using
> Perl. (is it to obvious I'm just getting started?)
The modules you list cannot give you access to Access :-(
> I have been reading over FAQ's and Tutorials for the last week and
> every time it talks about Access, it also refers to having to register
> with the operating system through ODBC, I can't do this on my web
> hosting account.
You do not need to set up an ODBC DSN on the server, you may use a
DSNless connection:
my $DSN = 'driver=Microsoft Access Driver
(*.mdb);dbq=c:\my\directory\perltest.mdb';
my $dbh = DBI->connect("dbi:ODBC:$DSN", '','')
or die "$DBI::errstr\n";
In either case you'd need DBI and DBD::ODBC for this.
Could you ask them if they would install (or have already installed)
DBI and DBD::CSV or DBD::File?
You could then convert your database to flat files or CSVs on your
side (by a Perl script that would just connect the Access via
DBD::ODBC, the CSVs/Files, and would copy all tables), upload the
files and use them as a database.
Even better option might be DBD::SQLite. That's a "whole" SQL
compatible database in Perl module. It is quicker than
DBD::CSV/DBD::File and the whole database is just one file, just like
Access.
That way you do not have to upload tens of files.
I hope I am making sense here.
Jenda
=========== [EMAIL PROTECTED] == http://Jenda.Krynicky.cz ==========
There is a reason for living. There must be. I've seen it somewhere.
It's just that in the mess on my table ... and in my brain
I can't find it.
--- me
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]