Thank you very much for your help. The problem was in iTUNES. I removed it and
no more problem. I then downloaded a new free version and the problem was
solved.
Dr. Robert N. Cleaves
-Original Message-
From: Kees Nuyt [mailto:k.n...@zonnet.nl]
Sent: Wednesday, December 23, 2009 3:19 PM
To: Dr. Robert N. Cleaves
Cc: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite3_prepare_v2
On Wed, 23 Dec 2009 16:50:08 -0500, "D. Richard Hipp"
wrote:
>
>On Dec 23, 2009, at 4:12 PM, Dr. Robert N. Cleaves wrote:
>
>> Dear Sir:
>>
>> On startup, I get a message that the procedure entry point
>> sqlite3_prepare_v2 is missing from the dynamic link library
>> SQLite3.dll. How can I download the missing item?
>>
>> Thank you…
>
>I'm guessing you are running windows. Probably you have two or more
>applications installed that use SQLite. (Candidates applications
>include Skype, Google Gears, Firefox, McAfee Antivirus, Adobe
>Acroread, Adobe Photoshop, iTunes, DropBox, and many others.)
>Probably when one of these applications was installing itself, it
>overwrote the system SQLite3.dll with an older version that does not
>support the sqlite3_prepare_v2() interface. Then when one of the
>other applications that needs the new interface tries to run, it gets
>the older DLL that lacks the necessary entry point.
>
>I beg and plead with application vendors to statically link against
>SQLite to avoid this kind of problem, but nobody listens to me about
>that
>
>I don't use windows myself and so I won't be much help in
>troubleshooting this.
>But I have forwarded this reply to the SQLite
>mailing list where there are lots of windows users. Perhaps someone
>there can explain what needs to be done
Dear Robert,
Richards Hipps diagnosis is almost certainly correct.
My "plan de campagne" would be:
1) Use the search function in Windows Explorer to find all
occurrences of sqlite3.dll on your harddisk(s).
2) Make a note of the folder they reside in.
3) Download the current version of sqlite3.dll (zipped) from
http://www.sqlite.org/sqlitedll-3_6_21.zip
4) Unzip or open the zip file, it contains the needed .dll
5) Replace sqlite3.dll in system folders, like C:\Windows\ ,
C:\Windows\System\ , C:\Windows\System32\ and the like, but
only if listed in step 2). Do not replace sqlite3.dll in
application folders yet, like C:\Program Files\ and
everything below that folder.
6) Reboot your computer, verify the error has disappeared.
If so: congratulations.
7) Only if the problem persists, replace all other
occurences of sqlite3.dll , in all other folders you listed
in 2).
The chance this action will introduce new incompatibilities
is small. Most applications will not notice the difference,
Richard Hipp and his team are very careful with upward
compatibility.
Software that doesn't work correctly can be reinstalled.
If that doesn't help, write your exact findings to the
sqlite-users@sqlite.org mailing list. Let us know the
Operating System you use and which version it had, and the
version of the application which has problems.
Disclaimer: I can not take any responsibility for any damage
this repair may cause. If you are uncertain about it, you'd
better have a qualified system administrator look at your
computer.
>> Dr. Robert N. Cleaves
>> President
>> Wilderness Conservancy
>> and Project CARE
>> www.wildcon.org
>> b...@wildcon.org
>> (310) 472-2593
>>
>
>D. Richard Hipp
>d...@hwaci.com
--
( Kees Nuyt
)
c[_]
--
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 37 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len
The Professional version does not have this message
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users