All,

 

Apologies if this has been round before, but I am new to OTRS, and perl and apache…..

 

I have installed OTRS 2.4.5 on a Windows 2003 server box, using all the default settings.

 

I want to collect customer data from a SQL Server database on another box, and have set up an ODBC connection to that box.

 

In Defaults.pm I have set up the following as described in the admin manual:

 

    $Self->{CustomerUser2} = {

        Name   => 'Customer Database Backend',

        Module => 'Kernel::System::CustomerUser2::DB',

        Params => {

            # if you want to use an external database, add the

            # required settings

DSN => 'DBD:odbc:Intranet',

            User => 'sa',

            Password => '',

            Table => 'vwOTRS_LocationData',

 

But get error : “Unknown database type! Set option Database::Type in Kernel/Config.pm to (mysql|postgresql|oracle|db2|mssql).”

 

If I change the DSN to be :

            DSN => 'DBI:mssql:database=intranet;host=europa',

 

I get the error :

install_driver(mssql) failed: Can't locate DBD/mssql.pm in @INC (@INC contains: ../../ C:/Program Files/OTRS/OTRS/bin/cgi-bin/../../Kernel/cpan-lib C:/Program Files/OTRS/OTRS/bin/cgi-bin/../.. C:/PROGRA~1/OTRS/StrawberryPerl/perl/lib C:/PROGRA~1/OTRS/StrawberryPerl/perl/site/lib . C:/Program Files/OTRS/OTRS/bin/cgi-bin/../.. C:/Program Files/OTRS/OTRS/bin/cgi-bin/../../Kernel/cpan-lib) at (eval 61) line 3.

Perhaps the DBD::mssql perl module hasn't been fully installed,

 

Has anybody had this sort of error?

 

Any help appreciated.

 

Thank you

 

Jeff Dunn