PDO working via Apache but not at the command line?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I have the following very simple script that uses PDO/FreeTDS to connect to a mssql server. I have PHP Version 5.3.3 running on Linux under Apache. When I view this script via apache/firefox I get proper output.

If I try and run this via the command line like "php db_dump.php" I get an error connecting to the DB:

Unable to connect to Omnia: SQLSTATE[HY000] Unable to connect: Adaptive Server is unavailable or does not exist (severity 9). Does Apache call PHP differently than the cli would? Why would Apache method work find, but direct from the command line cause a problem? Do I need to call php from the cli with some other argument?

----------------------------------------------------------------------


$num || $num = 197804;

$dbh = omnia_connect();
$sql = "EXECUTE P_SaaS_AccountServiceFeatures_Retrieve $num";
$sth = $dbh->prepare($sql);
$sth->execute();

$foo = $sth->fetchAll(PDO::FETCH_ASSOC);

foreach ($foo as $i) {
        if ($i['ItemStatus'] != 'I') {
                $out .= $i['Component'] . "\n";
        }
}

print $out;

####################################################################

function omnia_connect() {
        putenv('FREETDSCONF=/etc/freetds.conf');
        $db = "DB_NAME";
        $user = "user";
        $pass = "pass";

        $dsn = "dblib:host=Omnia;dbname=$db";

        try {
                $dbh = new PDO($dsn, $user, $pass);
        } catch (PDOException $e) {
                echo 'Unable to connect to Omnia: ' . $e->getMessage();
                exit;
        }

        return $dbh;
}

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux