[TYPO3-windows] Typo3 4.6 Install / DBAL with MSSQL (driver: mssqlnative)

Andreas Heissenberger andreas at heissenberger.at
Fri Nov 18 20:42:32 CET 2011


Hi,

my Typo3 4.6 blankpackage Installation (/typo3/install/index.php) ignores
this additional lines in localconf.php and always uses the native mysql
drive to connect to a local mysql server if running. Any Ideas what could
be wrong?

....
$TYPO3_CONF_VARS['EXTCONF']['dbal']['handlerCfg'] = array(
        '_DEFAULT' => array(
                'type' => 'adodb',
                'config' => array(
                        'driver' => 'mssqlnative',          // using native
driver
                        'useNameQuote' => TRUE
                )
        ),
);

## INSTALL SCRIPT EDIT POINT TOKEN - all lines after this points may be
changed by the install script!
$typo_db_username = 'typo3admin'; //  Modified or inserted by TYPO3 Install
Tool.
$typo_db_password = 'typo3admin'; //  Modified or inserted by TYPO3 Install
Tool.
$typo_db_host = '127.0.0.1'; //  Modified or inserted by TYPO3 Install Tool.
....



a test script with the existing typo3 adodb driver works without a problem:

<?php
if (!function_exists('sqlsrv_configure')) {
 die("mssqlnative extension not installed");
}


$serverName = "127.0.0.1";
$user = "typo3admin";
$pwd = "typo3admin";
$db = "typo3_test";

include('typo3/sysext/adodb/adodb/adodb-exceptions.inc.php');
include('typo3/sysext/adodb/adodb/adodb.inc.php');
try {
// $DB = NewADOConnection('mssqlnative');
$DB = NewADOConnection('mysql');
$DB->debug = true;
$DB->Connect($serverName , $user, $pwd, $db);
} catch (exception $e) {
var_dump($e);
adodb_backtrace($e->gettrace());
}
$rs = $DB->Execute("select * from ttest");
while ($array = $rs->FetchRow()) {
    print_r($array);
}
?>

System Config:
Typo3 4.6 blankpackage-4.6.0.zip
php 5.3.8 nts vc9 x86 (FAST CGI)
add. Extentions: apc, sqlsrv (MS SQL native driver from Microsoft)
IIS 6.0 & FAST CGI)
Windows XP SP3

Thanks!

-- 
  Andreas Heissenberger


More information about the TYPO3-windows mailing list