migrate from asp to php

[kresna]

I want to migrate my site from asp to php, currently mysite using 3 tier architecture : Ms Windows 2000, IIS5, MTS (Microsoft transaction server) and MS SQL 7.

My questions are ?
1. Is php support 3-tier architecture ?
2. Which is better running php with IIS5/win2000 or php with apache/linux ?

Thanks

[edraynham]

Can't answer the first question but...

> 2. Which is better running php with IIS5/win2000 or php with apache/linux ?

PHP is definately run better on an apache/linux system. It is much faster.

[Anon]

I'm sorry i can't help you but i'm trying to do the same as you. I'm working with a Microsoft Access database and i'm trying to know how to connect to the dbase in php, that means how to translate:

<% set connectiondb = Server.CreateObject("ADODB.Connection")
connectiondb.open "DSN=mydbase"

set recordsetdb = Server.CreateObject("ADODB.Recordset")

recordsetdb.open "SELECT * FROM table",connectiondb,0,1,adcmdtext %>

I'think that once i've solved that problem i should find out how to do the rest

Could somebody help me?

[Anon]

You might want to take a look at the "Interfacing with MS Access 97+" article here on PHPBuilder... You can find it at:

http://www.phpbuilder.com/columns/siddarth20000228.php3

That explains everything on how to connect and use an MS Access database with PHP, however, you should migrate to a faster/real database application such as mySQL, MS SQL Server, Oracle, Postgres, etc... They are much faster and have many more features...