Hi Holger, On Wed, Jul 02, 2003 at 11:42:26AM +0200, Holger.Struck@sqs.de wrote:

how i can use the MS SQL Server 2000 as database server for otrs? I have imported the tables into SQL Server.

Cool! :-) Cool Holger!

Im trying to connect via DBI:ODBC. It seems to work, but if i try to login into otrs, i get this error: "SessionID invalid! Need user data!" And in the Apache error.log i found this: "(long truncated DBI attribute LongTruncOk not set and/or LongReadLen too small) at d:/otrs/Kernel/System/DB.pm line 249" Any Idea how to solve this?

Yepp. But I can't say it at this moment (I need to have access to an other machine - I get it on sunday). I had the same problem with SAPDB. Im not sure, but try to change the "DBI->connect(" in Kernel/System/DB.pm from: [...] # -- # db connect # -- if (!($Self->{dbh} = DBI->connect("$Self->{DSN}", $Self->{USER}, $Self->{PW}))) { $Self->{LogObject}->Log( Caller => 1, Priority => 'Error', Message => $DBI::errstr, ); return; } [...] to: [...] # -- # db connect # -- if (!($Self->{dbh} = DBI->connect("$Self->{DSN}", $Self->{USER}, $Self->{PW}, { LongTruncOk => 1 }))) { $Self->{LogObject}->Log( Caller => 1, Priority => 'Error', Message => $DBI::errstr, ); return; } [...]

Holger Struck

-Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ --