UniDAC 3.50.0.14 SQLite3.7.4 EncryptionKey ERROR

execoma · Post by **execoma** » Thu 27 Jan 2011 14:27

Hello, I am using the latest versions of UniDAC 3.50.0.14 and SQLite.DLL 3.7.4 (http://www.sqlite.org/download.html - sqlite-dll-win32-x86-3070400.zip).
I have encrypted SQLite DB (created in SQLiteManager). I drop TUniConnection and TSQLiteUniProvider on the form in RAD STUDIO XE C++ Builder XE. My OS is Windows 7 x64. In TUniConnection I set provider = SQLite, set way to the my SQLite DB file and set way to the ClientLibrary (SQLite.DLL 3.7.4). IF I SET MY ENCRYPTION KEY (123) AND CLICK "Connect" button, then I have an error:
"SQLite function is not linked"

Details >>

Code: Select all

[159B3151]{liteprovider150.bpl} Litecalluni. + $0
[159B6121]{liteprovider150.bpl} Liteclassesuni.TLiteConnection.Connect + $16D
[0A701849]{dac150.bpl  } Dbaccess.TCustomDAConnection.DoConnect + $C1
[0A8C0CFB]{unidac150.bpl} Uni.TUniConnection.DoConnect + $2F
[0A701B5F]{dac150.bpl  } Dbaccess.TCustomDAConnection.PerformConnect + $37
[0A7CA4F0]{dcldac150.bpl} Daconnectioneditor.TDAConnectionEditorForm.PerformConnect + $8
[0A7CA2AF]{dcldac150.bpl} Daconnectioneditor.TDAConnectionEditorForm.btConnectClick + $3F
[5027E4DF]{vcl150.bpl  } Controls.TControl.Click (Line 7190, "Controls.pas" + 9) + $8
[502B59FA]{vcl150.bpl  } StdCtrls.TCustomButton.Click (Line 4562, "StdCtrls.pas" + 3) + $2
[502B64E8]{vcl150.bpl  } StdCtrls.TCustomButton.CNCommand (Line 5023, "StdCtrls.pas" + 1) + $D
[5027DF74]{vcl150.bpl  } Controls.TControl.WndProc (Line 7074, "Controls.pas" + 91) + $6
[50282838]{vcl150.bpl  } Controls.TWinControl.WndProc (Line 9831, "Controls.pas" + 144) + $6
[502B56C4]{vcl150.bpl  } StdCtrls.TButtonControl.WndProc (Line 4409, "StdCtrls.pas" + 13) + $4
[5027DB98]{vcl150.bpl  } Controls.TControl.Perform (Line 6852, "Controls.pas" + 10) + $8
[5028298B]{vcl150.bpl  } Controls.DoControlMsg (Line 9900, "Controls.pas" + 12) + $11
[502833E7]{vcl150.bpl  } Controls.TWinControl.WMCommand (Line 10172, "Controls.pas" + 1) + $5
[5027DF74]{vcl150.bpl  } Controls.TControl.WndProc (Line 7074, "Controls.pas" + 91) + $6
[50282838]{vcl150.bpl  } Controls.TWinControl.WndProc (Line 9831, "Controls.pas" + 144) + $6
[50281ED8]{vcl150.bpl  } Controls.TWinControl.MainWndProc (Line 9552, "Controls.pas" + 3) + $6
[500B067C]{rtl150.bpl  } Classes.StdWndProc (Line 13491, "Classes.pas" + 8) + $0
[50282938]{vcl150.bpl  } Controls.TWinControl.DefaultHandler (Line 9872, "Controls.pas" + 30) + $17
[5027E930]{vcl150.bpl  } Controls.TControl.WMLButtonUp (Line 7323, "Controls.pas" + 1) + $6
[5027DF74]{vcl150.bpl  } Controls.TControl.WndProc (Line 7074, "Controls.pas" + 91) + $6
[502820CB]{vcl150.bpl  } Controls.TWinControl.IsControlMouseMsg (Line 9608, "Controls.pas" + 1) + $9
[50282838]{vcl150.bpl  } Controls.TWinControl.WndProc (Line 9831, "Controls.pas" + 144) + $6
[502B56C4]{vcl150.bpl  } StdCtrls.TButtonControl.WndProc (Line 4409, "StdCtrls.pas" + 13) + $4
[50281ED8]{vcl150.bpl  } Controls.TWinControl.MainWndProc (Line 9552, "Controls.pas" + 3) + $6
[500B067C]{rtl150.bpl  } Classes.StdWndProc (Line 13491, "Classes.pas" + 8) + $0
[50358AFF]{vcl150.bpl  } Forms.TApplication.ProcessMessage (Line 9760, "Forms.pas" + 23) + $1
[50358B42]{vcl150.bpl  } Forms.TApplication.HandleMessage (Line 9790, "Forms.pas" + 1) + $4
[503544A1]{vcl150.bpl  } Forms.TCustomForm.ShowModal (Line 6648, "Forms.pas" + 33) + $5
[0A7C9C5E]{dcldac150.bpl} Daconnectioneditor.TDAConnectionEditorForm.SetComponent + $E
[0A7E93A0]{dcldac150.bpl} Crdesign.TCRComponentEditor.ShowEditorEx + $8C
[0A7E92EE]{dcldac150.bpl} Crdesign.TCRComponentEditor.ShowEditor + $32
[0A7E96B7]{dcldac150.bpl} Crdesign.TCRComponentEditor.Edit + $B
[21077121]{designide150.bpl} ComponentDesigner.TInternalItem.Edit (Line 7094, "ComponentDesigner.pas" + 1) + $F
[2103F1E8]{designide150.bpl} Designer.TDesigner.Edit (Line 964, "Designer.pas" + 0) + $4
[2104145F]{designide150.bpl} Designer.TDesigner.MouseDown (Line 1658, "Designer.pas" + 45) + $6
[51B191E1]{vcldesigner150.bpl} VCLSurface.TComponentToolWindow.WndProc (Line 1327, "VCLSurface.pas" + 16) + $32
[51B19C7E]{vcldesigner150.bpl} VCLSurface.TContainer.WndProc (Line 1627, "VCLSurface.pas" + 39) + $6
[15013469]{cxLibraryRS15.bpl} Cxcontainer.TcxCustomInnerListBox.CNDrawItem + $695
[51B19003]{vcldesigner150.bpl} VCLSurface.TDesignerToolWindow.MainWndProc (Line 1262, "VCLSurface.pas" + 2) + $7
[500B067C]{rtl150.bpl  } Classes.StdWndProc (Line 13491, "Classes.pas" + 8) + $0
[50278AAE]{vcl150.bpl  } Controls.FindControl (Line 3378, "Controls.pas" + 6) + $9
[50358AFF]{vcl150.bpl  } Forms.TApplication.ProcessMessage (Line 9760, "Forms.pas" + 23) + $1
[50358B42]{vcl150.bpl  } Forms.TApplication.HandleMessage (Line 9790, "Forms.pas" + 1) + $4
[50358E6D]{vcl150.bpl  } Forms.TApplication.Run (Line 9927, "Forms.pas" + 26) + $3
[004ACCE2]{bds.exe     } bds.bds (Line 201, "" + 8) + $FFFB

But if I don't set encryption key and click "Connect" button, then no error, but I don't work with DB file, because file is encrypted.

Please help me as soon as possible.

AlexP · Post by **AlexP** » Fri 28 Jan 2011 08:49

Hello,

The problem is connected with the fact that encryption functions are not available in the public release of SQLite.
As I can see, SQLiteManager uses its own *.dll to access SQLite.
So you need to use sqlite.dll which support encryption.