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