Questions Tagged With mssql

Xpert.ivy Server Version 3.9 Build 52 Patch 6 on modern Windows Server OS and MS SQL

sys-adm — Wed, 26 Feb 2020 07:27:38 -0500

Hello,

We have Xpert.ivy Server Version 3.9 Build 52 Patch 6 running on an old Windows Server 2003. Is it possible to install this on a modern server OS? In the install guide they say it will run up to Windows Server 2008 R2. Is it possible to install on Windows Server 2019? Have anyone other tried this? Can Axon.ivy give some support for this configuration?

Also is it possible to use a newer MS SQL Server? Should support up to 2008 R2. When we can do a rebuild on a mordern server OS we will also upgrade our database server to a newer SQL like MS SQL Server 2019.

Thanks Regards sys-adm

How to specify database instance name?

ruffzy — Tue, 07 Feb 2017 10:14:59 -0500

How can I specify the instance name of a database in the database configuration window of the ivy server? If I am using the management studio way with DATABASENAME\INSTANCENAME I am getting an unknow server host name exception. I have seen that the jdbc connection string actually asks for an adittional argument instanceName - but I am not able to set this value.

How to store mandarin chinese text into a MsSql database

SupportIvyTeam — Tue, 22 Nov 2016 14:31:55 -0500

I'm trying to insert UTF-8 encoded strings with mandarin language (e.g. 文化大學華 hey) into a MsSql table. The Collation is Latin1_General_CI_AS.

But the special characters are always stored with question mark characters (e.g. ????? hey). How can I store the values so that they can be read afterwards?

How can I assign a MS SQL-based XpertIvySystemDataBase as the Designer's SystemDb

Dieter Staudt — Wed, 07 Sep 2016 11:12:26 -0400

Hello together,

in my Designer environment all cases, tasks etc. will only be available through the actual session; after close/reopen the Designer all this informations are lost und for example the TaskQuery will not work.

In the meantime I defined the SystemDb as a Hypersonic SQL DB in the Memory (like Q&A#996) but all the informations are also lost after restart the Designer.

Is there a way to assign a MS SQL-based XpertIvySystemDataBase as the Designer's SystemDb or to save the Hypersonic MemoryDb to MS-SQL to store all the contents permanently for further developing and testing?

Thanks in advance.

Dieter

How to improve performance of MSSql system database with jTDS driver (many temporary files)

SupportIvyTeam — Wed, 07 Sep 2016 09:25:31 -0400

If I use an Microsoft SQL Server as System Database and access it with the jTDS driver. Then I have many temporary files (jdtsXYZ.tmp) stored with clob and blob data in the temp folder. How can I avoid that they are created? Because it is obvious that the performance of storing such files is not as good as if the data is only held in memory.