Hi Simone,
OTRS database is on mySQL, customers Users database in a Microsoft SQL Server database (managed by SAP Business One).
OTRS is running onto a windows 2000 server, so I think that I cannot use FreeDTS.
... could be used, if you build it. But this shouldn't be necessary.
Do you know where may I find a MSSQL/SYBASE perl module usable on windows2000 ? I tried to find it, but only source are available.
As mentioned above, FreeTDS should be a right choice. But in your case (under Win), you should use DBI::odbc in connection with the MS-SQL-ODBC-connectivity without problems (but I don't have experience on that). $Self->{CustomerUser} = { Name => 'Database Backend', Module => 'Kernel::System::CustomerUser::DB', Params => { # if you want to use an external database, add the # required settings DSN => 'DBI:odbc:yourdsn',
Simone Girlanda
Bye, Alex