Mailing List Archive: ODBC adapter

ODBC adapter

Jul 4, 2016, 9:08 AM

Post #1 of 5 (2201 views)

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 <module>
from pyodbc_browser import pyodbcConnectionBrowser,
addpyodbcConnectionBrowser, addpyodbcConnectionForm
File
"N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_browser.py",
line 23, in <module>
from pyodbc_DA import pyodbcConnection, database_type,
addpyodbcConnectionForm
File
"N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_DA.py",
line 27, in <module>
from pyodbc_db import DB
File
"N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_db.py",
line 37, in <module>
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
<module>
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 <module>
from pyodbc_browser import pyodbcConnectionBrowser,
addpyodbcConnectionBrows
er, addpyodbcConnectionForm
File
"N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_browser.py",
line 23, in <module>
from pyodbc_DA import pyodbcConnection, database_type,
addpyodbcConnectionForm
File
"N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_DA.py",
line 27, in <module>
from pyodbc_db import DB
File
"N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_db.py",
line 37, in <module>
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

Re: ODBC adapter [ In reply to ]

tseaver at palladion

Jul 4, 2016, 9:54 AM

Post #2 of 5 (2179 views)

Permalink

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 <module>
> 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 tseaver@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 )

Re: ODBC adapter [ In reply to ]

lists at zopyx

Jul 5, 2016, 8:39 AM

Post #3 of 5 (1568 views)

Permalink

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 <module>
> from pyodbc_browser import pyodbcConnectionBrowser,
> addpyodbcConnectionBrowser, addpyodbcConnectionForm
> File
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_browser.py",
> line 23, in <module>
> from pyodbc_DA import pyodbcConnection, database_type,
> addpyodbcConnectionForm
> File
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_DA.py",
> line 27, in <module>
> from pyodbc_db import DB
> File
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_db.py",
> line 37, in <module>
> 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
> <module>
> 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 <module>
> from pyodbc_browser import pyodbcConnectionBrowser,
> addpyodbcConnectionBrows
> er, addpyodbcConnectionForm
> File
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_browser.py",
> line 23, in <module>
> from pyodbc_DA import pyodbcConnection, database_type,
> addpyodbcConnectionForm
> File
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_DA.py",
> line 27, in <module>
> from pyodbc_db import DB
> File
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_db.py",
> line 37, in <module>
> 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 )

Re: ODBC adapter [ In reply to ]

yourpadre at gmail

Jul 8, 2016, 7:11 AM

Post #4 of 5 (2167 views)

Permalink

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 <lists@zopyx.com>:

> 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 <module>
> > from pyodbc_browser import pyodbcConnectionBrowser,
> > addpyodbcConnectionBrowser, addpyodbcConnectionForm
> > File
> >
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_browser.py",
> > line 23, in <module>
> > from pyodbc_DA import pyodbcConnection, database_type,
> > addpyodbcConnectionForm
> > File
> >
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_DA.py",
> > line 27, in <module>
> > from pyodbc_db import DB
> > File
> >
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_db.py",
> > line 37, in <module>
> > 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
> > <module>
> > 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 <module>
> > from pyodbc_browser import pyodbcConnectionBrowser,
> > addpyodbcConnectionBrows
> > er, addpyodbcConnectionForm
> > File
> >
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_browser.py",
> > line 23, in <module>
> > from pyodbc_DA import pyodbcConnection, database_type,
> > addpyodbcConnectionForm
> > File
> >
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_DA.py",
> > line 27, in <module>
> > from pyodbc_db import DB
> > File
> >
> "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_db.py",
> > line 37, in <module>
> > 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

Re: ODBC adapter [ In reply to ]

tseaver at palladion

Jul 8, 2016, 8:32 AM

Post #5 of 5 (2166 views)

Permalink

-----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 tseaver@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 )

Mailing List Archive

Mailing List Archive

Attached Files: