Hi,
 
I am changing MySQL to MSSQL and need some assistance if I may.
 
 
I have created the database and set up a login for OTRS in my MSSQL.  I have changed the config.pm file as per below:
 
# DatabaseHost

    # (The database host.)

    $Self->{DatabaseHost} = '[IP or name to your Database]';

    # Database

    # (The database name.)

    $Self->{Database} = 'otrs';

    # DatabaseUser

    # (The database user.)

    $Self->{DatabaseUser} = 'otrs';

    # DatabasePw

    # (The password of database user. You also can use bin/CryptPassword.pl

    # for crypted passwords.)

    $Self->{DatabasePw} = '[password to sql server for user otrs]';

    # DatabaseDSN

      

       $Self->{"Database::Type"} = 'mssql';



    $Self->{DatabaseDSN} = "DBI:ODBC:otrs";

   

    $Self->{DatabaseUserTable} = 'users';

 
Perl-DBD-ODBC has also been installed.
 
I ran CheckDB.pl and I'm getting the following error, can anybody please help me.  Do I have to change another file?
 
 
DBI connect('otrs','otrs',....) failed: [unixODBC][Driver Manager]Data source name not found, and not default driver specified
 
 
 
Can anybody help?
 
Thanks
 
 
 
 
Rosanna