RE: [sqlite] ANN: sqlite3Explorer V 1.7
good to know... > -Original Message- > From: Dennis Jenkins [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 27, 2005 4:26 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] ANN: sqlite3Explorer V 1.7 > > Dennis Jenkins wrote: > > > Cariotoglou Mike wrote: > > > >> *. new feature : support for encrypted databases (WITH the > licenced > >> version of sqlite) > >> > >> http://www.singular.gr/sqlite/ > >> > >> > > > > Awesome! Thanks! I was hoping that you would add > encryption support. > > :) (We purchased our license a few weeks ago). > > > > However, I am unable to get it to work. I am 100% sure that I am > > entered the encryption key when prompted for it. > > > > :) Never mind. I solved my problem. I forgot to define > 'SQLITE_HAS_CODEC=1' when compiling the DLL. It works great now. > (previously I was getting error '26', "not a database, or encrypted"). > > > >
Re: [sqlite] ANN: sqlite3Explorer V 1.7
Dennis Jenkins wrote: Cariotoglou Mike wrote: *. new feature : support for encrypted databases (WITH the licenced version of sqlite) http://www.singular.gr/sqlite/ Awesome! Thanks! I was hoping that you would add encryption support. :) (We purchased our license a few weeks ago). However, I am unable to get it to work. I am 100% sure that I am entered the encryption key when prompted for it. :) Never mind. I solved my problem. I forgot to define 'SQLITE_HAS_CODEC=1' when compiling the DLL. It works great now. (previously I was getting error '26', "not a database, or encrypted").
Re: [sqlite] ANN: sqlite3Explorer V 1.7
Cariotoglou Mike wrote: *. new feature : support for encrypted databases (WITH the licenced version of sqlite) http://www.singular.gr/sqlite/ Awesome! Thanks! I was hoping that you would add encryption support. :) (We purchased our license a few weeks ago). However, I am unable to get it to work. I am 100% sure that I am entered the encryption key when prompted for it. I can access the database using the command line version of the encryption database shell program (made from shell.c). I rekeyed my database to use the key "hello". I still have no luck with sqlite explorer. Any suggestions? Here are my DLL exports: (from tdump, borland 5.0 compiler). Note that I compiled the DLL using MSDEV v6.0 (I just like the borland command line 'tdump' tool for dumping PE (exe, dll) files): Turbo Dump Version 4.2.16.1 Copyright (c) 1988, 1996 Borland International Display of File \BIN\SQLITE3.DLL Old Executable Header DOS File Size 3B000h (241664. ) Load Image Size 450h ( 1104. ) Relocation Table entry count h ( 0. ) Relocation Table address 0040h (64. ) Size of header record (in paragraphs)0004h ( 4. ) Minimum Memory Requirement (in paragraphs)h ( 0. ) Maximum Memory Requirement (in paragraphs)h ( 65535. ) File load checksumh ( 0. ) Overlay Numberh ( 0. ) Initial Stack Segment (SS:SP) :00B8 Program Entry Point(CS:IP) : Portable Executable (PE) File Header base: 00C8 CPU type 80386 Flags210E [ executable backwards 32bit library ] DLL flags [ ] Linker Version 6.0 Time stamp 42E7860B O/S Version 4.0 User Version 0.0 Subsystem Version4.0 Subsystem0002 [ Windows GUI ] Object count 0004 Symbols offset Symbols count Optional header size 00E0 Magic # 10B Code size0002F000 Init Data size B000 Uninit Data size Entry RVA0002F38D Image base 1000 Code base1000 Data base0003 Object/File align1000/1000 Reserved Image size 0003B000 Header size 1000 Checksum Stack reserve/commit 0010/1000 Heap reserve/commit 0010/1000 Number interesting RVAs 0010 Name RVA Size -- Exports 00033780 0B07 Imports 0003348C 003C Resources Exceptions Security Fixups 00039000 1224 Debug Description TLS Callbacks reserved reserved0003 009C reserved reserved reserved Object table: # Name VirtSizeRVA PhysSize Phys off Flags -- 01 .text 0002E450 1000 0002F000 1000 6020 [CER] 02 .rdata4287 0003 5000 0003 4040 [IR] 03 .data 325C 00035000 4000 00035000 C040 [IRW] 04 .reloc1318 00039000 2000 00039000 4240 [IDR] Key to section flags: C - contains code D - discardable E - executable I - contains initialized data R - readable W - writeable Imports from KERNEL32.dll DeleteFileA(hint = 007c) GetFileAttributesA(hint = 0156) CreateFileA(hint = 004d) GetTempPathA(hint = 01cb) CloseHandle(hint = 002e) ReadFile(hint = 02ab) WriteFile(hint = 0397) SetFilePointer(hint = 0310) FlushFileBuffers(hint = 00e5) SetEndOfFile(hint = 0305) GetFileSize(hint = 015b) GetVersionExA(hint = 01df) UnlockFile(hint = 0363) Sleep(hint = 0349) LockFile(hint = 0259) LockFileEx(hint = 025a) GetSystemTime(hint = 01be) GetFullPathNameA(hint = 0161) GetSystemTimeAsFileTime(hint = 01c0) DisableThreadLibraryCalls(hint = 0084) Imports from MSVCRT.dll _isctype(hint = 0115) __mb_cur_max(hint = 0061) sprintf(hint = 02b2) _iob(hint = 0113) _ftol(hint = 00f1) strncmp(hint = 02c0) tolower(hint = 02d3) localtime(hint = 028d) atoi(hint = 023d) toupper(hint = 02d4) malloc(hint = 0291) free(hint = 025e) strncpy(hint = 02c1) realloc(hint =