Re: trying to do remote ODBC with Pyro4 and Flameserver

Andreas (and Irmen), yes that must be it. Apparently the result of a select
query returns a cursor object, that looks much like a dict, but is not the
same.
I found a possible solution by Michael Kleehammer (The BDFL for pyodbc)
here:
https://groups.google.com/forum/#!topic/pyodbc/BVIZBYGXNsk

Have to try it yet, busy with other things now...

Richard


2013/10/30 Andreas Kostyrka <[email protected]>

> In simple words, some of the values involved don't play nicely with.
>
> if you pass the result (it's probably the result) of your ODBC call
> through pickle.loads(pickle.dumps(...)) it will raise an exception
> too.
>
> One idea might be creating your own service, which takes the result
> and recreates them with basic python types?
>
>
>
> 2013/10/29 Richard van Bemmelen <[email protected]>:
> > I am trying to use Pyro4 to execute a remote ODBC python function.
> > This function runs fine on the remote machine.
> > When trying to run it remotely using the Flameserver I get:
> >
> > Traceback (most recent call last): File
> > "/Users/richard/Desktop/MyPython/remodbc.py", line 44, in <module>
> result =
> > flame.module("flame.stuff").query('') File
> > "/Library/Python/2.7/site-packages/Pyro4-4.22-py2.7.egg/Pyro4/core.py",
> line
> > 160, in __call__ return self.__send(self.__name, args, kwargs) File
> >
> "/Library/Python/2.7/site-packages/Pyro4-4.22-py2.7.egg/Pyro4/utils/flame.py",
> > line 81, in __invoke return self.flameserver._invokeModule(module, args,
> > kwargs) File
> > "/Library/Python/2.7/site-packages/Pyro4-4.22-py2.7.egg/Pyro4/core.py",
> line
> > 160, in __call__ return self.__send(self.__name, args, kwargs) File
> > "/Library/Python/2.7/site-packages/Pyro4-4.22-py2.7.egg/Pyro4/core.py",
> line
> > 314, in _pyroInvoke data = serializer.deserializeData(msg.data,
> > compressed=msg.flags & Pyro4.message.FLAGS_COMPRESSED) File
> > "/Library/Python/2.7/site-packages/Pyro4-4.22-py2.7.egg/Pyro4/util.py",
> line
> > 154, in deserializeData return self.loads(data) File
> > "/Library/Python/2.7/site-packages/Pyro4-4.22-py2.7.egg/Pyro4/util.py",
> line
> > 348, in loads return pickle.loads(data) cPickle.UnpicklingError: NEWOBJ
> > class argument has NULL tp_new
> >
> > Richard
> >
> >
> >
> ------------------------------------------------------------------------------
> > Android is increasing in popularity, but the open development platform
> that
> > developers love is also attractive to malware creators. Download this
> white
> > paper to learn more about secure code signing practices that can help
> keep
> > Android apps secure.
> >
> http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
> > _______________________________________________
> > Pyro-core mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/pyro-core
> >
>
>
> ------------------------------------------------------------------------------
> Android is increasing in popularity, but the open development platform that
> developers love is also attractive to malware creators. Download this white
> paper to learn more about secure code signing practices that can help keep
> Android apps secure.
> http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
> _______________________________________________
> Pyro-core mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/pyro-core
>

------------------------------------------------------------------------------
Android is increasing in popularity, but the open development platform that
developers love is also attractive to malware creators. Download this white
paper to learn more about secure code signing practices that can help keep
Android apps secure.
http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk

_______________________________________________
Pyro-core mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pyro-core