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