SQL - How to use MSSQL for Authentication and MySQL for

[A.L.M.Buxey at lboro.ac.uk]

Hi,

>      * I use a MSSQL database on a separate server for Authentication and
>        that is working well.
>     
>      * I want to use a MySQL database on a third server for Accounting.
>     
>      * Everything I have searched shows how to configure it for one or the
>        other but not both.

use different instantiation names for each of your databases eg

sql sql-MSSQL {

configure MSSQL here

}


sql sql-mysql {

configure MYSQL here

}


now in the authentication section call 'sql-MSSQL' instead of just 'sql'


now in accounting section call 'sql-mysql' instead of just 'sql'

alan