sql w/ asp iis

[chrismartz]

how can i run an sql server and where can i download the files? I'm running xp pro with iis running....i would like to use sql instead of running access because i'm going to be switching to linux

[buntine]

SQL server will cost you alot.. Its not free. Buy it from your local software store.

If you switch to linux, you wont be able to use ASP or .NET which will almost defeat the purpose of buying MS SQL..

Regards.

[chrismartz]

i'm going to use iASP from HalcyonSoft (http://halcyonsoft.com/whatis.asp) to run asp on linux and then use the mysql that comes w/ linux....i just was wondering how i could start working with sql to do databases

[buntine]

This will not be as secure or stable as ASP on a Windows based server. I have used ChilliASP before and it was terrible.

Also, im not sure if you can even use MS SQL server on Linux.. Most MS products only work on Windows.

Finally, Instant ASP costs several thousand dollars per server.. I hope your willing to pay a hell load of cash..

Regards.

[chrismartz]

i'm using the evaluation version which is free....not sure if it expires....but if i don't like it i guess i'll have to change to php....is that much different than asp?

[buntine]

PHP is quite alot different. Its syntax is inherited from C and its a stand-alone programming language whereas ASP is a collection of objects. Technically.

The evaluation version definetely is temporary. It will only work for a few weeks.. Its pointless.

If you want Linux, you cant run any MS technologies unless your willing to fork out alot of cash.

Regards.

[chrismartz]

that sucks....could i run asp on iis on one computer and run the database through linux on my other computer? asp does use sql databasing right?

[buntine]

asp does use sql databasing right?

What do you mean by that? SQL is a common language which every database can understand.

Why do you want to use Linux anyway?

[chrismartz]

i want to get into understanding linux and i dont want to install mysql on windows and slow my machine down...i want all server scripts to be on my linux server

[chrismartz]

how many users can modify an access database in .asp without taking it down?