Skip to Content
0

About errors in SQL Anywhere 17 OEM

Apr 26, 2017 at 06:46 PM

102

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Chris Keating
Apr 27, 2017 at 02:49 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.

0
Yasuhiro Okuda May 09, 2017 at 02:29 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Yasuhiro Okuda May 09, 2017 at 08:53 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded