About Orthanc ODBC 1.0 plugin

Dear Sir/Madam,

We installed the latest version Orthanc for Microsoft Windows (OrthancInstaller-Win64-21.8.3).
We tried to use Orthanc ODBC 1.0 plugin to connect Microsoft SQL Server 2019 Developer.
We followed the ODBC plugins — Orthanc Book documentation (orthanc-server.com) description to modify connection string in obdc.json file.
The connection string we used as follow,

“IndexConnectionString” : “Driver={ODBC Driver 17 for SQL Server};Server=tcp:localhost,1433;Database=orthanc;Uid=sa;Pwd=##Chao0000

After restart Orthanc, we uploaded dcm file to Orhanc and MSSQL recorded index successfully.

But upload failed if DICOM tag contained Chinese word.
The Orthanc log as follow,

E0911 20:59:09.245347 StatelessDatabaseOperations.cpp:3271] EXCEPTION [Error with the database engine]
E0911 20:59:09.245347 PluginsManager.cpp:164] Cannot commit a non-existing transaction
E0911 20:59:09.277572 PluginsManager.cpp:164] Error with the database engine: Cannot execute ODBC statement:

We tried to add charset=Chinese to the connection string to fix the error.
But it did not work.

Do you have any experience dealing with above mentioned issue ?

Your prompt reply will be much appreciated.

Best regards
Drexler

Hello,

Please post a sample problematic DICOM image for other people to be able to reproduce your issue:
https://book.orthanc-server.com/users/support.html#discussing-a-minimal-working-example

Regards,
Sébastien-

Dear Sir,

Here is sample DICOM image, ODBC configuration file and log file for your information.
Your prompt reply and solution will be much appreciated.

Best regards,
Drexler

s.jo...@gmail.com 在 2021年9月12日 星期日下午10:55:48 [UTC+8] 的信中寫道:

CT000000.dcm (116 KB)

CT000002.dcm (116 KB)

Orthanc.log.20210914-093459.3972 (13.1 KB)

odbc.json (664 Bytes)

CT000001.dcm (116 KB)

Dear Sir,

We try to upload DICOM files contained Chinese, Japanese, Korea, Thai word to MSSQL via ODBC plugin.
But it did not work.

Here is Chinese, Japanese, Korea, Thai DICOM file for your reference.

Your prompt reply will be sincerely appreciated.

Best regards,
Drexler

s.jo...@gmail.com 在 2021年9月12日 星期日下午10:55:48 [UTC+8] 的信中寫道:

Korea_CT.zip (321 KB)

Japanese_CT.zip (321 KB)

Thai_CT.zip (321 KB)

Chinese_CT.zip (321 KB)