#47073 [Bgs]: don�t connect to mssql
ID: 47073
User updated by: joao dot rebelo at pchouse dot pt
Reported By: joao dot rebelo at pchouse dot pt
Status: Bogus
Bug Type: MSSQL related
Operating System: Windows XP SP3
PHP Version: 5.2.8
New Comment:
Ok. Thanks, it was the php_pdo_mysql that was not loaded, only
php_mssql was loaded.
Now is working.
Previous Comments:
[2009-01-12 15:36:19] paj...@php.net
Well, the error is clear. You did not install the mssql driver. But as
we are not Zend and has little to do with the Zend framework, I would
suggest to ask for some support there instead.
Not a php bug > bogus.
[2009-01-12 15:28:35] joao dot rebelo at pchouse dot pt
function datamssql(){
if(!$mssqldb){
global $mssql_host, $mssql_user, $mssql_password, $mssql_database;
$mssqldb = new Zend_Db_Adapter_Pdo_Mssql(array(
'host' => $mssql_host,
'username' => $mssql_user,
'password' => $mssql_password,
'dbname' => $mssql_database
));
}
return $mssqldb;
} // end mssql connection
Fatal error: Uncaught exception 'Zend_Db_Adapter_Exception' with
message 'The mssql driver is not currently installed' in
C:\wamp\virtualhost\pchousecms\cmsadmin\include\Zend\Db\Adapter\Pdo\Abstract.php:103
Stack trace: #0
C:\wamp\virtualhost\pchousecms\cmsadmin\include\Zend\Db\Adapter\Pdo\Mssql.php(135):
Zend_Db_Adapter_Pdo_Abstract->_connect() #1
C:\wamp\virtualhost\pchousecms\cmsadmin\include\Zend\Db\Adapter\Abstract.php(389):
Zend_Db_Adapter_Pdo_Mssql->_connect() #2
C:\wamp\virtualhost\pchousecms\cmsadmin\include\Zend\Db\Adapter\Pdo\Abstract.php(205):
Zend_Db_Adapter_Abstract->query('SELECT COUNT(no...', Array) #3
C:\wamp\virtualhost\pchousecms\cmsadmin\include\connector\backoffice\wintouch\subfamilia.class.php(351):
Zend_Db_Adapter_Pdo_Abstract->query('SELECT COUNT(no...') #4
C:\wamp\virtualhost\pchousecms\cmsadmin\include\connector\subfamilia\subfamilia.php(16):
subfamilia->countrec() #5 {main} thrown in
C:\wamp\virtualhost\pchousecms\cmsadmin\include\Zend\Db\Adapter\Pdo\Abstract.php
on line 103
I also had copy the ntwdblib.dll as i did in on PHP 5.2.6 to work, but
doesn´t work
[2009-01-12 10:35:39] paj...@php.net
Please show us some script. Also the driver from Microsoft is not
compatible with PHP's mssql drivers. They use differenet APIs.
------------
[2009-01-12 10:15:23] joao dot rebelo at pchouse dot pt
Description:
Upgrading from PHP 5.2.6 to PHP 5.2.8 and had stopping the connection
with MSSQL, with the message 'no driver installed' even after installing
the driver from Microsoft web site and installing and configure php.ini
to load the drive when I rollback to PHP 5.2.6 everything works fine.
--
Edit this bug report at http://bugs.php.net/?id=47073&edit=1
#47073 [Fbk->Opn]: don�t connect to mssql
ID: 47073
User updated by: joao dot rebelo at pchouse dot pt
Reported By: joao dot rebelo at pchouse dot pt
-Status: Feedback
+Status: Open
Bug Type: MSSQL related
Operating System: Windows XP SP3
PHP Version: 5.2.8
New Comment:
function datamssql(){
if(!$mssqldb){
global $mssql_host, $mssql_user, $mssql_password, $mssql_database;
$mssqldb = new Zend_Db_Adapter_Pdo_Mssql(array(
'host' => $mssql_host,
'username' => $mssql_user,
'password' => $mssql_password,
'dbname' => $mssql_database
));
}
return $mssqldb;
} // end mssql connection
Fatal error: Uncaught exception 'Zend_Db_Adapter_Exception' with
message 'The mssql driver is not currently installed' in
C:\wamp\virtualhost\pchousecms\cmsadmin\include\Zend\Db\Adapter\Pdo\Abstract.php:103
Stack trace: #0
C:\wamp\virtualhost\pchousecms\cmsadmin\include\Zend\Db\Adapter\Pdo\Mssql.php(135):
Zend_Db_Adapter_Pdo_Abstract->_connect() #1
C:\wamp\virtualhost\pchousecms\cmsadmin\include\Zend\Db\Adapter\Abstract.php(389):
Zend_Db_Adapter_Pdo_Mssql->_connect() #2
C:\wamp\virtualhost\pchousecms\cmsadmin\include\Zend\Db\Adapter\Pdo\Abstract.php(205):
Zend_Db_Adapter_Abstract->query('SELECT COUNT(no...', Array) #3
C:\wamp\virtualhost\pchousecms\cmsadmin\include\connector\backoffice\wintouch\subfamilia.class.php(351):
Zend_Db_Adapter_Pdo_Abstract->query('SELECT COUNT(no...') #4
C:\wamp\virtualhost\pchousecms\cmsadmin\include\connector\subfamilia\subfamilia.php(16):
subfamilia->countrec() #5 {main} thrown in
C:\wamp\virtualhost\pchousecms\cmsadmin\include\Zend\Db\Adapter\Pdo\Abstract.php
on line 103
I also had copy the ntwdblib.dll as i did in on PHP 5.2.6 to work, but
doesn´t work
Previous Comments:
[2009-01-12 10:35:39] paj...@php.net
Please show us some script. Also the driver from Microsoft is not
compatible with PHP's mssql drivers. They use differenet APIs.
----------------
[2009-01-12 10:15:23] joao dot rebelo at pchouse dot pt
Description:
Upgrading from PHP 5.2.6 to PHP 5.2.8 and had stopping the connection
with MSSQL, with the message 'no driver installed' even after installing
the driver from Microsoft web site and installing and configure php.ini
to load the drive when I rollback to PHP 5.2.6 everything works fine.
--
Edit this bug report at http://bugs.php.net/?id=47073&edit=1
#47073 [NEW]: don�t connect to mssql
From: joao dot rebelo at pchouse dot pt Operating system: Windows XP SP3 PHP version: 5.2.8 PHP Bug Type: MSSQL related Bug description: don´t connect to mssql Description: Upgrading from PHP 5.2.6 to PHP 5.2.8 and had stopping the connection with MSSQL, with the message 'no driver installed' even after installing the driver from Microsoft web site and installing and configure php.ini to load the drive when I rollback to PHP 5.2.6 everything works fine. -- Edit bug report at http://bugs.php.net/?id=47073&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=47073&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=47073&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=47073&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=47073&r=fixedcvs Fixed in CVS and need be documented: http://bugs.php.net/fix.php?id=47073&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=47073&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=47073&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=47073&r=needscript Try newer version: http://bugs.php.net/fix.php?id=47073&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=47073&r=support Expected behavior: http://bugs.php.net/fix.php?id=47073&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=47073&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=47073&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=47073&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=47073&r=php4 Daylight Savings:http://bugs.php.net/fix.php?id=47073&r=dst IIS Stability: http://bugs.php.net/fix.php?id=47073&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=47073&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=47073&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=47073&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=47073&r=mysqlcfg
#47018 [NEW]: mb_detect_encoding doesn�t detect
From: joao dot rebelo at pchouse dot pt
Operating system: Windows XP SP3
PHP version: 5.2.8
PHP Bug Type: ICONV related
Bug description: mb_detect_encoding doesn´t detect
Description:
mb_detect_encoding always detect the input string encode as the first in
the encoding list supplied, in this case because the first in the list is
UTF-8 always detect as UTF-8, even if the string is in another encode, if
no encoding list is supplied always detect as ASCII.
Reproduce code:
---
function conv2latin($values2conv){
$encode = mb_detect_encoding($vl2conv, 'utf-8, ISO-8859-1', true);
if(is_array($values2conv)){
foreach($values2conv as $key2conv=>$vl2conv){
$encode = mb_detect_encoding($vl2conv);
if( strtoupper($encode) != "ISO-8859-1"){
$vl2conv = iconv($encode, 'ISO-8859-1', $vl2conv);
}
$return[$key2conv]=$vl2conv;
}
}elseif(!empty($values2conv)){
$encode = mb_detect_encoding($vl2conv);
if( strtoupper($encode) != "ISO-8859-1" ){
$return = iconv($encode, 'ISO-8859-1', $values2conv);
}
}
return $return;
return $values2conv;
}//end function
Expected result:
The function is pretending to return the string as is if the input string
is in ISO-8859-1 if not is pretending to convert the string from UTF-8 to
ISO-8859-1 and return the converted string.
--
Edit bug report at http://bugs.php.net/?id=47018&edit=1
--
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=47018&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=47018&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=47018&r=trysnapshot60
Fixed in CVS:
http://bugs.php.net/fix.php?id=47018&r=fixedcvs
Fixed in CVS and need be documented:
http://bugs.php.net/fix.php?id=47018&r=needdocs
Fixed in release:
http://bugs.php.net/fix.php?id=47018&r=alreadyfixed
Need backtrace:
http://bugs.php.net/fix.php?id=47018&r=needtrace
Need Reproduce Script:
http://bugs.php.net/fix.php?id=47018&r=needscript
Try newer version:
http://bugs.php.net/fix.php?id=47018&r=oldversion
Not developer issue:
http://bugs.php.net/fix.php?id=47018&r=support
Expected behavior:
http://bugs.php.net/fix.php?id=47018&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=47018&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=47018&r=submittedtwice
register_globals:
http://bugs.php.net/fix.php?id=47018&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=47018&r=php4
Daylight Savings:http://bugs.php.net/fix.php?id=47018&r=dst
IIS Stability:
http://bugs.php.net/fix.php?id=47018&r=isapi
Install GNU Sed:
http://bugs.php.net/fix.php?id=47018&r=gnused
Floating point limitations:
http://bugs.php.net/fix.php?id=47018&r=float
No Zend Extensions:
http://bugs.php.net/fix.php?id=47018&r=nozend
MySQL Configuration Error:
http://bugs.php.net/fix.php?id=47018&r=mysqlcfg
