On Jan 28, 1:52 pm, Benjamin Kaplan <benjamin.kap...@case.edu> wrote: > On Fri, Jan 28, 2011 at 1:33 PM, bansi <mail2ba...@gmail.com> wrote: > > On Jan 28, 9:46 am, bansi <mail2ba...@gmail.com> wrote: > >> On Jan 26, 8:31 pm, MRAB <pyt...@mrabarnett.plus.com> wrote: > > >> > On 27/01/2011 00:57, bansi wrote: > > >> > > On Jan 26, 6:25 pm, Ethan Furman<et...@stoneleaf.us> wrote: > >> > >> bansi wrote: > > >> > >> > First namelookupWrapper.py running under Python 2.6 accept > >> > >> arguments > >> > >> > from stdin and uses csv reader object to read it i.e. > >> > >> > r=csv.reader(sys.stdin) > > >> > >> > And then it has to pass csv reader object to another python > >> > >> script > >> > >> > namelookup.py running under Python 2.7 because it uses pyodbc to > >> > >> > connect to database and iterates thru reader object > > >> > >> Ben Finney wrote: > >> > >>> bansi<mail2ba...@gmail.com> writes: > > >> > >>>> Thanks Chris. Sorry for mis-communicating, the two python scripts > >> > >>>> are > >> > >>>> dependant in a way that namelookupWrapper.py needs to pass csv > >> > >>>> record > >> > >>>> object to another python script > > >> > >>> Why have you structured them that way, though? What constraint is > >> > >>> keeping you from doing the work in a single process, where the CSV > >> > >>> reader object can be shared? > > >> > >>>> If thats not possible then please let me know how to do the > >> > >>>> workaround > >> > >>>> i didnt understood the import thing and not sure if it helps in my > >> > >>>> case > > >> > >>> The problem as you've described it so far is best solved by having a > >> > >>> single process accessing the CSV reader object in memory. If that > >> > >>> doesn't suit your use case, you'll need to explain why not. > > >> > >> In other words, why can't you use Python 2.7 to accept input and > >> > >> generate a csv.reader? > > >> > >> ~Ethan~- Hide quoted text - > > >> > >> - Show quoted text - > > >> > > Ethan, > >> > > The python script takes the input from Splunk (http://www.splunk.com/ > >> > > base/Documentation/) which supports only Python 2.6 > >> > > So the real constraint is Splunk supports only Python 2.6 . > > >> > > As you know Python 2.6 doesnt support or doesnt have pyodbc install > >> > > for Windows 64 bit OS > >> > > So i installed Python 2.7 and thereafter pyodbc install for Windows 64 > >> > > bit OS for Python 2.7 > > >> > Have you actually tried Splunk with Python 2.7? It might not work with > >> > versions which are earlier than Python 2.6, but that doesn't > >> > necessarily mean that it won't work with versions of Python 2 which are > >> > later than Python 2.6 (unless the documentation says that it must be > >> > Python 2.6).- Hide quoted text - > > >> > - Show quoted text - > > >> Splunk's latest version 4.1.6 doesn't support Python 2.7 > >> I tried the import trick but it didnt work because the real script > >> which runs under Python 2.7 has import pyodbc so it results in > >> following error > > >> c:\Splunk\etc\apps\search\bin>splunk cmd python namelookupWrapper.py > >> memberId memberName < memberInput.csv > >> Traceback (most recent call last): > >> File "namelookupWrapper.py", line 3, in <module> > >> import namelookup > >> File "c:\Splunk\etc\apps\search\bin\namelookup.py", line 7, in > >> <module> > >> import pyodbc > >> ImportError: DLL load failed: The specified module could not be found. > > >> Please let me know if i am missing something on import. If so please > >> provide me with an example- Hide quoted text - > > >> - Show quoted text - > > > Here are some more details from my earlier posting. Please click the > > below link > > >http://answers.splunk.com/questions/11145/its-getting-mysterious-to-m... > > -- > >http://mail.python.org/mailman/listinfo/python-list > > Have you tried downloading the source for PyODBC and compiling it > yourself? All you need to do is python setup.py install. My guess > would be that it works just fine on 64-bit Python 2.6, they just never > released a re-compiled version of it for that platform.- Hide quoted text - > > - Show quoted text -
Thanks Benjamin. Please point me to the website from where i can download pyodbc for Windows 64 bit OS under Python 2.6 and installation instructions -- http://mail.python.org/mailman/listinfo/python-list
