Welcome, Guest. Register Now!
04-01-2008, 03:03 PM
|
|||
|
|||
DB Mssql
What seems to be the problem with my code below?
Code:
<? require_once 'Zend/Db/Adapter/Pdo/Mssql.php'; $db = new Zend_Db_Adapter_Pdo_Mssql(array( 'host' => '10.0.0.9', 'username' => 'sa', 'password' => '', 'dbname' => 'myDb' )); $sql = 'SELECT CustName FROM Customer'; $result = $db->fetchAll($sql, 2); ?> I've already enable mssql via the zendcore admin gui and have restarted Apache. I get the following error message: 'The mssql driver is not currently installed' in C:\Program Files\Zend\Apache2\htdocs\Zend\Db\Adapter\Pdo\Abst ract.php:104 Stack trace: I have the following settings: Zend Core Version 2.5.0 PHP Version 5.2.4 Zend Engine Version 2.2.0 Server API cgi-fcgi PHP Configuration File C:\Program Files\Zend\Core\etc\php.ini Web Server Server Name localhost Server Software Apache/2.2.4 (Win32) OS Version Microsoft Windows XP Server Configuration Server Port 8080 Connection Timeout 300 Keepalive Timeout 300 Server Root C:\Program Files\Zend\Apache2 Server Configuration File C:\Program Files\Zend\Apache2\conf\httpd.conf     
|
|
04-02-2008, 11:07 AM
|
|||
|
|||
|
Quote:
__________________
------------------ Loris Candylaftis
|
|
04-02-2008, 07:48 PM
|
|||
|
|||
|
Ok for those who are struggling with this problem I figured out the solution.
php_pdo_mssql.dll is no longer supported. If you wish to connect to MS Sql Server on a windows server the recommended is to use phpodbc. ADODB is pretty solid choice IMO.
|
 |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
