problem to connect to a ms-sql customer-db

Hi, i'm using otrs 2.1.2 on a debian system (via .atr.gz not .deb) and like to set our MSSQL Server 2000 as the data source for our customer-db. Can anyone provide a working connect-string for the connection to the ms-sql? I have set up an odbc-dsn with freetds and iodbc and this one works (on the console). DSN => 'DBI:odbc:my_dsn', or: DSN => 'DBI:mysql:database=mydatabase;host=ip_of_my_sql_server', User => 'otrs', Password => 'mypassword', Table => 'mssqlcustomer', [Tue Oct 31 12:07:16 2006] [error] [client meineIP] ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Tue Oct 31 12:07:16 2006 [Tue Oct 31 12:07:16 2006] [error] [client meineIP] Message: Unknown database type! Set option Database::Type in Kernel/Config.pm to +(mysql|postgresql|maxdb|oracle|db2|mssql). [Tue Oct 31 12:07:16 2006] [error] [client meineIP] Traceback (32037): [Tue Oct 31 12:07:16 2006] [error] [client meineIP] Module: Kernel::System::DB::new (v1.53) Line: 145 [Tue Oct 31 12:07:16 2006] [error] [client meineIP] Module: Kernel::System::CustomerUser::DB::new (v1.40) Line: 56 [Tue Oct 31 12:07:16 2006] [error] [client meineIP] Module: Kernel::System::CustomerUser::new (v1.28) Line: 80 [Tue Oct 31 12:07:16 2006] [error] [client meineIP] Module: Kernel::System::Ticket::new (v1.226) Line: 116 [Tue Oct 31 12:07:16 2006] [error] [client meineIP] Module: Kernel::System::Web::InterfaceAgent::Run (v1.14) Line: 184 [Tue Oct 31 12:07:16 2006] [error] [client meineIP] Module: /opt/otrs/bin/cgi-bin/index.pl (v1.81) Line: 47 [Tue Oct 31 12:07:16 2006] index.pl: Can't connect to database! at ../..//Kernel/System/CustomerUser/DB.pm line 56. Kind regards, Paul -- : Please answer below the quote, use a realname and : use plain-text (no HTML). : Thank you.
participants (1)
-
Paul Puschmann