[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