I was wondering do you experience any performance hit with FreeTDS? We have it set up as well with sql server 2005 and freetds .83 and what a difference in speed from mysql to mssql, when I use mysql I go from 5 secs to 26 secs using mssql in the support assessment SQL Benchmark. Could you let me know what your SQL Benchmarks are using freetds. Thanks, Rob From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Leonardo Certuche Sent: Friday, November 06, 2009 11:49 AM To: User questions and discussions about OTRS. Subject: [otrs] [unixODBC][FreeTDS][SQL Server]Error converting charactersinto server's character set. Hi there, After several workarounds, we have installed otrs-2.4.5-01 on OpenSuSE 10.3 connected to a MSSQL database. In order to achieve it, we installed the following RPM packages: unixODBC-devel-2.2.12-55 unixODBC-2.2.12-55 perl-DBI-1.58-17 perl-DBD-ODBC-1.14-13 An also installed freetds-0.82 from source with the following options: ./configure --with-tdsver=7.0 --with-mssql And configured the files /etc/unixODBC/odbcinst.ini, /etc/unixODBC/odbc.ini and /usr/local/etc/freetds.conf We are creating users, customers, queues, etc and they're being stored in the MSSQL database no problem but when we try to install a new package using /otrs/index.pl?Action=AdminPackageManager, the following error shows up: ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Fri Nov 6 13:45:50 2009 Message: [unixODBC][FreeTDS][SQL Server]Error converting characters into server's character set. Some character(s) could not be converted (SQL-HY000) [unixODBC][FreeTDS][SQL Server]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 7: The parameter name is invalid. (SQL-42000)(DBD: st_execute/SQLExecute err=-1), SQL: 'INSERT INTO web_upload_cache (form_id, filename, content_type, content_size, content, create_time_unix, content_id) VALUES (?, ?, ?, ?, ?, ?, ?)' Traceback (1612): Module: Kernel::System::Web::UploadCache::DB::FormIDAddFile (v1.20) Line: 96 Module: Kernel::System::Web::UploadCache::FormIDAddFile (v1.19) Line: 153 Module: Kernel::Modules::AdminPackageManager::Run (v1.81) Line: 962 Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 819 Module: /opt/otrs/bin/cgi-bin/index.pl (v1.88) Line: 48 Thanks in advance for your help solving this issue, Regards, Leonardo Certuche