CGI connection to Access on Sun Solaris server

[Brad78]

Hi all,
I have a website which is hosted on an Sun Solaris box and need to connect
an access database to my site. My host does not have php/mysql running so I
have been told I can use CGI with Access. Looking into this, I can't figure
out how to connect CGI to Access. I know that if I were on a windows server
I could use ODBC to connect to Access with ASP but how do I do this on a Sun
Solaris box? Any help would be greatly appreciated.

 

[Dmitry Akselrod]

Well, it looks like this package will give you the ability to work with MS
Access on a Linux or BSD box. You are getting closer.

http://mdbtools.sourceforge.net/faq.html

One other thing you can do is write some sort of push-pull application. The
way I would do it is use a standard database engine that is accessible from
both nix and windows, such as MySQL or SQLite. You can write two apps, one
windows and one nix. The windows app would just push any updates from
access to your database of search. Your nix app would do whatever CGI
functions you have planned.

dmitry