Server choice - platform - database access

[Patten]

Suppose I want to develop an application in ASP...
This application has to run on one server platform, with one OS and one database. So the database and webserver are running on the same box.
However the choice of the server, OS and database has to be as open as possible.
Which constraints do I have to keep in mind?
Can I develop an asp application which can run under aswell Windows, Unix as Linux? Which language is to be used favorable: PERL, PHP, Vbscripting, javascripting,...
Which database connection is the most open to all databases. Is it ADO-OLEDB connection? Or ADO-ODBC? Or something else?

Or should I consider doing something in java since it is platform independent?

 

[sleipnir214]

Are we talking about a web application or a locally-run application here?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[Patten]

A locally run application which may involve to a web application in future.

 

[sleipnir214]

If you are looking for platform agnostic programming languages, stay away from VBScript. It will only run with Win32. VBScript/ASP will only run on Win32 with IIS.

Javascript is limited in its usefulness in that its deliberately sandboxed for security reasons, so there are limits as to what you can do with it.

For database backends, both MySQL and PostgreSQL are platform-agnostic and free.

Any discussion of an OS in the context of a desktop application and platform agnosticism is meaningless.

If you are programming an application to be served from a web server, PHP/Apache is a very good combination. PHP can communicate with either MySQL or PostgresSQL using native communication libraries, so ODBC and all those other acronyms are bypassed.

If you are programming a desktop application that is to be platform agnostic, then I recommend either Perl or C. If the appliation is to use a GUI, then I recommend a platform-agnostic widget set, like Tcl/Tk, with either of those programming languages.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!