[otrs] ODCB on MSSQL, almost done

17 Jan 2011

      Hello everybody.

Thanks to Frediano Ziglio (on the freeTDS mailing list), I've managed to
connect my Debian Sid to my MSSQL server, by means of ODBC (FreeTDS).

My Config.pm now looks like this (for the CustomerUser part):

    $Self->{CustomerUser} = {
        Name   => 'Database clienti',
        Module => 'Kernel::System::CustomerUser::DB',
        Params => {
                SourceCharset => 'iso-8859-1',
                DestCharset => 'utf-8',
            # if you want to use an external database, add the
            # required settings
        	DSN => 'DBI:ODBC:sqlexpress',
            User => 'sa',
            Password => 'xxxxx',
            Type => 'mssql',
            Table => 'v_customer',
            Attribute => {},
        },

What I get on my browser when I search for a customer is:

Software error:
Can't call method "fetchrow_array" on an undefined value at
/usr/share/otrs//Kernel/System/DB.pm line 622.

Thanks in advance.

Flavio Boniforti

PIRAMIDE INFORMATICA SAGL
Via Ballerini 21
6600 Locarno
Switzerland
Phone: +41 91 751 68 81
Fax: +41 91 751 69 14
URL: http://www.piramide.ch
E-mail: flavio@piramide.ch

[otrs] ODCB on MSSQL, almost done

Boniforti Flavio