Thanks for your interest on the topic Robby,<br><br>Unfortunately I haven&#39;t been able to install the Benchmark package due to the error that I reported in the current thread. If you (or someone else) could give me some clues on how to solve it, I&#39;ll be more that glad to answer your question regarding speed.<br>

<br>Anyone with experience setting character sets to communicate OTRS on Linux to its database on microsoft SQL server?<br><br>Thanks,<br><br clear="all">Leonardo Certuche<br><br><br><div class="gmail_quote">On Fri, Nov 6, 2009 at 4:17 PM, Robby Garon <span dir="ltr">&lt;<a href="mailto:robby.garon@shiftnetworks.com">robby.garon@shiftnetworks.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">








<div link="blue" vlink="purple" lang="EN-US">

<div>

<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">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.  </span></p>

<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>

<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Thanks,</span></p>

<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>

<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Rob</span></p>

<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>

<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">

<p class="MsoNormal"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;">
<a href="mailto:otrs-bounces@otrs.org" target="_blank">otrs-bounces@otrs.org</a> [mailto:<a href="mailto:otrs-bounces@otrs.org" target="_blank">otrs-bounces@otrs.org</a>] <b>On Behalf Of </b>Leonardo
Certuche<br>
<b>Sent:</b> Friday, November 06, 2009 11:49 AM<br>
<b>To:</b> User questions and discussions about OTRS.<br>
<b>Subject:</b> [otrs] [unixODBC][FreeTDS][SQL Server]Error converting
charactersinto server&#39;s character set.</span></p>

</div><div><div></div><div class="h5">

<p class="MsoNormal"> </p>

<p class="MsoNormal" style="margin-bottom: 12pt;">Hi there,<br>
<br>
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:<br>
unixODBC-devel-2.2.12-55<br>
unixODBC-2.2.12-55<br>
perl-DBI-1.58-17<br>
perl-DBD-ODBC-1.14-13<br>
<br>
An also installed freetds-0.82 from source with the following options:<br>
./configure --with-tdsver=7.0 --with-mssql<br>
<br>
And configured the files /etc/unixODBC/odbcinst.ini, /etc/unixODBC/odbc.ini and
/usr/local/etc/freetds.conf<br>
<br>
We are creating users, customers, queues, etc and they&#39;re being stored in the
MSSQL database no problem but when we try to install a new package using /otrs/<a href="http://index.pl?Action=AdminPackageManager" target="_blank">index.pl?Action=AdminPackageManager</a>,
the following error shows up:</p>

<div style="margin-left: 30pt;">

<p class="MsoNormal">ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Fri
Nov  6 13:45:50 2009<br>
<br>
Message: [unixODBC][FreeTDS][SQL Server]Error converting characters into
server&#39;s character set. Some character(s) could not be converted (SQL-HY000)<br>
[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: &#39;INSERT
INTO web_upload_cache  (form_id, filename, content_type,
content_size, content, create_time_unix, content_id) VALUES  (?, ?,
?, ?, ?, ?, ?)&#39;<br>
<br>
Traceback (1612): <br>
   Module: Kernel::System::Web::UploadCache::DB::FormIDAddFile
(v1.20) Line: 96<br>
   Module: Kernel::System::Web::UploadCache::FormIDAddFile (v1.19)
Line: 153<br>
   Module: Kernel::Modules::AdminPackageManager::Run (v1.81) Line:
962<br>
   Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line:
819<br>
   Module: /opt/otrs/bin/cgi-bin/<a href="http://index.pl" target="_blank">index.pl</a>
(v1.88) Line: 48</p>

</div>

<p class="MsoNormal"><br>
Thanks in advance for your help solving this issue,<br>
<br>
Regards,<br>
<br clear="all">
Leonardo Certuche</p>

</div></div></div>

</div>


<br>---------------------------------------------------------------------<br>
OTRS mailing list: otrs - Webpage: <a href="http://otrs.org/" target="_blank">http://otrs.org/</a><br>
Archive: <a href="http://lists.otrs.org/pipermail/otrs" target="_blank">http://lists.otrs.org/pipermail/otrs</a><br>
To unsubscribe: <a href="http://lists.otrs.org/cgi-bin/listinfo/otrs" target="_blank">http://lists.otrs.org/cgi-bin/listinfo/otrs</a><br>
<br>
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!<br>
<a href="http://www.otrs.com/en/support/enterprise-subscription/" target="_blank">http://www.otrs.com/en/support/enterprise-subscription/</a><br></blockquote></div><br>