473,326 Members | 2,125 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Win32+Zope+Python+Databases: What are my options?

Using COM and ADO on Win32, it is very easy to access databases (eg MySql,
MS SQL Server, etc) from Python.

Does anybody know if it is possible to access databases from Zope (which is
written in Python) using COM and ADO?

Carl

Jul 18 '05 #1
4 1534
Carl wrote:
Using COM and ADO on Win32, it is very easy to access databases (eg MySql,
MS SQL Server, etc) from Python.

Does anybody know if it is possible to access databases from Zope (which is
written in Python) using COM and ADO?


Do you mean "Does Zope have built-in support for this?"
or "Does such a facility already exist for Zope?" or something else?

Because if, as you note, Zope is written in Python, then it
should be reasonably obvious that you can write a Zope
extensions/script/product which will do exactly what you need,
if one doesn't already exist.

By the way, Python has a "DB API", which pair of acronyms may help
direct your web searches for a solution...

-Peter
Jul 18 '05 #2
Peter Hansen <pe***@engcorp.com> wrote in message news:<v8********************@powergate.ca>...
Carl wrote:
Using COM and ADO on Win32, it is very easy to access databases (eg MySql,
MS SQL Server, etc) from Python.

Does anybody know if it is possible to access databases from Zope (which is
written in Python) using COM and ADO?


Do you mean "Does Zope have built-in support for this?"
or "Does such a facility already exist for Zope?" or something else?

Because if, as you note, Zope is written in Python, then it
should be reasonably obvious that you can write a Zope
extensions/script/product which will do exactly what you need,
if one doesn't already exist.

By the way, Python has a "DB API", which pair of acronyms may help
direct your web searches for a solution...

-Peter


As Peter said, Python has a database API specification. The idea is
to encourage the similarity between python modules that are used to
access databases. The DB API uses a different interface than ADO on
Win32, but you could choose to access databases in that way as well
using Python if you desired to do so.

For more information on the DB API, check out
http://www.python.org/topics/database/. Here you will find not only
the specification, but also the different modules which implement it.
If would like to buy a book on the subject, I recommend Steve Holden's
Python Web Programming, as it has a great introduction on the DB API.

Now, concerning Zope... Zope has quite a few 'products' that can
access relational databases directly. Although, since Zope has an
object database built in, there is often no need for a Zope
application to access a relational database.

Anyways, to get back to answering your question, Zope can be used to
access relational databases using Zope products. Whether or not there
are any products using COM and ADO for this database access, I do not
know. If you would like to find out, go to http://zope.org/ and
search 'Zope Products' for what you're looking for.

Last, but not least... If there are no suitable products in Zope for
your needs, you can certainly write your own Zope product that access
database using COM and ADO.

Regards,

Michael Loritsch
Jul 18 '05 #3
Peter Hansen <pe***@engcorp.com> wrote in message news:<v8********************@powergate.ca>...
Carl wrote:
Using COM and ADO on Win32, it is very easy to access databases (eg MySql,
MS SQL Server, etc) from Python.

Does anybody know if it is possible to access databases from Zope (which is
written in Python) using COM and ADO?


Do you mean "Does Zope have built-in support for this?"
or "Does such a facility already exist for Zope?" or something else?

Because if, as you note, Zope is written in Python, then it
should be reasonably obvious that you can write a Zope
extensions/script/product which will do exactly what you need,
if one doesn't already exist.

By the way, Python has a "DB API", which pair of acronyms may help
direct your web searches for a solution...

-Peter


As Peter said, Python has a database API specification. The idea is
to encourage the similarity between python modules that are used to
access databases. The DB API uses a different interface than ADO on
Win32, but you could choose to access databases in that way as well
using Python if you desired to do so.

For more information on the DB API, check out
http://www.python.org/topics/database/. Here you will find not only
the specification, but also the different modules which implement it.
If would like to buy a book on the subject, I recommend Steve Holden's
Python Web Programming, as it has a great introduction on the DB API.

Now, concerning Zope... Zope has quite a few 'products' that can
access relational databases directly. Although, since Zope has an
object database built in, there is often no need for a Zope
application to access a relational database.

Anyways, to get back to answering your question, Zope can be used to
access relational databases using Zope products. Whether or not there
are any products using COM and ADO for this database access, I do not
know. If you would like to find out, go to http://zope.org/ and
search 'Zope Products' for what you're looking for.

Last, but not least... If there are no suitable products in Zope for
your needs, you can certainly write your own Zope product that access
database using COM and ADO.

Regards,

Michael Loritsch
Jul 18 '05 #4
Hi Carl,
Does anybody know if it is possible to access databases from Zope (which is
written in Python) using COM and ADO?

I know there are different DAs for zope; however, I don't know if any of
them uses COM or ADO. You could search/ask on:
http://mail.zope.org/mailman/listinfo/zope-db
which is the official zope list for relational database connectivity.

You could also take a look at:
http://zope.org/Products/external_access
and see if you find some DA that do this.

Regards,
Josef
Jul 18 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Brian Beck | last post by:
As far as I can tell, both maintainers of the Windows builds of Python-LDAP haven't updated in about a year. This doesn't exactly make the builds ancient or obsolete, but it would be nice to start...
4
by: PyTJ | last post by:
Hello everybody, I need to convert a Japanese Shift-JIS CSV file to Unicode UTF-8. My machine is a Windows 98 english computer with Python 2.3.4 Any hints?.
4
by: Nano | last post by:
Hey, I have been studying and working on databases for quite a time now. I know quite a lot about databases. Now I have been assigned a project where I have to build an application using the...
6
by: Iain King | last post by:
Hi. I'm using the win32 module to access an Access database, but I'm running into the File Sharing lock count as in http://support.microsoft.com/kb/815281 The solution I'd like to use is the one...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.