Noooo please.... why ??!!
:D :D :D
On Thu, Sep 17, 2009 at 4:34 PM, Marretta, Rosanna <
[email protected]> 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/
>
---------------------------------------------------------------------
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/
