Noooo please.... why ??!! :D :D :D On Thu, Sep 17, 2009 at 4:34 PM, Marretta, Rosanna < Rosanna.Marretta@yrclogistics.com> wrote:
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
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/