Hi Holger,
On Wed, Jul 02, 2003 at 11:42:26AM +0200, [EMAIL PROTECTED] 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/
--
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
