sqlite64 driver - "The encryption property must be empty".. error

sqlite64 driver - "The encryption property must be empty".. error

Postby qplace » Sun 12 Feb 2017 03:41

I created an ODBC64 data source using trial version of DevArt ODBC sqlite driver ("direct" option is turned on, Win10pro) and I am trying to configure linked server in sql2014 using this datasource. I am getting following error while configuring the linked server :
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "eoddev".
OLE DB provider "MSDASQL" for linked server "eoddev" returned message "[Devart][ODBC][SQLite]The EncryptionKey property must be empty when no encryption algorithm specified". (Microsoft SQL Server, Error: 7303)


I did not configure encryption in ODBC. What could be the problem and how to fix it? Thanks.
qplace
 
Posts: 1
Joined: Sun 12 Feb 2017 03:20

Re: sqlite64 driver - "The encryption property must be empty".. error

Postby MaximG » Thu 16 Feb 2017 08:34

You get this error due to the incorrect driver configuration in the utility "ODBC Data Source Administrator". You specify the password to the encrypted DB file in the "Encryption Key" field, but do not select the used algorithm in the "Encrypt Algorithm" field. If you don't use encryption, leave the default value for these fields. Otherwise, you should specify both values "Encryption Key" and "Encrypt Algorithm".
MaximG
Devart Team
 
Posts: 745
Joined: Mon 06 Jul 2015 11:34


Return to ODBC Drivers