
Hi folks, I have got a clean copy of OTRS running all fine using mysql. I want to connect to a MSSQL db to get customer details. I've seen the other post on here about it and have done the same things. However it's throwing an error.... ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: freebsd Time: Wed Mar 29 22:58:36 2006 Message: Unknown database type! Set option Database::Type in Kernel/Config.pm to (mysql|postgresql|maxdb|oracle|db2|mssql). Traceback (38439): Module: Kernel::System::DB::new (v1.47) Line: 145 Module: Kernel::System::CustomerUser::DB::new (v1.36) Line: 56 Module: Kernel::System::CustomerUser::new (v1.22) Line: 80 Module: Kernel::System::Ticket::new (v1.194) Line: 124 Module: Kernel::System::Web::InterfaceAgent::Run (v1.8) Line: 181 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (v) Line: 47 Module: (eval) (v1.80) Line: 203 Module: ModPerl::RegistryCooker::run (v1.80) Line: 203 Module: ModPerl::RegistryCooker::default_handler (v1.80) Line: 169 Module: ModPerl::Registry::handler (v1.99) Line: 30 [Wed Mar 29 22:58:36 2006] [error] at /opt/otrs//Kernel/System/CustomerUser/DB.pm line 56.\n I clearly don't want to set that option for the main mysql db otrs uses only for the connection to the customer db. I've added the line below which clears the error, but I'm still working on fixing ODBC errors/probs, no idea yet if related. Type => 'mysql' in Kernel/System/CustomerUser/DB.pm Thoughts? TIA -- Kind regards C D Patrick McEvoy ViaVillas Limited Managing Director email patrick@viavillas.com mobile 07905775504 -- ViaVillas Limited Elmfield, 229 Bury Road, Rossendale, BB4 6DJ Tel: 08700634893 - Fax: 08712362513 Email: support@viavillas.com - Web: http://www.viavillas.com/ Company Number : 4641179 - VAT Number : GB 815 6385 17 --