ODBC: Missing or invalid encryption DLL "dbrsa17.dll"

1

Using SQL Anywhere 17.0.4.2100 (authenticated edition)

I'm trying to deploy the minimal set of files needed for a 32bit ODBC-based client connnection. I've got to the point where I can add a new ODBC datasource using the Windows control panel program (ODBCAD32.exe) but when I click 'Test connection' I get this error:

Connection failed: Encryption error: Missing or invalid encryption DLL "dbrsa17.dll"

I've not included 'dbrsa17.dll' intentionally as the help file suggests that it's only needed for an encrypted connection, which I am not using. Is the error message correct and the DLL must always be included or is this a bug?

(in case it's relevant, the registry entries for my ODBC datasource are below)

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\test]
"Integrated"="NO"
"Host"="192.168.153.1:49152"
"Charset"="NONE"
"DatabaseName"="DBtest"
"Driver"="C:\\test\\dbodbc17.dll"
"ServerName"="ServerTest"
"SuppressWarnings"="YES"

asked 16 Aug '16, 05:56

Luke's gravatar image

Luke
711●15●23●36
accept rate: 40%

2 Answers:
active answersoldest answersnewest answerspopular answers
1

This is an error in the documentation. The dbrsa DLL must now always be installed.

permanent link

answered 16 Aug '16, 08:03

Mark%20Culp's gravatar image

Mark Culp
24.8k●9●139●296
accept rate: 41%

2

Thanks for the replies.

I've been using the local CHM version of the help files for reference and it looks like they have been updated since I installed them: the version I had was dated December 12 2015 and the page 'SQL Anywhere Server - Programming > Database and application deployment > Requirements for deploying client applications > ODBC client deployment > ODBC driver required files' did not mention dbrsa17.dll.

I've just updated to the latest version of the CHM files dated April 14 2016 and this page does now include dbrsa17.dll. Sorry for the confusion - I'd been assuming that the local help would be automatically updated as part of applying an EBF but now realise this isn't the case.

(16 Aug '16, 08:30) Luke
1

Can you point me at the documentation pages that suggest the DLL is only needed for encrypted connections? Those pages are incorrect.

This used to be true in v16 and earlier, but as of v17 both the client and server use this DLL for all connections. It must always be included.

Mark beat me to it by about 40 seconds.

permanent link

answered 16 Aug '16, 08:04

Graeme%20Perrow's gravatar image

Graeme Perrow
9.6k●3●79●124
accept rate: 54%

edited 16 Aug '16, 08:04

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

learn more about Markdown

Question tags:

×230
×144
×46

question asked: 16 Aug '16, 05:56

question was seen: 4,949 times

last updated: 16 Aug '16, 08:30

Related questions

Odbc driver issue with SQLA17

Verifying Table Data is Encrypted with Simple

Password encryption for ODBC

Performance Implications for Increasing Encryption from AES128 to AES256

How to configure ODBC to work with PHP under linux?

SA-17 Purchase Order Suspended

how to install only ODBC driver

simple encryption question

port for ODBC client connection

Backups suddenly failing