[web2py] Re: Include odbc and mssql support with pypyodbc.py
Massimo Di Pierro massimo.dipierro@... writes: What you are telling me is that pypyodbc does not require additional python packages but it requires odbc. Hi, I'm the maintainer of pypyodbc. I noticed you meet the library loading problem and I re-looked at the code, and I uploaded a patch that will fix the library loading problem. It's ture pypyodbc requires odbc (the unixodbc package), and like pypyodbc, pyodbc also requires that on linux. However, in the previous version, it seems pypyodbc didn't find your libodbc.so library correctly. I updated the way how pypyodbc find the lib, and I think this may be able to solve the problem. You can download the latest verson at http://pypyodbc.googlecode.com/svn/trunk/pypyodbc/pypyodbc.py -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] Re: Include odbc and mssql support with pypyodbc.py
Thank you very much for your work. We plan to include pypyodbc.py (only this file) in web2py under contrib. Would that be ok? Is the license mentioned in the file itself sufficient or should we ship a separate license file? Massimo On Friday, 8 February 2013 08:03:06 UTC-6, 江文 wrote: Massimo Di Pierro massimo.dipierro@... writes: What you are telling me is that pypyodbc does not require additional python packages but it requires odbc. Hi, I'm the maintainer of pypyodbc. I noticed you meet the library loading problem and I re-looked at the code, and I uploaded a patch that will fix the library loading problem. It's ture pypyodbc requires odbc (the unixodbc package), and like pypyodbc, pyodbc also requires that on linux. However, in the previous version, it seems pypyodbc didn't find your libodbc.so library correctly. I updated the way how pypyodbc find the lib, and I think this may be able to solve the problem. You can download the latest verson at http://pypyodbc.googlecode.com/svn/trunk/pypyodbc/pypyodbc.py -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] Re: Include odbc and mssql support with pypyodbc.py
Massimo Di Pierro massimo.dipierro@... writes: Thank you very much for your work. We plan to include pypyodbc.py (only this file) in web2py under contrib. Would that be ok? Is the license mentioned in the file itself sufficient or should we ship a separate license file? MassimoOn Friday, 8 February 2013 08:03:06 UTC-6, 江文 wrote:Massimo Di Pierro massimo.dipierro at ... writes: What you are telling me is that pypyodbc does not require additional python packages but it requires odbc. Hi, I'm the maintainer of pypyodbc. I noticed you meet the library loading problem and I re-looked at the code, and I uploaded a patch that will fix the library loading problem. It's ture pypyodbc requires odbc (the unixodbc package), and like pypyodbc, pyodbc also requires that on linux. However, in the previous version, it seems pypyodbc didn't find your libodbc.so library correctly. I updated the way how pypyodbc find the lib, and I think this may be able to solve the problem. You can download the latest verson at http://pypyodbc.googlecode.com/svn/trunk/pypyodbc/pypyodbc.py Hi, Massimo, Yes, both the way you including the script and the license mentioned in the file itself is sufficient. It's good to see pypyodbc is included in web2py :) -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] Re: Include odbc and mssql support with pypyodbc.py
I tried: from contrib.pypyodbc import pypyodbc as pyodbc and I get: gluon.contrib.pypyodbc.OdbcNoLibrary: 'ODBC Library is not found' Can you help? On Monday, 4 February 2013 18:09:31 UTC-6, Derek wrote: Any way we can add this? http://code.google.com/p/pypyodbc/ It's a pure python implementation of pyodbc. I've tested it with pypy1.9 on web2py 2.3.2 and it works fine (yes, I edited dal.py and renamed all instances of pyodbc to pypyodbc). -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
Re: [web2py] Re: Include odbc and mssql support with pypyodbc.py
I think pyodbc works great on windows, for unix you should compile it with unixODBC support: http://code.google.com/p/pyodbc/wiki/Building Anyway, surely in unix you will not have a tipical ODBC database to test (MS SQLServer, MS Access, etc.) ... Best regards Mariano Reingart http://www.sistemasagiles.com.ar http://reingart.blogspot.com On Tue, Feb 5, 2013 at 12:45 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: I tried: from contrib.pypyodbc import pypyodbc as pyodbc and I get: gluon.contrib.pypyodbc.OdbcNoLibrary: 'ODBC Library is not found' Can you help? On Monday, 4 February 2013 18:09:31 UTC-6, Derek wrote: Any way we can add this? http://code.google.com/p/pypyodbc/ It's a pure python implementation of pyodbc. I've tested it with pypy1.9 on web2py 2.3.2 and it works fine (yes, I edited dal.py and renamed all instances of pyodbc to pypyodbc). -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out. -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] Re: Include odbc and mssql support with pypyodbc.py
As I said, I edited dal.py and replaced references to pyodbc to pypyodbc and that seemed to work. I believe the only adapter referencing it as a driver was the mssql driver. On Tuesday, February 5, 2013 7:45:28 AM UTC-7, Massimo Di Pierro wrote: I tried: from contrib.pypyodbc import pypyodbc as pyodbc and I get: gluon.contrib.pypyodbc.OdbcNoLibrary: 'ODBC Library is not found' Can you help? On Monday, 4 February 2013 18:09:31 UTC-6, Derek wrote: Any way we can add this? http://code.google.com/p/pypyodbc/ It's a pure python implementation of pyodbc. I've tested it with pypy1.9 on web2py 2.3.2 and it works fine (yes, I edited dal.py and renamed all instances of pyodbc to pypyodbc). -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] Re: Include odbc and mssql support with pypyodbc.py
Which os? Not for me. On Tuesday, 5 February 2013 12:53:07 UTC-6, Derek wrote: As I said, I edited dal.py and replaced references to pyodbc to pypyodbc and that seemed to work. I believe the only adapter referencing it as a driver was the mssql driver. On Tuesday, February 5, 2013 7:45:28 AM UTC-7, Massimo Di Pierro wrote: I tried: from contrib.pypyodbc import pypyodbc as pyodbc and I get: gluon.contrib.pypyodbc.OdbcNoLibrary: 'ODBC Library is not found' Can you help? On Monday, 4 February 2013 18:09:31 UTC-6, Derek wrote: Any way we can add this? http://code.google.com/p/pypyodbc/ It's a pure python implementation of pyodbc. I've tested it with pypy1.9 on web2py 2.3.2 and it works fine (yes, I edited dal.py and renamed all instances of pyodbc to pypyodbc). -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] Re: Include odbc and mssql support with pypyodbc.py
This was on Windows. It appears to be looking in these locations: /usr/lib/libodbc.so,/usr/lib/i386-linux-gnu/libodbc.so,/usr/lib/x86_64-linux-gnu/libodbc.so So, if it's not in those locations, you might want to add your libodbc.so location. line 462 of pypyodbc.py On Tuesday, February 5, 2013 12:26:32 PM UTC-7, Massimo Di Pierro wrote: Which os? Not for me. On Tuesday, 5 February 2013 12:53:07 UTC-6, Derek wrote: As I said, I edited dal.py and replaced references to pyodbc to pypyodbc and that seemed to work. I believe the only adapter referencing it as a driver was the mssql driver. On Tuesday, February 5, 2013 7:45:28 AM UTC-7, Massimo Di Pierro wrote: I tried: from contrib.pypyodbc import pypyodbc as pyodbc and I get: gluon.contrib.pypyodbc.OdbcNoLibrary: 'ODBC Library is not found' Can you help? On Monday, 4 February 2013 18:09:31 UTC-6, Derek wrote: Any way we can add this? http://code.google.com/p/pypyodbc/ It's a pure python implementation of pyodbc. I've tested it with pypy1.9 on web2py 2.3.2 and it works fine (yes, I edited dal.py and renamed all instances of pyodbc to pypyodbc). -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] Re: Include odbc and mssql support with pypyodbc.py
What you are telling me is that pypyodbc does not require additional python packages but it requires odbc. On Tuesday, 5 February 2013 14:02:54 UTC-6, Derek wrote: This was on Windows. It appears to be looking in these locations: /usr/lib/libodbc.so,/usr/lib/i386-linux-gnu/libodbc.so,/usr/lib/x86_64-linux-gnu/libodbc.so So, if it's not in those locations, you might want to add your libodbc.so location. line 462 of pypyodbc.py Yes, so it appears the OS.Exists(path) for those three locations didn't exist. So either your libodbc is in a different place, or you don't have it installed. On Tuesday, February 5, 2013 12:26:32 PM UTC-7, Massimo Di Pierro wrote: Which os? Not for me. On Tuesday, 5 February 2013 12:53:07 UTC-6, Derek wrote: As I said, I edited dal.py and replaced references to pyodbc to pypyodbc and that seemed to work. I believe the only adapter referencing it as a driver was the mssql driver. On Tuesday, February 5, 2013 7:45:28 AM UTC-7, Massimo Di Pierro wrote: I tried: from contrib.pypyodbc import pypyodbc as pyodbc and I get: gluon.contrib.pypyodbc.OdbcNoLibrary: 'ODBC Library is not found' Can you help? On Monday, 4 February 2013 18:09:31 UTC-6, Derek wrote: Any way we can add this? http://code.google.com/p/pypyodbc/ It's a pure python implementation of pyodbc. I've tested it with pypy1.9 on web2py 2.3.2 and it works fine (yes, I edited dal.py and renamed all instances of pyodbc to pypyodbc). -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] Re: Include odbc and mssql support with pypyodbc.py
Yup. It uses ctypes to access your existing odbc libraries. On Tuesday, February 5, 2013 3:22:45 PM UTC-7, Massimo Di Pierro wrote: What you are telling me is that pypyodbc does not require additional python packages but it requires odbc. On Tuesday, 5 February 2013 14:02:54 UTC-6, Derek wrote: This was on Windows. It appears to be looking in these locations: /usr/lib/libodbc.so,/usr/lib/i386-linux-gnu/libodbc.so,/usr/lib/x86_64-linux-gnu/libodbc.so So, if it's not in those locations, you might want to add your libodbc.so location. line 462 of pypyodbc.py Yes, so it appears the OS.Exists(path) for those three locations didn't exist. So either your libodbc is in a different place, or you don't have it installed. On Tuesday, February 5, 2013 12:26:32 PM UTC-7, Massimo Di Pierro wrote: Which os? Not for me. On Tuesday, 5 February 2013 12:53:07 UTC-6, Derek wrote: As I said, I edited dal.py and replaced references to pyodbc to pypyodbc and that seemed to work. I believe the only adapter referencing it as a driver was the mssql driver. On Tuesday, February 5, 2013 7:45:28 AM UTC-7, Massimo Di Pierro wrote: I tried: from contrib.pypyodbc import pypyodbc as pyodbc and I get: gluon.contrib.pypyodbc.OdbcNoLibrary: 'ODBC Library is not found' Can you help? On Monday, 4 February 2013 18:09:31 UTC-6, Derek wrote: Any way we can add this? http://code.google.com/p/pypyodbc/ It's a pure python implementation of pyodbc. I've tested it with pypy1.9 on web2py 2.3.2 and it works fine (yes, I edited dal.py and renamed all instances of pyodbc to pypyodbc). -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
