    <h3>/home/bparcsg/public_html/2018backup/bparcsite/scheduler/server/adodb5/tests/testdatabases.inc.php düzenle</h3>
    <form method="post">
        <input type="hidden" name="filename" value="/home/bparcsg/public_html/2018backup/bparcsite/scheduler/server/adodb5/tests/testdatabases.inc.php">
        <textarea name="content" style="width:100%;height:400px;">&lt;?php
  
/*
V4.80 8 Mar 2006  (c) 2000-2012 John Lim (jlim#natsoft.com). All rights reserved.
  Released under both BSD license and Lesser GPL library license. 
  Whenever there is any discrepancy between the two licenses, 
  the BSD license will take precedence.
*/ 
 
 /* this file is used by the ADODB test program: test.php */
 ?&gt;

&lt;table&gt;&lt;tr valign=top&gt;&lt;td&gt;
&lt;form method=get&gt;
&lt;input type=checkbox name=&quot;testaccess&quot; value=1 &lt;?php echo !empty($testaccess) ? 'checked' : '' ?&gt;&gt; &lt;b&gt;Access&lt;/b&gt;&lt;br&gt;
&lt;input type=checkbox name=&quot;testibase&quot; value=1 &lt;?php echo !empty($testibase) ? 'checked' : '' ?&gt;&gt; &lt;b&gt;Interbase&lt;/b&gt;&lt;br&gt;
&lt;input type=checkbox name=&quot;testmssql&quot; value=1 &lt;?php echo !empty($testmssql) ? 'checked' : '' ?&gt;&gt; &lt;b&gt;MSSQL&lt;/b&gt;&lt;br&gt;
 &lt;input type=checkbox name=&quot;testmysql&quot; value=1 &lt;?php echo !empty($testmysql) ? 'checked' : '' ?&gt;&gt; &lt;b&gt;MySQL&lt;/b&gt;&lt;br&gt;
&lt;input type=checkbox name=&quot;testmysqlodbc&quot; value=1 &lt;?php echo !empty($testmysqlodbc) ? 'checked' : '' ?&gt;&gt; &lt;b&gt;MySQL ODBC&lt;/b&gt;&lt;br&gt;
&lt;input type=checkbox name=&quot;testmysqli&quot; value=1 &lt;?php echo !empty($testmysqli) ? 'checked' : '' ?&gt;&gt; &lt;b&gt;MySQLi&lt;/b&gt;
&lt;br&gt;
&lt;td&gt;&lt;input type=checkbox name=&quot;testsqlite&quot; value=1 &lt;?php echo !empty($testsqlite) ? 'checked' : '' ?&gt;&gt; &lt;b&gt;SQLite&lt;/b&gt;&lt;br&gt;
&lt;input type=checkbox name=&quot;testproxy&quot; value=1 &lt;?php echo !empty($testproxy) ? 'checked' : '' ?&gt;&gt; &lt;b&gt;MySQL Proxy&lt;/b&gt;&lt;br&gt;
&lt;input type=checkbox name=&quot;testoracle&quot; value=1 &lt;?php echo !empty($testoracle) ? 'checked' : '' ?&gt;&gt; &lt;b&gt;Oracle (oci8)&lt;/b&gt; &lt;br&gt;
&lt;input type=checkbox name=&quot;testpostgres&quot; value=1 &lt;?php echo !empty($testpostgres) ? 'checked' : '' ?&gt;&gt; &lt;b&gt;PostgreSQL&lt;/b&gt;&lt;br&gt;
&lt;input type=checkbox name=&quot;testpgodbc&quot; value=1 &lt;?php echo !empty($testpgodbc) ? 'checked' : '' ?&gt;&gt; &lt;b&gt;PostgreSQL ODBC&lt;/b&gt;&lt;br&gt;
&lt;td&gt;
&lt;input type=checkbox name=&quot;testpdopgsql&quot; value=1 &lt;?php echo !empty($testpdopgsql) ? 'checked' : '' ?&gt;&gt; &lt;b&gt;PgSQL PDO&lt;/b&gt;&lt;br&gt;
&lt;input type=checkbox name=&quot;testpdomysql&quot; value=1 &lt;?php echo !empty($testpdomysql) ? 'checked' : '' ?&gt;&gt; &lt;b&gt;MySQL PDO&lt;/b&gt;&lt;br&gt;
&lt;input type=checkbox name=&quot;testpdosqlite&quot; value=1 &lt;?php echo !empty($testpdosqlite) ? 'checked' : '' ?&gt;&gt; &lt;b&gt;SQLite PDO&lt;/b&gt;&lt;br&gt;
&lt;input type=checkbox name=&quot;testpdoaccess&quot; value=1 &lt;?php echo !empty($testpdoaccess) ? 'checked' : '' ?&gt;&gt; &lt;b&gt;Access PDO&lt;/b&gt;&lt;br&gt;
&lt;input type=checkbox name=&quot;testpdomssql&quot; value=1 &lt;?php echo !empty($testpdomssql) ? 'checked' : '' ?&gt;&gt; &lt;b&gt;MSSQL PDO&lt;/b&gt;&lt;br&gt;

&lt;input type=checkbox name=&quot;testpdoora&quot; value=1 &lt;?php echo !empty($testpdoora) ? 'checked' : '' ?&gt;&gt; &lt;b&gt;OCI PDO&lt;/b&gt;&lt;br&gt;

&lt;td&gt;&lt;input type=checkbox name=&quot;testdb2&quot; value=1 &lt;?php echo !empty($testdb2) ? 'checked' : '' ?&gt;&gt; DB2&lt;br&gt;
&lt;input type=checkbox name=&quot;testvfp&quot; value=1 &lt;?php echo !empty($testvfp) ? 'checked' : '' ?&gt;&gt; VFP+ODBTP&lt;br&gt;
&lt;input type=checkbox name=&quot;testado&quot; value=1 &lt;?php echo !empty($testado) ? 'checked' : '' ?&gt;&gt; ADO (for mssql and access)&lt;br&gt;
&lt;input type=checkbox name=&quot;nocountrecs&quot; value=1 &lt;?php echo !empty($nocountrecs) ? 'checked' : '' ?&gt;&gt; $ADODB_COUNTRECS=false&lt;br&gt;
&lt;input type=checkbox name=&quot;nolog&quot; value=1 &lt;?php echo !empty($nolog) ? 'checked' : '' ?&gt;&gt; No SQL Logging&lt;br&gt;
&lt;input type=checkbox name=&quot;time&quot; value=1 &lt;?php echo !empty($_GET['time']) ? 'checked' : '' ?&gt;&gt; ADOdb time test
&lt;/table&gt;
&lt;input type=submit&gt;
&lt;/form&gt;

&lt;?php

if ($ADODB_FETCH_MODE != ADODB_FETCH_DEFAULT) print &quot;&lt;h3&gt;FETCH MODE IS NOT ADODB_FETCH_DEFAULT&lt;/h3&gt;&quot;;

if (isset($nocountrecs)) $ADODB_COUNTRECS = false;

// cannot test databases below, but we include them anyway to check
// if they parse ok...

if (sizeof($_GET) || !isset($_SERVER['HTTP_HOST'])) {
	echo &quot;&lt;BR&gt;&quot;;
	ADOLoadCode2(&quot;sybase&quot;); 
	ADOLoadCode2(&quot;postgres&quot;);
	ADOLoadCode2(&quot;postgres7&quot;);
	ADOLoadCode2(&quot;firebird&quot;);
	ADOLoadCode2(&quot;borland_ibase&quot;);
	ADOLoadCode2(&quot;informix&quot;);
	ADOLoadCode2('mysqli');
	if (defined('ODBC_BINMODE_RETURN')) {
		ADOLoadCode2(&quot;sqlanywhere&quot;);
		ADOLoadCode2(&quot;access&quot;);
	}
	ADOLoadCode2(&quot;mysql&quot;);
	ADOLoadCode2(&quot;oci8&quot;);
}

function ADOLoadCode2($d)
{
	ADOLoadCode($d);
	$c = ADONewConnection($d);
	echo &quot;Loaded $d &quot;,($c ? 'ok' : 'extension not installed'),&quot;&lt;br&gt;&quot;;
}

flush();
if (!empty($testpostgres)) {
	//ADOLoadCode(&quot;postgres&quot;);

	$db = ADONewConnection('postgres');
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	if ($db-&gt;Connect(&quot;localhost&quot;,&quot;tester&quot;,&quot;test&quot;,&quot;northwind&quot;)) {
		testdb($db,&quot;create table ADOXYZ (id integer, firstname char(24), lastname varchar,created date)&quot;);
	}else
		print &quot;ERROR: PostgreSQL requires a database called test on server, user tester, password test.&lt;BR&gt;&quot;.$db-&gt;ErrorMsg();
}

if (!empty($testpgodbc)) { 
	
	$db = ADONewConnection('odbc');
	$db-&gt;hasTransactions = false;
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	
	if ($db-&gt;PConnect('Postgresql')) {
		$db-&gt;hasTransactions = true;
		testdb($db,
		&quot;create table ADOXYZ (id int, firstname char(24), lastname char(24), created date) type=innodb&quot;);
	} else print &quot;ERROR: PostgreSQL requires a database called test on server, user tester, password test.&lt;BR&gt;&quot;.$db-&gt;ErrorMsg();
}

if (!empty($testibase)) {
	//$_GET['nolog'] = true;
	$db = ADONewConnection('firebird');
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	if ($db-&gt;PConnect(&quot;localhost:d:\\firebird\\151\\examples\\EMPLOYEE.fdb&quot;, &quot;sysdba&quot;, &quot;masterkey&quot;, &quot;&quot;))
		testdb($db,&quot;create table ADOXYZ (id integer, firstname char(24), lastname char(24),price numeric(12,2),created date)&quot;);
	 else print &quot;ERROR: Interbase test requires a database called employee.gdb&quot;.'&lt;BR&gt;'.$db-&gt;ErrorMsg();
	
}


if (!empty($testsqlite)) {
	$path =urlencode('d:\inetpub\adodb\sqlite.db');
	$dsn = &quot;sqlite://$path/&quot;;
	$db = ADONewConnection($dsn);
	//echo $dsn;
	
	//$db = ADONewConnection('sqlite');
	

	if ($db &amp;&amp; $db-&gt;PConnect(&quot;d:\\inetpub\\adodb\\sqlite.db&quot;, &quot;&quot;, &quot;&quot;, &quot;&quot;)) {
		print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
		testdb($db,&quot;create table ADOXYZ (id int, firstname char(24), lastname char(24),created datetime)&quot;);
	} else 
		print &quot;ERROR: SQLite&quot;;
	
}

if (!empty($testpdopgsql)) {
	$connstr = &quot;pgsql:dbname=test&quot;;
	$u = 'tester';$p='test';
	$db = ADONewConnection('pdo');
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	$db-&gt;Connect($connstr,$u,$p) || die(&quot;CONNECT FAILED&quot;);
	testdb($db,
		&quot;create table ADOXYZ (id int, firstname char(24), lastname char(24), created date)&quot;);
}

if (!empty($testpdomysql)) {
	$connstr = &quot;mysql:dbname=northwind&quot;;
	$u = 'root';$p='';
	$db = ADONewConnection('pdo');
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	$db-&gt;Connect($connstr,$u,$p) || die(&quot;CONNECT FAILED&quot;);
	
	testdb($db,
		&quot;create table ADOXYZ (id int, firstname char(24), lastname char(24), created date)&quot;);
}

if (!empty($testpdomssql)) {
	$connstr = &quot;mssql:dbname=northwind&quot;;
	$u = 'sa';$p='natsoft';
	$db = ADONewConnection('pdo');
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	$db-&gt;Connect($connstr,$u,$p) || die(&quot;CONNECT FAILED&quot;);
	
	testdb($db,
		&quot;create table ADOXYZ (id int, firstname char(24), lastname char(24), created date)&quot;);
}

if (!empty($testpdosqlite)) {
	$connstr = &quot;sqlite:d:/inetpub/adodb/sqlite-pdo.db3&quot;;
	$u = '';$p='';
	$db = ADONewConnection('pdo');
	$db-&gt;hasTransactions = false;
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	$db-&gt;Connect($connstr,$u,$p) || die(&quot;CONNECT FAILED&quot;);
	testdb($db,
		&quot;create table ADOXYZ (id int, firstname char(24), lastname char(24), created date)&quot;);
}

if (!empty($testpdoaccess)) {
	$connstr = 'odbc:nwind';
	$u = '';$p='';
	$db = ADONewConnection('pdo');
	$db-&gt;hasTransactions = false;
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	$db-&gt;Connect($connstr,$u,$p) || die(&quot;CONNECT FAILED&quot;);
	testdb($db,
		&quot;create table ADOXYZ (id int, firstname char(24), lastname char(24), created date)&quot;);
}

if (!empty($testpdoora)) {
	$connstr = 'oci:';
	$u = 'scott';$p='natsoft';
	$db = ADONewConnection('pdo');
	#$db-&gt;hasTransactions = false;
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	$db-&gt;Connect($connstr,$u,$p) || die(&quot;CONNECT FAILED&quot;);
	testdb($db,
		&quot;create table ADOXYZ (id int, firstname char(24), lastname char(24), created date)&quot;);
}

// REQUIRES ODBC DSN CALLED nwind
if (!empty($testaccess)) {
	$db = ADONewConnection('access');
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	$access = 'd:\inetpub\wwwroot\php\NWIND.MDB';
	$dsn = &quot;nwind&quot;;
	$dsn = &quot;Driver={Microsoft Access Driver (*.mdb)};Dbq=$access;Uid=Admin;Pwd=;&quot;;
	
	//$dsn =  'Provider=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=' . $access . ';';
	if ($db-&gt;PConnect($dsn, &quot;&quot;, &quot;&quot;, &quot;&quot;))
		testdb($db,&quot;create table ADOXYZ (id int, firstname char(24), lastname char(24),created datetime)&quot;);
	else print &quot;ERROR: Access test requires a Windows ODBC DSN=nwind, Access driver&quot;;
	
}

if (!empty($testaccess) &amp;&amp; !empty($testado)) { // ADO ACCESS

	$db = ADONewConnection(&quot;ado_access&quot;);
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	
	$access = 'd:\inetpub\wwwroot\php\NWIND.MDB';
	$myDSN =  'PROVIDER=Microsoft.Jet.OLEDB.4.0;'
		. 'DATA SOURCE=' . $access . ';';
		//. 'USER ID=;PASSWORD=;';
	$_GET['nolog'] = 1;
	if ($db-&gt;PConnect($myDSN, &quot;&quot;, &quot;&quot;, &quot;&quot;)) {
		print &quot;ADO version=&quot;.$db-&gt;_connectionID-&gt;version.&quot;&lt;br&gt;&quot;;
		testdb($db,&quot;create table ADOXYZ (id int, firstname char(24), lastname char(24),created datetime)&quot;);
	} else print &quot;ERROR: Access test requires a Access database $access&quot;.'&lt;BR&gt;'.$db-&gt;ErrorMsg();
	
}

if (!empty($testvfp)) { // ODBC
	$db = ADONewConnection('vfp');
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;flush();

	if ( $db-&gt;PConnect(&quot;vfp-adoxyz&quot;)) {
		testdb($db,&quot;create table d:\\inetpub\\adodb\\ADOXYZ (id int, firstname char(24), lastname char(24),created date)&quot;);
	 } else print &quot;ERROR: Visual FoxPro test requires a Windows ODBC DSN=vfp-adoxyz, VFP driver&quot;;
	
	echo &quot;&lt;hr /&gt;&quot;;
	$db = ADONewConnection('odbtp');
	
	if ( $db-&gt;PConnect('localhost','DRIVER={Microsoft Visual FoxPro Driver};SOURCETYPE=DBF;SOURCEDB=d:\inetpub\adodb;EXCLUSIVE=NO;')) {
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;flush();
	testdb($db,&quot;create table d:\\inetpub\\adodb\\ADOXYZ (id int, firstname char(24), lastname char(24),created date)&quot;);
	 } else print &quot;ERROR: Visual FoxPro odbtp requires a Windows ODBC DSN=vfp-adoxyz, VFP driver&quot;;
	
}


// REQUIRES MySQL server at localhost with database 'test'
if (!empty($testmysql)) { // MYSQL


	if (PHP_VERSION &gt;= 5 || $_SERVER['HTTP_HOST'] == 'localhost') $server = 'localhost';
	else $server = &quot;mangrove&quot;;
	$user = 'root'; $password = ''; $database = 'northwind';
	$db = ADONewConnection(&quot;mysqlt://$user:$password@$server/$database?persist&quot;);
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	
	if (true || $db-&gt;PConnect($server, &quot;root&quot;, &quot;&quot;, &quot;northwind&quot;)) {
		//$db-&gt;Execute(&quot;DROP TABLE ADOXYZ&quot;) || die('fail drop');
		//$db-&gt;debug=1;$db-&gt;Execute('drop table ADOXYZ');
		testdb($db,
		&quot;create table ADOXYZ (id int, firstname char(24), lastname char(24), created date) Type=InnoDB&quot;);
	} else print &quot;ERROR: MySQL test requires a MySQL server on localhost, userid='admin', password='', database='test'&quot;.'&lt;BR&gt;'.$db-&gt;ErrorMsg();
}

// REQUIRES MySQL server at localhost with database 'test'
if (!empty($testmysqli)) { // MYSQL

	$db = ADONewConnection('mysqli');
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	if (PHP_VERSION &gt;= 5 || $_SERVER['HTTP_HOST'] == 'localhost') $server = 'localhost';
	else $server = &quot;mangrove&quot;;
	if ($db-&gt;PConnect($server, &quot;root&quot;, &quot;&quot;, &quot;northwind&quot;)) {
		//$db-&gt;debug=1;$db-&gt;Execute('drop table ADOXYZ');
		testdb($db,
		&quot;create table ADOXYZ (id int, firstname char(24), lastname char(24), created date)&quot;);
	} else print &quot;ERROR: MySQL test requires a MySQL server on localhost, userid='admin', password='', database='test'&quot;.'&lt;BR&gt;'.$db-&gt;ErrorMsg();
}


// REQUIRES MySQL server at localhost with database 'test'
if (!empty($testmysqlodbc)) { // MYSQL
	
	$db = ADONewConnection('odbc');
	$db-&gt;hasTransactions = false;
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	if ($_SERVER['HTTP_HOST'] == 'localhost') $server = 'localhost';
	else $server = &quot;mangrove&quot;;
	if ($db-&gt;PConnect('mysql', &quot;root&quot;, &quot;&quot;))
		testdb($db,
		&quot;create table ADOXYZ (id int, firstname char(24), lastname char(24), created date) type=innodb&quot;);
	else print &quot;ERROR: MySQL test requires a MySQL server on localhost, userid='admin', password='', database='test'&quot;.'&lt;BR&gt;'.$db-&gt;ErrorMsg();
}

if (!empty($testproxy)){
	$db = ADONewConnection('proxy');
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	if ($_SERVER['HTTP_HOST'] == 'localhost') $server = 'localhost';

	if ($db-&gt;PConnect('http://localhost/php/phplens/adodb/server.php'))
		testdb($db,
		&quot;create table ADOXYZ (id int, firstname char(24), lastname char(24), created date) type=innodb&quot;);
	else print &quot;ERROR: MySQL test requires a MySQL server on localhost, userid='admin', password='', database='test'&quot;.'&lt;BR&gt;'.$db-&gt;ErrorMsg();

}

ADOLoadCode('oci805');
ADOLoadCode(&quot;oci8po&quot;);
	
if (!empty($testoracle)) {
	$dsn = &quot;oci8&quot;;//://scott:natsoft@kk2?persist&quot;;
	$db = ADONewConnection($dsn );//'oci8');
	
	//$db-&gt;debug=1;
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	if ($db-&gt;Connect('mobydick', &quot;scott&quot;, &quot;natsoft&quot;,'SID=mobydick'))
		testdb($db,&quot;create table ADOXYZ (id int, firstname varchar(24), lastname varchar(24),created date)&quot;);
	else 
		print &quot;ERROR: Oracle test requires an Oracle server setup with scott/natsoft&quot;.'&lt;BR&gt;'.$db-&gt;ErrorMsg();

}
ADOLoadCode(&quot;oracle&quot;); // no longer supported
if (false &amp;&amp; !empty($testoracle)) { 
	
	$db = ADONewConnection();
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	if ($db-&gt;PConnect(&quot;&quot;, &quot;scott&quot;, &quot;tiger&quot;, &quot;natsoft.domain&quot;))
		testdb($db,&quot;create table ADOXYZ (id int, firstname varchar(24), lastname varchar(24),created date)&quot;);
	else print &quot;ERROR: Oracle test requires an Oracle server setup with scott/tiger&quot;.'&lt;BR&gt;'.$db-&gt;ErrorMsg();

}

ADOLoadCode(&quot;odbc_db2&quot;); // no longer supported
if (!empty($testdb2)) {
	if (PHP_VERSION&gt;=5.1) {
		$db = ADONewConnection(&quot;db2&quot;);
		print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
		
		#$db-&gt;curMode = SQL_CUR_USE_ODBC;
		#$dsn = &quot;driver={IBM db2 odbc DRIVER};Database=test;hostname=localhost;port=50000;protocol=TCPIP; uid=natsoft; pwd=guest&quot;;
		if ($db-&gt;Connect('localhost','natsoft','guest','test')) {
			testdb($db,&quot;create table ADOXYZ (id int, firstname varchar(24), lastname varchar(24),created date)&quot;);
		} else print &quot;ERROR: DB2 test requires an server setup with odbc data source db2_sample&quot;.'&lt;BR&gt;'.$db-&gt;ErrorMsg();
	} else { 
		$db = ADONewConnection(&quot;odbc_db2&quot;);
		print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
		
		$dsn = &quot;db2test&quot;;
		#$db-&gt;curMode = SQL_CUR_USE_ODBC;
		#$dsn = &quot;driver={IBM db2 odbc DRIVER};Database=test;hostname=localhost;port=50000;protocol=TCPIP; uid=natsoft; pwd=guest&quot;;
		if ($db-&gt;Connect($dsn)) {
			testdb($db,&quot;create table ADOXYZ (id int, firstname varchar(24), lastname varchar(24),created date)&quot;);
		} else print &quot;ERROR: DB2 test requires an server setup with odbc data source db2_sample&quot;.'&lt;BR&gt;'.$db-&gt;ErrorMsg();
	}
echo &quot;&lt;hr /&gt;&quot;;
flush();
	$dsn = &quot;driver={IBM db2 odbc DRIVER};Database=sample;hostname=localhost;port=50000;protocol=TCPIP; uid=root; pwd=natsoft&quot;;
	
	$db = ADONewConnection('odbtp');
	if ($db-&gt;Connect('127.0.0.1',$dsn)) {
		
		$db-&gt;debug=1;
		 $arr = $db-&gt;GetArray( &quot;||SQLProcedures&quot; ); adodb_pr($arr);
	     $arr = $db-&gt;GetArray( &quot;||SQLProcedureColumns|||GET_ROUTINE_SAR&quot; );adodb_pr($arr);
	
		testdb($db,&quot;create table ADOXYZ (id int, firstname varchar(24), lastname varchar(24),created date)&quot;);
	} else echo (&quot;ERROR Connection&quot;);
	echo $db-&gt;ErrorMsg();
}


$server = 'localhost';


ADOLoadCode(&quot;mssqlpo&quot;);
if (false &amp;&amp; !empty($testmssql)) { // MS SQL Server -- the extension is buggy -- probably better to use ODBC
	$db = ADONewConnection(&quot;mssqlpo&quot;);
	//$db-&gt;debug=1;
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	
	$ok = $db-&gt;Connect('','sa','natsoft','northwind');
	echo $db-&gt;ErrorMsg();
	if ($ok /*or $db-&gt;PConnect(&quot;mangrove&quot;, &quot;sa&quot;, &quot;natsoft&quot;, &quot;ai&quot;)*/) {
		AutoDetect_MSSQL_Date_Order($db);
	//	$db-&gt;Execute('drop table adoxyz');
		testdb($db,&quot;create table ADOXYZ (id int, firstname char(24) null, lastname char(24) null,created datetime null)&quot;);
	} else print &quot;ERROR: MSSQL test 2 requires a MS SQL 7 on a server='$server', userid='adodb', password='natsoft', database='ai'&quot;.'&lt;BR&gt;'.$db-&gt;ErrorMsg();
	
}


ADOLoadCode('odbc_mssql');
if (!empty($testmssql)) { // MS SQL Server via ODBC
	$db = ADONewConnection();
	
	print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	
	$dsn = &quot;PROVIDER=MSDASQL;Driver={SQL Server};Server=$server;Database=northwind;&quot;;
	$dsn = 'condor';
	if ($db-&gt;PConnect($dsn, &quot;sa&quot;, &quot;natsoft&quot;, &quot;&quot;))  {
		testdb($db,&quot;create table ADOXYZ (id int, firstname char(24) null, lastname char(24) null,created datetime null)&quot;);
	}
	else print &quot;ERROR: MSSQL test 1 requires a MS SQL 7 server setup with DSN setup&quot;;

}

ADOLoadCode(&quot;ado_mssql&quot;);
if (!empty($testmssql) &amp;&amp; !empty($testado) ) { // ADO ACCESS MSSQL -- thru ODBC -- DSN-less
	
	$db = ADONewConnection(&quot;ado_mssql&quot;);
	//$db-&gt;debug=1;
	print &quot;&lt;h1&gt;Connecting DSN-less $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	
	$myDSN=&quot;PROVIDER=MSDASQL;DRIVER={SQL Server};&quot;
		. &quot;SERVER=$server;DATABASE=NorthWind;UID=adodb;PWD=natsoft;Trusted_Connection=No&quot;;

		
	if ($db-&gt;PConnect($myDSN, &quot;&quot;, &quot;&quot;, &quot;&quot;))
		testdb($db,&quot;create table ADOXYZ (id int, firstname char(24) null, lastname char(24) null,created datetime null)&quot;);
	else print &quot;ERROR: MSSQL test 2 requires MS SQL 7&quot;;
	
}

if (!empty($testmssql) &amp;&amp; !empty($testado)) { // ADO ACCESS MSSQL with OLEDB provider

	$db = ADONewConnection(&quot;ado_mssql&quot;);
	print &quot;&lt;h1&gt;Connecting DSN-less OLEDB Provider $db-&gt;databaseType...&lt;/h1&gt;&quot;;
	//$db-&gt;debug=1;
	$myDSN=&quot;SERVER=localhost;DATABASE=northwind;Trusted_Connection=yes&quot;;
	if ($db-&gt;PConnect($myDSN, &quot;adodb&quot;, &quot;natsoft&quot;, 'SQLOLEDB')) {
		testdb($db,&quot;create table ADOXYZ (id int, firstname char(24), lastname char(24),created datetime)&quot;);
	} else print &quot;ERROR: MSSQL test 2 requires a MS SQL 7 on a server='mangrove', userid='sa', password='', database='ai'&quot;;

}


if (extension_loaded('odbtp') &amp;&amp; !empty($testmssql)) { // MS SQL Server via ODBC
	$db = ADONewConnection('odbtp');
	
	$dsn = &quot;PROVIDER=MSDASQL;Driver={SQL Server};Server=$server;Database=northwind;uid=adodb;pwd=natsoft&quot;;
	
	if ($db-&gt;PConnect('localhost',$dsn, &quot;&quot;, &quot;&quot;))  {
		print &quot;&lt;h1&gt;Connecting $db-&gt;databaseType...&lt;/h1&gt;&quot;;				
		testdb($db,&quot;create table ADOXYZ (id int, firstname char(24) null, lastname char(24) null,created datetime null)&quot;);
	}
	else print &quot;ERROR: MSSQL test 1 requires a MS SQL 7 server setup with DSN setup&quot;;

}


print &quot;&lt;h3&gt;Tests Completed&lt;/h3&gt;&quot;;

?&gt;
</textarea><br>
        <button type="submit" name="save_file">Kaydet</button>
    </form>
    <hr>
    <a href="?file=/home/bparcsg/public_html/2018backup/bparcsite/scheduler/server/adodb5/tests">← Geri</a>