Another example: To make a DNS connection with a MS-Access file in PHP with an SQL statement: you can write something like this: $AppPath = $PATH_TRANSLATED; $DbFile = dirname ($AppPath). "\\\VAS lokaal.mdb"; // $file is set to "/etc" $Provider = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$DbFile"; $conn = new COM("ADODB.Connection") or die("Cannot start ADO"); // Microsoft Access connection string. $conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=D:\\Webs\\vakantiepunten.nl\\databases\\VAS lokaal.mdb"); $conn->Open($Provider); // SQL statement to build recordset. $rs = $conn->Execute("SELECT * FROM VpSparen WHERE Status='Live'"); PHP can use ODBC less connections, or use ODBC connections, and is therefore more flexible (because you can move the access file to a different directory). When doing something in ASP you should see something like this: <% Dim rsSparen Set rsSparen = CreateObject("ADODB.RecordSet") SQL = "SELECT VpSparen.*" SQL = SQL & " FROM VpSparen" SQL = SQL & " WHERE SpaarCategorieID=" & Session("SpaarCategorieID") SQL = SQL & " AND Waar = 'SparenLinks' AND Livetot > #" & Now & "# AND Status = 'Live'" SQL = SQL & " ORDER BY Sort" rsSparen.Open SQL, Conn, 2, 3 %> The ASP script looks small doesn't it? And it works fine too (when there's nothing wrong with the ODBC settings), but when you want to move your MS-Access file, you'll receive a message like this: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ASP depends on various external objects, while PHP doesn't. Without ODBC the PHP script still works . . . It is also possible to do some OOP programming in PHP too . . . and it is simple to include them in your PHP file . . . Another great thing is that PHP supports a wide range of databases with MySQL on top.... And last but not least: PHP also uses different libraries and works fine in a Linux environment and in a MS-Windows environment. It is possible to write your own PHP classes too . . . :cool:

I think that ASP is just crap. It’s not as flexible and fast as PHP. In ASP you use an ODBC connection which isn’t always stable. Also, some internet sites based on ASP are not working on anything else but Internet Explorer, which is a bad thing. PHP is an open source, with a worldwide spread community while ASP is just a Microsoft thing and like I told you before: it isn’t as flexible as PHP. In ASP you even have to program form buttons, because everything is an object in ASP. Writing a ‘hello world’ script in PHP is very short :
”; ?> While in ASP the same script would be : <%@ Page Language="C#" Debug="true" %> <% Response.Write("Hello world:

"); %> And it becomes more complicated when using variables etc.