[TYPO3] MSSQL support?

[Michael Scharkow]

Michal Charemza wrote:
> Hi,
> 
> Does typo3 work with MSSQL? If so, do the extensions work? I haven't 
> managed to find a definitive answer.

Well, the adodb extension includes a driver so in theory, DBAL should 
work. Extensions may or may not work, depending on them using the TYPO3 
DB API or raw mysql calls. You have to check that yourself for every 
extension you plan to use.

> I have been trying to install typo3 with a new install with mssql. I 
> have followed the instructions at 
> http://typo3.org/documentation/document-library/extension-manuals/dbal/0.5.0/view/1/4/, 
> except that I have not manually installed dbal and adodb, as these now 
> seem to be part of the main distro. Also where "mysql" is in the code 
> except I have replaced "mssql", and I have added a database name argument.

$TYPO3_CONF_VARS['EXTCONF']['dbal']['handlerCfg'] = array (
          '_DEFAULT' => array (
              'type' => 'adodb',
              'config' => array(
                  'driver' =>'mssql',

              )
       )
   );

*should* work. It does with driver="postgresql8" but you have to create 
the DB yourself and prepare for some ugly error messages which you may 
be able ignore.

Sorry, I don't have Windows or MSSQL available and I have not read in 
the lists that someone actually tested this.

Cheers,
Michael

PS: Please don't hijack threads, and post your experiences if you get 
stuff to work!