Package DB 1.3
| From: | Luis Santos | Date: | Wed, 08 Jan 2003 02:17:36 +0000 |
| Subject: | Package DB 1.3 | ||
| Groups: | php.pear.dev | ||
| Request: | Send a blank email to pear-dev+get-12185@lists.php.net to get a copy of this message | ||
Hi,
I had developed code to use mssql using PEAR that in the past was
working with PHP 4.2.3 (odbc, mssql connections).
Now with the installation of PHP 4.3.0 I did get some problems and now I
don't know what to do.
In the past ODBC and MSSQL was working fine but now only ODBC is
working.
This is the script that I use to test
The error that I get with mssql is "no such database" .
Can you help me ??
Regards
Luis Santos
<?php
require_once ('DB.php');
$user = 'teste';
$pass = 'teste';
$host = 'teste';
$db_name = 'teste';
$dsn = "odbc://$user:$pass@$host/$db_name";
echo"$dsn <p>";
$db = DB::connect($dsn);
if (DB::isError($db)) {
die ($db->getMessage());
} else echo "OK ODBC <P>";
$sql = "select * from USERS";
$result = $db->query($sql);
if (DB::isError($result)) {
die ($result->getMessage());
}
while ($row = $result->fetchRow()) { $id = $row[1];echo "<br>";echo
$id;}
echo "<p>";
//mssql inicio
$user = 'teste';
$pass = 'teste';
$host = '127.0.0.1';
$db_name = 'teste';
$type = "mssql";
$dsn = "$type://$user:$pass@$host/$db_name";
echo"$dsn <p>";
$db = DB::connect($dsn);
if (DB::isError($db)) {
die ($db->getMessage());
} else echo "OK MSSQL <P>";
$sql = "select * from USERS";
$result = $db->query($sql);
if (DB::isError($result)) {
die ($result->getMessage());
}
while ($row = $result->fetchRow()) { $id = $row[1];echo "<br>";echo
$id;}
echo "<p>";
?>
the result is:
odbc://teste:teste@teste/teste
OK ODBC
Admin
Luis Santos
csu
Oper
mssql://teste:teste@127.0.0.1/teste
DB Error: no such database