Hi Patrick, Patrick McEvoy schrieb:
Hi folks,
I have got a clean copy of OTRS running all fine using mysql. I want to connect to a MSSQL db to get customer details. I've seen the other post on here about it and have done the same things. However it's throwing an error....
ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: freebsd Time: Wed Mar 29 22:58:36 2006
Message: Unknown database type! Set option Database::Type in Kernel/Config.pm to (mysql|postgresql|maxdb|oracle|db2|mssql).
I wonder about this logging. What does this mean? How can a mssql-connection be established within OTRS? I though that it is fairly difficult to connect from linux to MS-SQL. Do you use a direct DBD-MSSQL-connection or ODBC-connection? I use DBD::Sybase to realize a direct connect between linux-perl and MS-SQL (without ODBC). That works fine - see http://freetds.org/ for details. Bye, Alex