Re: [sqlite] Using SQLite on Windows 64bit
As a programmer, I just build my own 64 bit version of Sqlite. You should try it, it's easy. Just a matter of selecting "x64" when I compile. For my customers, 64 bit installs now outnumber 32 bit. Sqlite works just fine... C Saturday, October 29, 2011, 8:03:55 AM, you wrote: AO> Yes, compiling to 32-bit is nice. It is like dancing at the tunes of "Earth AO> Wind and Fire", h, those were the days. Like the old good songs, the AO> 32bit apps are a good memory, many people like it, but they are a thing of AO> the past. We are developers and anyone of us who stays behind, is left AO> behind. Not having the option of SQLite-64 is a major drawback and will AO> leave us behind. So, come on folks, pull up your socks and let's get the AO> SQLite apps into the 21st century, shall we? AO> AO> ___ AO> sqlite-users mailing list AO> sqlite-users@sqlite.org AO> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using SQLite on Windows 64bit
I have 64-bit binary package for my OS (kindly maintained by guy named Panu Matilainen, outside of the sqltie.org core team). I have installed this package after the command: yum install sqlite This currently installs 3.7.5 for me. If I want to test/use different version I type: fossill clone ..., fossil open version-3.7.8, ./configure, make, and I have 3.7.8 .so and shell. You are developer, what stops you to do something similar for your favorite OS? Then you can put this 64-bit build somewhere and announce this in favor to other users of the same OS in the list. Or you can ask your OS vendor (you are paying them If I remember well) to start maintain MSI for sqlite3. Why you are thinking that someone other is responsible for the lack of binary packages for your OS variant? On 29.10.2011 15:03, Arbol One wrote: Yes, compiling to 32-bit is nice. It is like dancing at the tunes of "Earth Wind and Fire", h, those were the days. Like the old good songs, the 32bit apps are a good memory, many people like it, but they are a thing of the past. We are developers and anyone of us who stays behind, is left behind. Not having the option of SQLite-64 is a major drawback and will leave us behind. So, come on folks, pull up your socks and let's get the SQLite apps into the 21st century, shall we? ___ 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] Using SQLite on Windows 64bit
Yes, compiling to 32-bit is nice. It is like dancing at the tunes of "Earth Wind and Fire", h, those were the days. Like the old good songs, the 32bit apps are a good memory, many people like it, but they are a thing of the past. We are developers and anyone of us who stays behind, is left behind. Not having the option of SQLite-64 is a major drawback and will leave us behind. So, come on folks, pull up your socks and let's get the SQLite apps into the 21st century, shall we? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using SQLite on Windows 64bit
Thank you, but it seems to be working now - I didn't have VC++2010 redist. Regards Jonathan - Original Message - From: Dimiter 'malkia' Stanev To: General Discussion of SQLite Database Sent: Friday, October 28, 2011 12:26 AM Subject: Re: [sqlite] Using SQLite on Windows 64bit I haven't used the SQLite .net modules, a coworker of mine did, and he ran into the same issue. It looks like that the bundled Managed .DLL (or was it native .DLL) was compiled for 32-bit, and his .NET application was set to "Default Mode". Once it was forced to be for 32-bit, it worked. This could be even changed from the command-line, but I forgot the tool doing it. I'll dig up, if you need to. Thanks! On 10/26/2011 2:17 AM, J Trahair wrote: > Hi. > > I want to install a VB.Net application onto a customer's Windows 64bit computer. > > I have my own Windows 64bit laptop with Visual Studio 2010 installed. I have a VB.Net application which uses SQLite successfully, both in the development runtime, and as an 'installed' program in a separate folder on the same laptop. > > However, I have installed the same installation setup.exe on a separate Windows 64bit computer, and it comes up with the error message > 'Could not load file or assembly System.Data.SQLite.dll or one of its dependencies, the specified module could not be found.' However, the System.Data.SQLite.dll IS there (v.1.0.76). What dependencies does it need (64bit)? > > Thanks in advance. > > Jonathan Trahair ___ 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] Using SQLite on Windows 64bit
I haven't used the SQLite .net modules, a coworker of mine did, and he ran into the same issue. It looks like that the bundled Managed .DLL (or was it native .DLL) was compiled for 32-bit, and his .NET application was set to "Default Mode". Once it was forced to be for 32-bit, it worked. This could be even changed from the command-line, but I forgot the tool doing it. I'll dig up, if you need to. Thanks! On 10/26/2011 2:17 AM, J Trahair wrote: Hi. I want to install a VB.Net application onto a customer's Windows 64bit computer. I have my own Windows 64bit laptop with Visual Studio 2010 installed. I have a VB.Net application which uses SQLite successfully, both in the development runtime, and as an 'installed' program in a separate folder on the same laptop. However, I have installed the same installation setup.exe on a separate Windows 64bit computer, and it comes up with the error message 'Could not load file or assembly System.Data.SQLite.dll or one of its dependencies, the specified module could not be found.' However, the System.Data.SQLite.dll IS there (v.1.0.76). What dependencies does it need (64bit)? Thanks in advance. Jonathan Trahair ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using SQLite on Windows 64bit
Got it! Thanks Joe. Regards Jonathan - Original Message - From: Joe Mistachkin To: 'General Discussion of SQLite Database' Sent: Wednesday, October 26, 2011 7:53 PM Subject: Re: [sqlite] Using SQLite on Windows 64bit J Trahair wrote: > > Works on my development 64bit machine, not on the customer's 64bit. > The most likely cause for it working on your development machine and not on your customer's machine is that you have the Microsoft Visual C++ 2010 Runtime Library installed and your customer does not. > > How do I get the interop? > With the "bundle" packages, you do not need it because the native SQLite code is compiled into the System.Data.SQLite.dll assembly itself. -- 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] Using SQLite on Windows 64bit
Not sure what is causing the problem..and thus my suggestion(s) can be labelled as trial and error --- 1. Check the target platform (try with x64 if it is 'any cpu'). Thanks & Regards Taleeb Anwar *Ghurbat men Hon Agar Hum, Rehta Hai Dil "Chicken" men!!* On Wed, Oct 26, 2011 at 11:09 PM, J Trahair wrote: > HI. > > There's no SQLite.Interop.dll, anywhere. > > I downloaded sqlite-netFx40-setup-bundle-x64-2010-1.0.76.0.exe which gave > me System.Data.SQLite.dll. > > Works on my development 64bit machine, not on the customer's 64bit. > > How do I get the interop? > > Thank you. > > Jonathan Trahair > > - Original Message - > From: Joe Mistachkin > To: 'General Discussion of SQLite Database' > Sent: Wednesday, October 26, 2011 3:20 PM > Subject: Re: [sqlite] Using SQLite on Windows 64bit > > > > J Trahair wrote: > > > > However, I have installed the same installation setup.exe on a separate > Windows > > 64bit computer, and it comes up with the error message 'Could not load > file or > > assembly System.Data.SQLite.dll or one of its dependencies, the > specified > module > > could not be found.' However, the System.Data.SQLite.dll IS there > (v.1.0.76). > > What dependencies does it need (64bit)? > > > > Is the SQLite.Interop.dll file in the same directory as the > System.Data.SQLite.dll > (or somewhere along the system PATH)? Alternatively, you could use the > mixed-mode > assembly, which contains both the native and managed code required for > using > SQLite > (i.e. it is more suitable for GAC'ing without having to alter the system > PATH, etc). > > -- > 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 > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using SQLite on Windows 64bit
J Trahair wrote: > > Works on my development 64bit machine, not on the customer's 64bit. > The most likely cause for it working on your development machine and not on your customer's machine is that you have the Microsoft Visual C++ 2010 Runtime Library installed and your customer does not. > > How do I get the interop? > With the "bundle" packages, you do not need it because the native SQLite code is compiled into the System.Data.SQLite.dll assembly itself. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using SQLite on Windows 64bit
HI. There's no SQLite.Interop.dll, anywhere. I downloaded sqlite-netFx40-setup-bundle-x64-2010-1.0.76.0.exe which gave me System.Data.SQLite.dll. Works on my development 64bit machine, not on the customer's 64bit. How do I get the interop? Thank you. Jonathan Trahair - Original Message - From: Joe Mistachkin To: 'General Discussion of SQLite Database' Sent: Wednesday, October 26, 2011 3:20 PM Subject: Re: [sqlite] Using SQLite on Windows 64bit J Trahair wrote: > > However, I have installed the same installation setup.exe on a separate Windows > 64bit computer, and it comes up with the error message 'Could not load file or > assembly System.Data.SQLite.dll or one of its dependencies, the specified module > could not be found.' However, the System.Data.SQLite.dll IS there (v.1.0.76). > What dependencies does it need (64bit)? > Is the SQLite.Interop.dll file in the same directory as the System.Data.SQLite.dll (or somewhere along the system PATH)? Alternatively, you could use the mixed-mode assembly, which contains both the native and managed code required for using SQLite (i.e. it is more suitable for GAC'ing without having to alter the system PATH, etc). -- 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] Using SQLite on Windows 64bit
J Trahair wrote: > > However, I have installed the same installation setup.exe on a separate Windows > 64bit computer, and it comes up with the error message 'Could not load file or > assembly System.Data.SQLite.dll or one of its dependencies, the specified module > could not be found.' However, the System.Data.SQLite.dll IS there (v.1.0.76). > What dependencies does it need (64bit)? > Is the SQLite.Interop.dll file in the same directory as the System.Data.SQLite.dll (or somewhere along the system PATH)? Alternatively, you could use the mixed-mode assembly, which contains both the native and managed code required for using SQLite (i.e. it is more suitable for GAC'ing without having to alter the system PATH, etc). -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users