•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 391,548 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,530 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 3272 | Replies: 1 | Solved
![]() |
•
•
Join Date: Feb 2005
Location: Braintree, UK
Posts: 1,164
Reputation:
Rep Power: 7
Solved Threads: 58
Hi,
I have to connect sometimes to MSSQL and sometimes to MySql depending on the customer. I am experimenting with the php adodb library that claims to make database connection possible to either vendor using the same syntax.
First the background at home I have:
Rig1:
windows XP professional
PHP 5.0.4, IIS 5.1, MSSQL Server 2000 developer edition
Rig2:
Windows XP home
PHP 5.1.1, Apache 2.2.0, MySql 5.0.18-nt
So far if I connect and execute a query on Rig1 using two php files like this it works.
cls_gen_db.conf.php
class_generator.php
In theory to run a similar query on the MySql on Rig2 (it has same database name and user name setup) all I have to change is these two lines:
And this line in the other file:
But I get a blank page, no PHP errors ? if I copy the PHP files over to Rig2 and browse them via Apache web server locally it all works, but If PHP on Rig1 tries to query mysql on Rig2, I get nothing, not even an error. If I view source i see <html><body> but nothing else.
I am lost to know what the problem is (The SP2 firewall on Rig2 is configured to allow incoming TCP/IP on port 3306 from any other host on my home LAN)
What gives?
I have to connect sometimes to MSSQL and sometimes to MySql depending on the customer. I am experimenting with the php adodb library that claims to make database connection possible to either vendor using the same syntax.
First the background at home I have:
Rig1:
windows XP professional
PHP 5.0.4, IIS 5.1, MSSQL Server 2000 developer edition
Rig2:
Windows XP home
PHP 5.1.1, Apache 2.2.0, MySql 5.0.18-nt
So far if I connect and execute a query on Rig1 using two php files like this it works.
cls_gen_db.conf.php
<?php
$_ADO_INC_PATH = 'C:/Inetpub/phpado';
$dbdriver = 'mssql';
$server = 'localhost';
$user = 'myusername';
$password = 'mypassword';
$database = 'mydatabase';
include($_ADO_INC_PATH.'/adodb/adodb.inc.php');
?>class_generator.php
<html>
<body>
<?php
include('cls_gen_db.conf.php');
$Thedb = ADONewConnection($dbdriver);
$Thedb->debug = true;
$Thedb->Connect($server, $user, $password, $database);
$Thedata = $Thedb->Execute('exec sp_tables');
if ($Thedata == false) die("failed");
print '<table>';
while (!$Thedata->EOF) {
print '<tr>';
for ($i=0, $max=$Thedata->FieldCount(); $i < $max; $i++){
print '<td>';
print $Thedata->fields[$i];
print '</td>';
}
print '</tr>';
$Thedata->MoveNext();
}
print '<table>';
?>
</body>
</html>In theory to run a similar query on the MySql on Rig2 (it has same database name and user name setup) all I have to change is these two lines:
$dbdriver = 'mysql';
$server = 'Rig2';And this line in the other file:
$Thedata = $Thedb->Execute('show tables');But I get a blank page, no PHP errors ? if I copy the PHP files over to Rig2 and browse them via Apache web server locally it all works, but If PHP on Rig1 tries to query mysql on Rig2, I get nothing, not even an error. If I view source i see <html><body> but nothing else.
I am lost to know what the problem is (The SP2 firewall on Rig2 is configured to allow incoming TCP/IP on port 3306 from any other host on my home LAN)
What gives?
![]() |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb PHP Marketplace
- How To Connect Remote Mysql Database (Visual Basic 4 / 5 / 6)
- Using PHP to connect to remote MSSQL database (PHP)
- ERROR 2002: Can't connect to local MySQL server (MySQL)
- Can't connect to local MySQL server (MySQL)
Other Threads in the PHP Forum
- Previous Thread: Virus scanning development using PHP
- Next Thread: Deselect the Radio Button



Linear Mode