Re: [Zope] ODBC adapter

2017-05-31 Thread Andreas Jung 
http://www.egenix.com/products/python/mxODBC/

is the only reasonable ODBC approach for Zope nowadays...forget the other old 
crap.

-aj

On 4 Jul 2016, at 18:08, Miguel Beltran R. wrote:

> Hi again list,
>
> Using zope 2.13.23
> ZPyODBCDA 1.0.9.dev0 ( https://github.com/tcurvelo/Products.ZPyODBCDA )
>
> I have tried to install ZpyODBCDA but when I try to start the instance i
> got this error
>
> (control-emisiones3)
> N:\zope\control-emisiones3>"N:\zope\control-emisiones3\Scripts\runzope" -C
> "N:\zope\control-emisiones3\instance_zope\etc\zope.conf"
>
> 2016-07-04 10:48:05 ERROR Application Could not import Products.ZPyODBCDA
> Traceback (most recent call last):
>   File "n:\zope\control-emisiones3\lib\site-packages\OFS\Application.py",
> line 606, in import_product
> product=__import__(pname, global_dict, global_dict, silly)
>   File
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\__init__.py",
> line 27, in 
> from pyodbc_browser import pyodbcConnectionBrowser,
> addpyodbcConnectionBrowser, addpyodbcConnectionForm
>   File
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_browser.py",
> line 23, in 
> from pyodbc_DA import pyodbcConnection, database_type,
> addpyodbcConnectionForm
>   File
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_DA.py",
> line 27, in 
> from pyodbc_db import DB
>   File
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_db.py",
> line 37, in 
> from Shared.DC.ZRDB.TM import TM
> ImportError: No module named ZRDB.TM
> Traceback (most recent call last):
>   File "C:\Python27\Lib\runpy.py", line 162, in _run_module_as_main
> "__main__", fname, loader, pkg_name)
>   File "C:\Python27\Lib\runpy.py", line 72, in _run_code
> exec code in run_globals
>   File "N:\zope\control-emisiones3\Scripts\runzope.exe\__main__.py", line
> 9, in
> 
>   File "n:\zope\control-emisiones3\lib\site-packages\Zope2\Startup\run.py",
> line 22, in run
> starter.prepare()
>   File
> "n:\zope\control-emisiones3\lib\site-packages\Zope2\Startup\__init__.py",
> line 86, in prepare
> self.startZope()
>   File
> "n:\zope\control-emisiones3\lib\site-packages\Zope2\Startup\__init__.py",
> line 262, in startZope
> Zope2.startup()
>   File "n:\zope\control-emisiones3\lib\site-packages\Zope2\__init__.py",
> line 47, in startup
> _startup()
>   File "n:\zope\control-emisiones3\lib\site-packages\Zope2\App\startup.py",
> line 67, in startup
> OFS.Application.import_products()
>   File "n:\zope\control-emisiones3\lib\site-packages\OFS\Application.py",
> line 583, in import_products
> import_product(product_dir, product_name, raise_exc=debug_mode)
>   File "n:\zope\control-emisiones3\lib\site-packages\OFS\Application.py",
> line 606, in import_product
> product=__import__(pname, global_dict, global_dict, silly)
>   File
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\__init__.py",
> line 27, in 
> from pyodbc_browser import pyodbcConnectionBrowser,
> addpyodbcConnectionBrows
> er, addpyodbcConnectionForm
>   File
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_browser.py",
> line 23, in 
> from pyodbc_DA import pyodbcConnection, database_type,
> addpyodbcConnectionForm
>   File
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_DA.py",
> line 27, in 
> from pyodbc_db import DB
>   File
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_db.py",
> line 37, in 
> from Shared.DC.ZRDB.TM import TM
> ImportError: No module named ZRDB.TM
>
>
> What module do I need to install?
>
>
>
> -- 
> 
> Lo bueno de vivir un dia mas
> es saber que nos queda un dia menos de vida
> ___
> Zope maillist  -  Zope@zope.org
> https://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  https://mail.zope.org/mailman/listinfo/zope-announce
>  https://mail.zope.org/mailman/listinfo/zope-dev )


signature.asc
Description: OpenPGP digital signature
___
Zope maillist  -  Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists -
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )

Re: [Zope] ODBC adapter

2016-07-08 Thread Tres Seaver 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 07/08/2016 10:11 AM, Miguel Beltran R. wrote:

> With the help of Tres Seaver I have working my site. Thanks again
> Tres!!!
> 
> I know that egenix have the most complete and well working ODBC
> adapter, but ZpyODBCDA do the work for my needs

I'm glad you are up and running!


Tres.
- -- 
===
Tres Seaver  +1 540-429-0999  tsea...@palladion.com
Palladion Software   "Excellence by Design"http://palladion.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1

iQIcBAEBAgAGBQJXf8eYAAoJEPKpaDSJE9HYYrQP/0lf//tyn+UcOpIenBc1vEXI
bqgB9J8H9KPz3LsmPnjt03039qzStsvpq2XbrZXxhpPeVKq16OvW7ysGEccScaBp
g6Za0L+nD0Uy6risKGL9LpKBT3JrhRMz+WYrUEJmCoNr/vsMXS8Nh6Az4pyJanxJ
/HwiM2G8RM8XJvtUP52DpE5dtOVTrv4qg1DeoUpZF+RZTNCoTDDuvzMDteZHfRB3
yFqdW/qr85Ab0W2oNnviZqBpYqe4kLrakJXstwgE9CjYBVktvBSSXVKigMN4qUI7
zY+mS6u5uRTXUN3pC9KDk1+9TDExa6v7U+7ljfx6arDmmLHAMQ1DnsvlCvTqnisE
OxkqRrIlWYzs9IMbIOCpyladMI1z/deYWrJH1W6IoqXHzKLDNmTkzobw/jyU2V7o
wDdJdA3xaa9nKDD3XRgx/iJGHZKw1JwdoJroFdVxeJXBZx1foi2JJ2JsiFFMgXRi
bfXX10oW08TNnYrHwvlVgQfSMfNRsU5xhjUFfx6N3pO7UA+PPw8fAetqxAcqSVs/
LGOkHID3CrqWN2NoQkPW7TvjkmzLnA7+LbibzZIbmk8fPxa9vQzvbdrGOmC5hbP9
uOvMaaUgzL58bmz7g+fiEO69bEXdTj6yCComdCXxGGk0YrRH1zo+/VYokn9kdZVI
weoofDAUor5gJ6R2tOgI
=Ztad
-END PGP SIGNATURE-

___
Zope maillist  -  Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists -
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )

Re: [Zope] ODBC adapter

2016-07-08 Thread Miguel Beltran R. 
With the help of Tres Seaver I have working my site. Thanks again Tres!!!

I know that egenix have the most complete and well working ODBC adapter,
but ZpyODBCDA do the work for my needs

2016-07-05 10:39 GMT-05:00 Andreas Jung :

> http://www.egenix.com/products/python/mxODBC/
>
> is the only reasonable ODBC approach for Zope nowadays...forget the other
> old crap.
>
> -aj
>
> On 4 Jul 2016, at 18:08, Miguel Beltran R. wrote:
>
> > Hi again list,
> >
> > Using zope 2.13.23
> > ZPyODBCDA 1.0.9.dev0 ( https://github.com/tcurvelo/Products.ZPyODBCDA )
> >
> > I have tried to install ZpyODBCDA but when I try to start the instance i
> > got this error
> >
> > (control-emisiones3)
> > N:\zope\control-emisiones3>"N:\zope\control-emisiones3\Scripts\runzope"
> -C
> > "N:\zope\control-emisiones3\instance_zope\etc\zope.conf"
> >
> > 2016-07-04 10:48:05 ERROR Application Could not import Products.ZPyODBCDA
> > Traceback (most recent call last):
> >   File "n:\zope\control-emisiones3\lib\site-packages\OFS\Application.py",
> > line 606, in import_product
> > product=__import__(pname, global_dict, global_dict, silly)
> >   File
> >
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\__init__.py",
> > line 27, in 
> > from pyodbc_browser import pyodbcConnectionBrowser,
> > addpyodbcConnectionBrowser, addpyodbcConnectionForm
> >   File
> >
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_browser.py",
> > line 23, in 
> > from pyodbc_DA import pyodbcConnection, database_type,
> > addpyodbcConnectionForm
> >   File
> >
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_DA.py",
> > line 27, in 
> > from pyodbc_db import DB
> >   File
> >
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_db.py",
> > line 37, in 
> > from Shared.DC.ZRDB.TM import TM
> > ImportError: No module named ZRDB.TM
> > Traceback (most recent call last):
> >   File "C:\Python27\Lib\runpy.py", line 162, in _run_module_as_main
> > "__main__", fname, loader, pkg_name)
> >   File "C:\Python27\Lib\runpy.py", line 72, in _run_code
> > exec code in run_globals
> >   File "N:\zope\control-emisiones3\Scripts\runzope.exe\__main__.py", line
> > 9, in
> > 
> >   File
> "n:\zope\control-emisiones3\lib\site-packages\Zope2\Startup\run.py",
> > line 22, in run
> > starter.prepare()
> >   File
> > "n:\zope\control-emisiones3\lib\site-packages\Zope2\Startup\__init__.py",
> > line 86, in prepare
> > self.startZope()
> >   File
> > "n:\zope\control-emisiones3\lib\site-packages\Zope2\Startup\__init__.py",
> > line 262, in startZope
> > Zope2.startup()
> >   File "n:\zope\control-emisiones3\lib\site-packages\Zope2\__init__.py",
> > line 47, in startup
> > _startup()
> >   File
> "n:\zope\control-emisiones3\lib\site-packages\Zope2\App\startup.py",
> > line 67, in startup
> > OFS.Application.import_products()
> >   File "n:\zope\control-emisiones3\lib\site-packages\OFS\Application.py",
> > line 583, in import_products
> > import_product(product_dir, product_name, raise_exc=debug_mode)
> >   File "n:\zope\control-emisiones3\lib\site-packages\OFS\Application.py",
> > line 606, in import_product
> > product=__import__(pname, global_dict, global_dict, silly)
> >   File
> >
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\__init__.py",
> > line 27, in 
> > from pyodbc_browser import pyodbcConnectionBrowser,
> > addpyodbcConnectionBrows
> > er, addpyodbcConnectionForm
> >   File
> >
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_browser.py",
> > line 23, in 
> > from pyodbc_DA import pyodbcConnection, database_type,
> > addpyodbcConnectionForm
> >   File
> >
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_DA.py",
> > line 27, in 
> > from pyodbc_db import DB
> >   File
> >
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_db.py",
> > line 37, in 
> > from Shared.DC.ZRDB.TM import TM
> > ImportError: No module named ZRDB.TM
> >
> >
> > What module do I need to install?
> >
> >
> >
> > --
> > 
> > Lo bueno de vivir un dia mas
> > es saber que nos queda un dia menos de vida
> > ___
> > Zope maillist  -  Zope@zope.org
> > https://mail.zope.org/mailman/listinfo/zope
> > **   No cross posts or HTML encoding!  **
> > (Related lists -
> >  https://mail.zope.org/mailman/listinfo/zope-announce
> >  https://mail.zope.org/mailman/listinfo/zope-dev )
>



-- 

Lo bueno de vivir un dia mas
es saber que nos queda un dia menos de vida
___
Zope maillist  -  Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists -
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )

Re: [Zope] ODBC adapter

2016-07-04 Thread Tres Seaver 
On 07/04/2016 12:08 PM, Miguel Beltran R. wrote:

> Using zope 2.13.23 ZPyODBCDA 1.0.9.dev0 ( 
> https://github.com/tcurvelo/Products.ZPyODBCDA )
> 
> I have tried to install ZpyODBCDA but when I try to start the
> instance i got this error
> 
> (control-emisiones3) 
> N:\zope\control-emisiones3>"N:\zope\control-emisiones3\Scripts\runzope"
>
> 
-C "N:\zope\control-emisiones3\instance_zope\etc\zope.conf"
> 
> 2016-07-04 10:48:05 ERROR Application Could not import 
> Products.ZPyODBCDA Traceback (most recent call last): ... 
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_db.py", 
> line 37, in 
> from Shared.DC.ZRDB.TM import TM ImportError: No module named ZRDB.TM
> 
> 
> What module do I need to install?

Products.ZSQLMethods split off in in the Zope 2.13.x series.

 https://pypi.python.org/pypi/Products.ZSQLMethods/

You might submit an issue to the tracker for Products.ZPyODBCDA
suggesting the add it as a dependency.



Tres.
-- 
===
Tres Seaver  +1 540-429-0999  tsea...@palladion.com
Palladion Software   "Excellence by Design"http://palladion.com

___
Zope maillist  -  Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists -
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )

[Zope] ODBC adapter

2016-07-04 Thread Miguel Beltran R. 
Hi again list,

Using zope 2.13.23
ZPyODBCDA 1.0.9.dev0 ( https://github.com/tcurvelo/Products.ZPyODBCDA )

I have tried to install ZpyODBCDA but when I try to start the instance i
got this error

(control-emisiones3)
N:\zope\control-emisiones3>"N:\zope\control-emisiones3\Scripts\runzope" -C
"N:\zope\control-emisiones3\instance_zope\etc\zope.conf"

2016-07-04 10:48:05 ERROR Application Could not import Products.ZPyODBCDA
Traceback (most recent call last):
  File "n:\zope\control-emisiones3\lib\site-packages\OFS\Application.py",
line 606, in import_product
product=__import__(pname, global_dict, global_dict, silly)
  File
"N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\__init__.py",
line 27, in 
from pyodbc_browser import pyodbcConnectionBrowser,
addpyodbcConnectionBrowser, addpyodbcConnectionForm
  File
"N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_browser.py",
line 23, in 
from pyodbc_DA import pyodbcConnection, database_type,
addpyodbcConnectionForm
  File
"N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_DA.py",
line 27, in 
from pyodbc_db import DB
  File
"N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_db.py",
line 37, in 
from Shared.DC.ZRDB.TM import TM
ImportError: No module named ZRDB.TM
Traceback (most recent call last):
  File "C:\Python27\Lib\runpy.py", line 162, in _run_module_as_main
"__main__", fname, loader, pkg_name)
  File "C:\Python27\Lib\runpy.py", line 72, in _run_code
exec code in run_globals
  File "N:\zope\control-emisiones3\Scripts\runzope.exe\__main__.py", line
9, in

  File "n:\zope\control-emisiones3\lib\site-packages\Zope2\Startup\run.py",
line 22, in run
starter.prepare()
  File
"n:\zope\control-emisiones3\lib\site-packages\Zope2\Startup\__init__.py",
line 86, in prepare
self.startZope()
  File
"n:\zope\control-emisiones3\lib\site-packages\Zope2\Startup\__init__.py",
line 262, in startZope
Zope2.startup()
  File "n:\zope\control-emisiones3\lib\site-packages\Zope2\__init__.py",
line 47, in startup
_startup()
  File "n:\zope\control-emisiones3\lib\site-packages\Zope2\App\startup.py",
line 67, in startup
OFS.Application.import_products()
  File "n:\zope\control-emisiones3\lib\site-packages\OFS\Application.py",
line 583, in import_products
import_product(product_dir, product_name, raise_exc=debug_mode)
  File "n:\zope\control-emisiones3\lib\site-packages\OFS\Application.py",
line 606, in import_product
product=__import__(pname, global_dict, global_dict, silly)
  File
"N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\__init__.py",
line 27, in 
from pyodbc_browser import pyodbcConnectionBrowser,
addpyodbcConnectionBrows
er, addpyodbcConnectionForm
  File
"N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_browser.py",
line 23, in 
from pyodbc_DA import pyodbcConnection, database_type,
addpyodbcConnectionForm
  File
"N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_DA.py",
line 27, in 
from pyodbc_db import DB
  File
"N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_db.py",
line 37, in 
from Shared.DC.ZRDB.TM import TM
ImportError: No module named ZRDB.TM


What module do I need to install?



-- 

Lo bueno de vivir un dia mas
es saber que nos queda un dia menos de vida
___
Zope maillist  -  Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists -
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )