About errors in SQL Anywhere 17 OEM

[Former Member]

I do not know why encryption errors are occurring.
I write down the condition below.
Please help me!

[Environment]
Development : Win7 Pro
Visual Studio 2010 Pro(Console Application)
Execute : Win10 Enterprise 2016 LTSB
SQL Anywhere 12
SQL Anywhere 17 OEM
Created database with "SQL Anywhere 17", registered in Windows service, initial setting.
Store the SQL Anywhere DLL in the same location as the Console Application file.

[Test Program]
==================================================
SAConnection myConnection = new SAConnection(
"Data Source = DBA; UID=DBA; PWD=xxxxx");
myConnection.Open(); <- Exception Error
SACommand myCommand = new SACommand("CREATE TABLE TEST (ID BIGINT NOT NULL)");
myConnection.Close();
==================================================

[Execution Result]
==================================================
SQL Anywhere .NET Data Provider : ???G?[: ???DLL "dbrsa17.dll" ???????A???B ( -895 )
==================================================
-895 : Error Code(SQLE_ENCRYPT_ERROR)
dbrsa17.dll : It is in the same folder as the executable file.

[Former Member]

I was able to solve it.
Thank you very much.

[Former Member]

I do not know the details of the error, so please let me know.

I tried the procedure taught, but the following error has occurred.
===============
System.ArgumentException: ????????B'Company' ????s??L??????????L????????
ParameterName:connectionString
Location : Sap.Data.SQLAnywhere.SAConnection..ctor(String connectionString)
Location : ConsoleApplication.Program.Main(String[] args)
===============

A part of the code of the sample program is also listed below.
===============
SAConnection myConnection = new SAConnection(
"Data Source=sample;UID=DBA;PWD=xxxxxx;" +
"InitString=SET TEMPORARY OPTION connection_authentication=" +
"'Application=xxx;Company=xxx;Signature=010f...'");
myConnection.Open();
===============

[chris_keating]

The dbrsa17.dll is a required deployment file for SQL Anywhere 17 and later. See

http://dcx.sap.com/index.html#sqla170/ja/html/815bcac16ce210149887de04eabb7343.html

[Former Member]

Thank you for your quick response.

I will try to understand the contents of the web page that taught me.

I will ask if it does not work.