ASP / sql server 2000 Application on a Linux Server?

Question

Can a web application made in ASP (not ASP.net) and sql server 2000, run on a Linux / Apache server? If yes how?

Answer 1

Sort answer to that is NO!!!!



Sql Server 2000 can not be installed on a Linux machine you will have to use a virtual environment inside of Linux, install windows, and install sql server. You may as well use a windows machine as the base OS.



You can not install sql server on Linux w/ wine (if I am not mistaken).





RJ

Answer 2

If you have Chillisoft on your linux box then you should be able to run most of the ASP code.



The challenge that you face is connecting the code to the database. SQL Server 2000 will not run on a Linux box and any workarounds really aren't advisable.



You could port the database to MySQL and if the ASP code has been written well, it should be easy to make a few changes to connection strings etc to get the ASP code talking to the MySQL database.



An alternative is that your hosing company may offer shard SQL server hosting on their own Windows boxes. OR you could host the SQL server database elsewhere and connect directly to it using an IP address.



Where you may have difficulties with the ASP code is where 3rd party components have been used for uploading, image manipulation and massmailing etc. These probably won't run on a Linux box.



For a full run down on what does and doesn't work on ChilliSoft check out this page http://info99.sch.bme.hu/asp_dif.html



There are also programmes to automagically convert ASP to PHP which could do the bulk of the work for you and then have a PHP programmer check it all over to make the final tweaks.

Answer 3

There is a piece of software call chili soft that will execute asp on a linux server. I am not sure how well it runs but you can read the article below for more information.



With Chili Soft, you should be able to access data from SQL Server 2000, but you will have a hard time running SQL Server inside Linux since it is compiled for Windows. There is a windows emulator package called Wine that will run many windows applications but I think SQL Server might be a little too complicated for it.

Answer 4

Sort of. You can use the Xen hypervisor to run an instance of Windows of the Linux server, and run the Microsoft propietory applications within that virtual machine.



The only other may would be to port the code to open systems - such as PHP and MySQL.