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

[Former Member]

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"

[MarkCulp · Accepted solution]

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

[Former Member · Accepted solution]

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.

[graeme_perrow]

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.