Re: [sqlite] Problems building/running SQLite test.exe with ICU enabled

[Marc Henrickson]

I copied those dll files to my folder and still get the same error.

-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 
On Behalf Of Joe Mistachkin
Sent: Monday, October 03, 2011 4:14 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] Problems building/running SQLite test.exe with ICU enabled


Your list does not seem to include the ICU DLLs that I mentioned, including:

icuuc48.dll
icuin48.dll

The necessary ICU files can be obtained from the official web site:

http://site.icu-project.org/

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems building/running SQLite test.exe with ICU enabled

[Joe Mistachkin]

Your list does not seem to include the ICU DLLs that I mentioned, including:

icuuc48.dll
icuin48.dll

The necessary ICU files can be obtained from the official web site:

http://site.icu-project.org/

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems building/running SQLite test.exe with ICU enabled

[Marc Henrickson]

All DLL's are in the same folder.
Test.exe
SQLite.Interop.DLL
System.Data.SQLite.DLL

We have tried everything and cannot get this to run with ICU enabled.

Is there somewhere I can post my VS project files so someone can look at this?  
It seems like it should be pretty straightforward, but nothing seems to work.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems building/running SQLite test.exe with ICU enabled

[Joe Mistachkin]

Marc Henrickson wrote:
> 
> System.Reflection.TargetInvocationException: Exception has been thrown by
the target of an invocation. --->
> System.TypeInitializationException: The type initializer for
'System.Data.SQLite.SQLiteFactory' threw an exception. ---> 
> System.DllNotFoundException: Unable to load DLL 'SQLite.Interop.DLL': The
specified module could not be found. (Exception from 
> HRESULT: 0x8007007E)
>at System.Data.SQLite.UnsafeNativeMethods.sqlite3_config(Int32 op,
SQLiteLogCallback func, IntPtr pvUser)
>at System.Data.SQLite.SQLite3.SetLogCallback(SQLiteLogCallback func) in
c:\SQLiteTest\System.Data.SQLite\SQLite3.cs:line 935
>at System.Data.SQLite.SQLiteFactory..ctor() in
c:\SQLiteTest\System.Data.SQLite\SQLiteFactory.cs:line 121
>at System.Data.SQLite.SQLiteFactory..cctor() in
c:\SQLiteTest\System.Data.SQLite\SQLiteFactory.cs:line 131
> 

Please make sure the necessary ICU DLLs are located in the same directory as
the SQLite.Interop.dll OR somewhere along your PATH and the problem should
go away.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems building/running SQLite test.exe with ICU enabled

[Alexey Pechnikov]

Yes, on linux host I have a lot of problems in SQLite tests with ICU enabled.

2011/9/30 Marc Henrickson :
> I have downloaded the SQLite source code (sqlite-netFx-source-1.0.74.0) as 
> well as the latest ICU libraries (icu4c-4_8-Win32-msvc10).  I then build the 
> SQLite projects and run the test.2008 application and it runs fine when 
> SQLITE_ENABLE_ICU is undefined.  However, when I do define SQLITE_ENABLE_ICU, 
> I get the following exception when I click "Run" on the test.exe application.
>
> System.Reflection.TargetInvocationException: Exception has been thrown by the 
> target of an invocation. ---> System.TypeInitializationException: The type 
> initializer for 'System.Data.SQLite.SQLiteFactory' threw an exception. ---> 
> System.DllNotFoundException: Unable to load DLL 'SQLite.Interop.DLL': The 
> specified module could not be found. (Exception from HRESULT: 0x8007007E)
>   at System.Data.SQLite.UnsafeNativeMethods.sqlite3_config(Int32 op, 
> SQLiteLogCallback func, IntPtr pvUser)
>   at System.Data.SQLite.SQLite3.SetLogCallback(SQLiteLogCallback func) in 
> c:\SQLiteTest\System.Data.SQLite\SQLite3.cs:line 935
>   at System.Data.SQLite.SQLiteFactory..ctor() in 
> c:\SQLiteTest\System.Data.SQLite\SQLiteFactory.cs:line 121
>   at System.Data.SQLite.SQLiteFactory..cctor() in 
> c:\SQLiteTest\System.Data.SQLite\SQLiteFactory.cs:line 131
>
> I am building and running the application with Visual Studio 2008 on a 
> Windows 7 64-bit machine.
> SQLite.Interop.2008 is set to the Win32 configuration.
> Both test.2008 and System.Data.SQLite.2008 projects are set to x86 
> configuration.
>
> I have updated the SQLite.Interop.2008 project to build the 
> SQLite.Interop.DLL and both the Interop.DLL and the System.Data.SQLite.DLL is 
> included in the test.exe folder.  I have also updated the SQLite.Interop.2008 
> project to include the proper ICU library files.  The project builds without 
> error and the test.exe will open up the main window.  I get the exception 
> when clicking "Run".  When I remove the SQLITE_ENABLE_ICU definition from the 
> SQLite.Interop.2008 project, it will build, and run as expected without error.
>
> Has anyone seen this before, and have a solution?  I am happy to provide more 
> details if needed.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems building/running SQLite test.exe with ICU enabled

[Marc Henrickson]

What I'm looking for is to be able to compile SQLite with ICU enabled and have 
the test application run at all.  I don't necessarily need to debug or run from 
the IDE.  It seems no matter which configuration I use, or which settings I 
tweak, nothing will work.  

In order to get the test application to not error out when I click "Run", I 
have to have my project configured as follows:
SQLite.Interop.2008 set to Win32
System.Data.SQLite.2008 set to x86 or AnyCPU
test.2008 set to x86
If those are set up like that, then the test.exe will run properly only if ICU 
is NOT enabled.  Using those same project configurations will cause test.exe to 
fail if ICU is enabled.

Why does enabling ICU cause it to fail, when it would work fine without ICU 
enabled?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems building/running SQLite test.exe with ICU enabled

[Joe Mistachkin]

>
> System.Reflection.TargetInvocationException: Exception has been thrown by
the target of an invocation. --->
> System.TypeInitializationException: The type initializer for
'System.Data.SQLite.SQLiteFactory' threw an exception. --->
> System.DllNotFoundException: Unable to load DLL 'SQLite.Interop.DLL': The
specified module could not be found.
> (Exception from HRESULT: 0x8007007E)
> 

This exception is almost always caused by a failure to locate the DLL in
question (i.e. SQLite.Interop.dll).  If you are building from source and
wish to run the test executable from within the IDE, you'll need to select
"DebugNativeOnly" or "ReleaseNativeOnly" as the build configuration.  Also,
if you want to debug a "pure" managed process, like the test executable, on
an x64 machine, you will need to set the platform to x64, not Win32;
otherwise, you'll simply get a BadImageFormatException when the managed
process (which will actually start as a 64-bit process) tries to load a
32-bit SQLite.Interop.dll.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Problems building/running SQLite test.exe with ICU enabled

[Marc Henrickson]

I have downloaded the SQLite source code (sqlite-netFx-source-1.0.74.0) as well 
as the latest ICU libraries (icu4c-4_8-Win32-msvc10).  I then build the SQLite 
projects and run the test.2008 application and it runs fine when 
SQLITE_ENABLE_ICU is undefined.  However, when I do define SQLITE_ENABLE_ICU, I 
get the following exception when I click "Run" on the test.exe application.

System.Reflection.TargetInvocationException: Exception has been thrown by the 
target of an invocation. ---> System.TypeInitializationException: The type 
initializer for 'System.Data.SQLite.SQLiteFactory' threw an exception. ---> 
System.DllNotFoundException: Unable to load DLL 'SQLite.Interop.DLL': The 
specified module could not be found. (Exception from HRESULT: 0x8007007E)
   at System.Data.SQLite.UnsafeNativeMethods.sqlite3_config(Int32 op, 
SQLiteLogCallback func, IntPtr pvUser)
   at System.Data.SQLite.SQLite3.SetLogCallback(SQLiteLogCallback func) in 
c:\SQLiteTest\System.Data.SQLite\SQLite3.cs:line 935
   at System.Data.SQLite.SQLiteFactory..ctor() in 
c:\SQLiteTest\System.Data.SQLite\SQLiteFactory.cs:line 121
   at System.Data.SQLite.SQLiteFactory..cctor() in 
c:\SQLiteTest\System.Data.SQLite\SQLiteFactory.cs:line 131

I am building and running the application with Visual Studio 2008 on a Windows 
7 64-bit machine.
SQLite.Interop.2008 is set to the Win32 configuration.
Both test.2008 and System.Data.SQLite.2008 projects are set to x86 
configuration.

I have updated the SQLite.Interop.2008 project to build the SQLite.Interop.DLL 
and both the Interop.DLL and the System.Data.SQLite.DLL is included in the 
test.exe folder.  I have also updated the SQLite.Interop.2008 project to 
include the proper ICU library files.  The project builds without error and the 
test.exe will open up the main window.  I get the exception when clicking 
"Run".  When I remove the SQLITE_ENABLE_ICU definition from the 
SQLite.Interop.2008 project, it will build, and run as expected without error.

Has anyone seen this before, and have a solution?  I am happy to provide more 
details if needed.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users