Skip to Content

About errors in SQL Anywhere 17 OEM

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 27, 2017 at 02:49 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 09, 2017 at 02:29 AM

    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();
    ===============

    Add comment
    10|10000 characters needed characters exceeded

  • May 09, 2017 at 08:53 AM

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

    Add comment
    10|10000 characters needed characters exceeded