2 error_reporting(E_ALL);
3 ini_set('mssql.datetimeconvert',0);
7 print "<h3>mssql</h3>";
8 $db = mssql_connect('JAGUAR\vsdotnet','adodb','natsoft') or die('No Connection');
9 mssql_select_db('northwind',$db);
11 $rs = mssql_query('select getdate() as date',$db);
12 $o = mssql_fetch_row($rs);
14 mssql_free_result($rs);
16 print "<p>Delete</p>"; flush();
17 $rs2 = mssql_query('delete from adoxyz',$db);
18 $p = mssql_num_rows($rs2);
19 mssql_free_result($rs2);
25 include_once('DB.php');
27 print "<h3>PEAR</h3>";
29 $password = 'natsoft';
30 $hostname = 'JAGUAR\vsdotnet';
31 $databasename = 'northwind';
33 $dsn = "mssql://$username:$password@$hostname/$databasename";
34 $conn = DB::connect($dsn);
35 print "date=".$conn->GetOne('select getdate()')."<br>";
36 @$conn->query('create table tester (id integer)');
37 print "<p>Delete</p>"; flush();
38 $rs = $conn->query('delete from tester');
39 print "date=".$conn->GetOne('select getdate()')."<br>";
44 include_once('../adodb.inc.php');
46 print "<h3>ADOdb</h3>";
47 $conn = NewADOConnection('mssql');
48 $conn->Connect('JAGUAR\vsdotnet','adodb','natsoft','northwind');
50 print "date=".$conn->GetOne('select getdate()')."<br>";
51 $conn->Execute('create table tester (id integer)');
52 print "<p>Delete</p>"; flush();
53 $rs = $conn->Execute('delete from tester');
54 print "date=".$conn->GetOne('select getdate()')."<br>";
58 $ACCEPTIP = '127.0.0.1';
60 $remote = $_SERVER["REMOTE_ADDR"];
62 if (!empty($ACCEPTIP))
63 if ($remote != '127.0.0.1' && $remote != $ACCEPTIP)
64 die("Unauthorised client: '$remote'");
67 <a href=tmssql.php?do=tmssql>mssql</a>
68 <a href=tmssql.php?do=tpear>pear</a>
69 <a href=tmssql.php?do=tadodb>adodb</a>
71 if (!empty($_GET['do'])) {