[otrs] problem to connect to a ms-sql customer-db

[Paul Puschmann]

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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.otrs.org/pipermail/otrs/attachments/20061103/bfec003a/attachment.pgp