Re: Pear and SQLServer
| From: | Tomas V.V.Cox | Date: | Wed, 22 May 2002 21:46:46 +0000 |
| Subject: | Re: Pear and SQLServer | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-6345@lists.php.net to get a copy of this message | ||
Rafa Giménez wrote:
>
> Hi, this is Rafa from Barcelona, Spain.
>
> I'm developing a project which runs on PHP + SQL Server, and I'm also using PHP
> SiteManager (my company has just adapted it as common framework).
>
> SiteManager uses PEAR as abstraction layer to access databases, and this is the beginning of my
> troubles. I had tried previously PEAR against MySQL tables, and it worked fine, but it seems that
> something doesn't work fine with SQL Server.
>
> I'm trying to establish connection with SQL Server and it's totally impossible. The
> DSN I'm sending to PEAR is the following one :
>
> <VAR name="DSN" value = "mssql://Lavinia:*******@RGIMENEZ/Santillana"
> />
>
> Where am I going wrong ? Does the SQL Server connection need any special parameter ? Has any of
> you used PEAR and SQL Server ? Before start checking the PEAR code, I'd like to get some
> feedback from the rest of users.
>
<?php
require_once 'DB.php';
$db = DB::connect('mssql://Lavinia:*******@RGIMENEZ/Santillana');
if (PEAR::isError($db)) {
die("Failed to connect: " . $db->toString());
}
echo "Connected!";
?>
Read more at pear.php.net/manual/ and vulcanonet.com/soft/pear_tut/
Tomas V.V.Cox