hi, i would like to have opinions or an advice before moving my php pages from a windows 2003 server to a Linux (slackware) box, this is my goal:

To have access to my MSSQL database and my MSACCESS database from web pages (i think php its a good option for the user interface)

My question its the folow: What do you recommend me in order to have performance and security, i know linux its natively more secure than windows, but im not sure if have mssql and msaccess access from linux will compromise the database's server stability, or what if its released a freeTDS (i read it here http://odbcrouter.com/FAQfreetds.shtml) or another php bulnerability hole... im not sure probably i feel like unsure

Thanks in advance.

Aldo

Well to begin with, you have to do some migrating. Linux doesn't do mssql, it does mysql, and it doesn't do access. There are some attempts at drivers to read .mdb files for open office, but most seem to be old and don't allow you to write to an .mdb file, just read from it.

So I would start by copying all your data into mysql databases, and bring those across.

Security is both a property of an OS, but also how it is used. If you allow things to work on your linux system with root permissions, and select craptacular passwords, you aren't that much safer. You'd get past the first round of script kiddies attacks, but when round 2 comes around, and sees you have ssh running and allow root to log in through ssh, you'll be hacked. Yes linux tends to be more secure, but if you don't configure things well, it won't be any safer than windows. Choose good passwords, don't run unneeded services, don't allow root access through ssh, and certainly don't run processes like apache or php with more permissions than they need.

Peace,
JimBass

well, i think linux can do mssql using this combo: apache+php+iodbc+FreeTDS (as says the title of this post)
That combo can handle mssql, and mssql can handle msaccess by itself with OPENROWSET and OPENQUERY.
There are more methods, you can have UnixODBC+MSSQL_drivers, or you can have "ODBC ROUTER"+LinuxDriver....

I cannot move my data to other plattaform just because my headquarter sofware its MSsql based.

I think he meant you can't run MS SQLServer on Linux, but there's no reason you can't run it on another box and access it from the Linux box.
Similarly Access, although I'd only use that for the client.

well, excuseme for my misstyping, what i waht to have its a webserver client for the mssql server, and at this point im not sure if choose a windows or a linux box for having the webserver as a client of mssql and msaccess (wich are in 2 separated machines).
In your opinion what can be more handle to maintain secure and in a good performance?
The linux or the windows box? (having in mind that linux machine has envolved many open sofware wich can be more bulnerable but there are many patches too..). Im a newby and im not sure at this point.

Thanks again.

So I think you mean normal desktop clients that pt to Linux-Webserver, with MS SQL & Access servers behind the webserver?

yes i do...