Re: [sqlite] Interop DLL question

2011-05-20 Thread Michael Yeaney
> Meanwhile, perhaps, if you rephrase your goal and post again here on the
> list, someone with experience in your environment (I'm NOT one of
> those) will respond. I'm _guessing_ that you _don't_ mean to ask for the
> xcopy command syntax itself:
>

Correct - what I'm looking for is the ability to "Add Reference...",
publish the project, and run. I actually got past the issues of adding
the interop DLL as static content to the cloud package (as you pointed
out), and after a remote desktop session to one of the nodes, verified
it is indeed there. The problem seems to be, however, that the
directory that the interop DLL lives in is _not_ the same directory
that the hosting EXE (WaWorkerHost.exe, in the Azure case) lives in.

This may very well be a side-effect of the Azure environment (I'm
posted forum questions about this very topic), but the hope was a
single assembly would solve it either way.

Feedback welcome...thanks!
Michael
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Interop DLL question

2011-05-20 Thread Kevin Benson
 On Fri, May 20, 2011 at 12:10 AM, Michael Yeaney
wrote:

> For the 1.0.72.0 (3.7.6+) package (x64), is there a stand-alone (mixed
> mode) DLL offered anymore that does not require the interop library
> (much like the 1.0.66.0 version?


Not currently, as Shane mentions (and as quoted from under Build
Assumptions in the wiki):
http://system.data.sqlite.org/index.html/doc/trunk/www/build.wiki

"3. We do not want to ship the "monster DLL" (i.e. the "mixed-mode"
System.Data.SQLite.dll that includes native and managed code). This will
make it far simpler to maintain and ship the included core SQLite code (in
the file "SQLite.Interop.dll")."


> I'm using SQLite successfully in a
> few Microsoft Azure deployments, but with the new version, the servers
> are not able to locate the "SQLite.Interop.dll" library, as it is not
> in any search paths on the cloud machines. The goal here is simple
> xcopy deployment (in other words _not_ requiring GAC registration).
>
> Ideas? I'm assuming I'm missing something...but I just can't find it.
>

Meanwhile, perhaps, if you rephrase your goal and post again here on the
list, someone with experience in your environment (I'm NOT one of
those) will respond. I'm _guessing_ that you _don't_ mean to ask for the
xcopy command syntax itself:

xcopy /d /y $(ProjectDir)SQLite.Interop.dll $(TargetDir)

that when added to a Visual Studio project as a postbuild event _and_ the
separate SQLite.Interop.dll library has been copied to your project or
release folder  ...would, I guess be "simulating" the desired sequence
of setting the Build Action = "Content" _and_ Copy to Output Directory =
"Copy if Newer" (or "Copy Always") as described here:

http://blogs.msdn.com/b/jnak/archive/2009/01/28/adding-files-to-your-windows-azure-service-package.aspx

Good luck.
--
   --
  --
 --ô¿ô--
K e V i N
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Interop DLL question

2011-05-20 Thread Shane Harrelson
Switching to a "single format" greatly simplified things from an
"administrative" point of view - giving us a consistent single "packaging"
format across all platforms (Windows, Mono, Compact, ARM, etc.)  - a support
customer even specifically pointed out this made things much easier for them
as well.

However, cases like yours, and cases where inexperienced users didn't catch
some of the subtleties of the packaging change, are causing us to rethink
this.
We're currently discussing whether to revert back to offering a "mixed-mode"
DLL in addition to the current packages.

Thanks for you input.
-Shane



On Fri, May 20, 2011 at 12:10 AM, Michael Yeaney
wrote:

> For the 1.0.72.0 (3.7.6+) package (x64), is there a stand-alone (mixed
> mode) DLL offered anymore that does not require the interop library
> (much like the 1.0.66.0 version?  I'm using SQLite successfully in a
> few Microsoft Azure deployments, but with the new version, the servers
> are not able to locate the "SQLite.Interop.dll" library, as it is not
> in any search paths on the cloud machines. The goal here is simple
> xcopy deployment (in other words _not_ requiring GAC registration).
>
> Ideas? I'm assuming I'm missing something...but I just can't find it.
>
> Many thanks!
> ___
> 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] Interop DLL question

2011-05-19 Thread Michael Yeaney
For the 1.0.72.0 (3.7.6+) package (x64), is there a stand-alone (mixed
mode) DLL offered anymore that does not require the interop library
(much like the 1.0.66.0 version?  I'm using SQLite successfully in a
few Microsoft Azure deployments, but with the new version, the servers
are not able to locate the "SQLite.Interop.dll" library, as it is not
in any search paths on the cloud machines. The goal here is simple
xcopy deployment (in other words _not_ requiring GAC registration).

Ideas? I'm assuming I'm missing something...but I just can't find it.

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