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" <d...@hwaci.com> 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
