dll - Why doesn't Azure load properly the Interop? -

-

i have webapp on azure uses dll. library needs interop libraries x86 , x64. sometimes, @ restart of app (i suppose), app fails due exception:

system.entrypointnotfoundexception: unable find entry point named    'sqlite3_config' in dll 'sqlite.interop.dll'. @ system.data.sqlite.unsafenativemethods.sqlite3_config_none(sqliteconfigopsenum op) @ system.data.sqlite.sqlite3.staticisinitialized() @ system.data.sqlite.sqlitelog.initialize() @ system.data.sqlite.sqliteconnection..ctor(string connectionstring, boolean parseviaframework) @ t_dox.webservice.sqlitedb.createconnection() @ webservice.cedb.connect()

the sqlite used sqlcipher's one. missing here? don't understand why app stops working if don't make changes.

the app web service (.asmx file) uses data access layer perform business logic.

it under web site project, moved project, webapi\mvc project. routing bypasses extension, works before, simple web service call.

the called web method initializes business class loaded .net library (a vb.net library). inside, class uses wrapper sqlconnection, in case sqliteconnection. in constructor starts sqliteconnection, , works. performs crud operations ...

so can represent operation way:

[webservice(namespace = "...")] [webservicebinding(conformsto = wsiprofiles.basicprofile1_1)] public class sampleservice : system.web.services.webservice {     [webmethod]     public serverinfo test()     {          var samplebusinessclass = new samplebusinessclass();          samplebusinessclass.dosomething();            using(var connection = new sqliteconnection()) //the constructor parameterless 1                            {             //...          }               } }

and stack (this not real one):

system.entrypointnotfoundexception: unable find entry point named 'sqlite3_config' in dll 'sqlite.interop.dll'.  @ system.data.sqlite.unsafenativemethods.sqlite3_config_none(sqliteconfigopsenum op)  @ system.data.sqlite.sqlite3.staticisinitialized()  @ system.data.sqlite.sqlitelog.initialize()  @ system.data.sqlite.sqliteconnection..ctor(string connectionstring, boolean parseviaframework)  @ xxx.webservice.sampleservice.test()

it works, starts launch error until stop , start of web application on iss (in our case: azure).

inspecting system.data.sqlite.dll can see entry point , passes internal code (no conditions can bypass part) , works.

the system.data.sqlite.dll (1.0.96.0 version) provided sqlcypher product. think original system.data.sqlite 1 because @ first sight can see same assembly manifest , content. interop system.data.sqlite uses modified sqlcypher team give features. avoid possible issues put interop in path /bin/x64, compile our web app in x64 , runs on x64 environment.


Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5);
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:
Read more

Python Pig Latin Translator -

-
so have been working on @ codecademy.com while trying learn python. don't know if blind , can't see why won't work or what. here's code won't let me use. function print variable if had typed in , print "empty" if didn't type anything. print "welcome english pig latin translator!" original = raw_input("what's name?") if len(original) > 0 print original else print "empty" if len(original) > 0 else the above lines contains syntax errors. try: if len(original) > 0: else: note added colons, ( : ).
Read more