Thanks for your response.
I've already stared at that page for quite some time. It is there that I
(erroneously) assumed that my dll needed to be compiled differently so that
sqlite3_enable_load_extension is turned on ("...the entire extension loading
mechanism is turned off by default...").
To enable the extension loading mechanism, first invoke this API:
int sqlite3_enable_load_extension(sqlite3 *db, int onoff);
"invoke this API" makes me think of some particular command I can pass to
sqlite3.dll but I had no idea HOW to do this in my context (AutoIt3). Not
seeing anything that looked like a WAY to "invoke this API", I concluded
that it must be something "invoked" in the C code itself and then recompiled
differently. Pardon me if that seems silly, but that's where I am in my
understanding of how to interact with dll's directly from a scripting
language.
BUT, your email made me look more closely, and I can see in the AutoIt layer
that does the calls to sqlite3.dll that they are formed like that command
there. So, I tried to clone that command into one of the AutoIt calls and
it looks as if my error (authorization) has gone away. Much more discovery
and debugging to do, but perhaps this hurdle is now surmounted!
A suggestion:
The more that SQLite is used in context with different languages (i.e.
higher and higher levels), with interface layers written for us dummies, the
more that we will stumble when we see that sort of command...that doesn't
look like a high-level scripting language call. Perhaps a little dummy text
that "this is a call to a dll that you're making in your programming
language. "int" is what's being returned. "sqlite3_enable_load_extension"
is the function name, etc. "onoff" should be replaced by something that
evaluates to 1 or 0, etc.
Perhaps that's stupid, but it wasn't quite clear enough for me the first
time around.
Thanks again for a great product!
David Leigh
-----Original Message-----
"David Leigh" <[EMAIL PROTECTED]> wrote:
>
> What I'm asking for is either:
> * A windows sqlite3.dll with the ability to load extensions turned on
Call sqlite3_enable_load_extension(db, 1). See the documentation
under "Security Details" at
http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions
I suppose I should probably add this API to the capi3ref.html
documentation page too....
--
D. Richard Hipp <[EMAIL PROTECTED]>
----------------------------------------------------------------------------
-
To unsubscribe, send email to [EMAIL PROTECTED]
----------------------------------------------------------------------------
-
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
