Connect CGI to MS Access

[brad1978]

Hey All,
Does any one have any expertise in connecting cgi to ms access? I am stuck with my current box (solaris) and cannot install mysql on it, so the only database I can use is access. I have done some research but am still confused as to how to connect cgi to ms access, any help would be greatly appreciated!
Cheers

 

[PaulTEG]

DBD::ODBC would be the way to go on a Win32 environment

There's also DB_File, not to mention POSTGRES DB

What's the purpose of the DB, might flat files do the trick?

Paul
------------------------------------
Spend an hour a week on CPAN, helps cure all known programming ailments ;-)

 

[brad1978]

Hi Paul,
I am using flat files for 2 smaller apps but in order to build a bulletin board, wiki and other applications, I don't think flat files will work. From what I have read, DBI may be the way to go but I'm not sure what's involved with DBI.
Cheers

 

[PaulTEG]

why can't you install mysql? or postgres?

Paul
------------------------------------
Spend an hour a week on CPAN, helps cure all known programming ailments ;-)

 

[brad1978]

The higher ups will not allow it to be installed. Access is the ONLY option I have.

 

[feherke]

Hi

And if MySQL and PostgreSQL are not possible, maybe SQLite ? That needs no server application.

Feherke.

http://rootshell.be/~feherke/

 

[brad1978]

Hi feherke,
I can't use SQlite either as it requires an install. I have no access to the server itself (eccept for FTP) and I cannot have anything installed on it. This is why I am looking at connecting to Access. I can build the database and ftp it onto my server. I am just not sure how to connect CGI to Access...

 

[Kirsle]

iirc access works on Windows servers by Windows running a database service. I saw a Perl tutorial somewhere and it instructed me to go somewhere in Control Panel/Administrative Tools and load my access database in there somewhere and then my Perl script would connect to the database similarly to how it would connect to a SQL server.

Or basically, MS Access wasn't like SQLite, there still had to be a database server running that Perl had to connect to and run queries on.

SQLite doesn't use a DB server afaik, it reads the database "dynamically" from a .sql file on the disk. It's like databases in flat text form, but with the benefits of databases.

Cuvou.com | My personal homepage

perl -e '$|=$i=1;print" oo\n<|>\n_|_";x:sleep$|;print"\b",$i++%2?"/":"_";goto x;'

 

[PaulTEG]

fix it, but don't do it right, ... time 4 a new job methinks ...YMMV

bring the boneheads around, it's a challenge, but worthwhile ...

Paul
------------------------------------
Spend an hour a week on CPAN, helps cure all known programming ailments ;-)