Connect to rdbms from a product
Hi, Are there any FAQ's, recipes, etc. that explain how to access a database from within a product. I am on a win2k os connecting to SQL2K. I tried looking at the source for ZODBCDA, exUserFolder and googling but have come away confused. I know that ZODBCDA is not recommended but I am building a prototype that if works will allow some dollars to be spent for a more robust solution. If someone could point me in the right direction I would appreciate it. Thanks, Mike
- the first step is to install the corresponding DA with a proper configuration - then you can use either filesystem based ZSQL methods (requires CMF or SkinnedFolder I think) or you acquire the DA instance from within your instances and call SQL directly ( DAinstance.query() I think). -aj --On Freitag, 7. November 2003 11:53 Uhr -0500 mlong@datalong.com wrote:
Hi,
Are there any FAQ's, recipes, etc. that explain how to access a database from within a product. I am on a win2k os connecting to SQL2K. I tried looking at the source for ZODBCDA, exUserFolder and googling but have come away confused. I know that ZODBCDA is not recommended but I am building a prototype that if works will allow some dollars to be spent for a more robust solution. If someone could point me in the right direction I would appreciate it.
Thanks, Mike
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Thank you for the hint. Zope has once again proven to be a good friend after giving the secret handshake :)) The syntax is DAinstance().query(my_sql_statemtent)
- the first step is to install the corresponding DA with a proper configuration - then you can use either filesystem based ZSQL methods (requires CMF or SkinnedFolder I think) or you acquire the DA instance from within your instances and call SQL directly ( DAinstance.query() I think).
-aj
--On Freitag, 7. November 2003 11:53 Uhr -0500 mlong@datalong.com wrote:
Hi,
Are there any FAQ's, recipes, etc. that explain how to access a database from within a product. I am on a win2k os connecting to SQL2K. I tried looking at the source for ZODBCDA, exUserFolder and googling but have come away confused. I know that ZODBCDA is not recommended but I am building a prototype that if works will allow some dollars to be spent for a more robust solution. If someone could point me in the right direction I would appreciate it.
Thanks, Mike
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Thank you for the hint. Zope has once again proven to be a good friend after giving the secret handshake :)) The syntax is DAinstance().query(my_sql_statemtent)
The ExtZSQLMethod product is meant to make using ZSQL from Product code easier. http://zope.org/Members/jccooper/extzsql Don't be scared by the low version number: it just hasn't needed any changes. --jcc -- "My point and period will be throughly wrought, Or well or ill, as this day's battle's fought."
mlong@datalong.com wrote at 2003-11-7 11:53 -0500:
Are there any FAQ's, recipes, etc. that explain how to access a database from within a product. I am on a win2k os connecting to SQL2K. I tried looking at the source for ZODBCDA, exUserFolder and googling but have come away confused. I know that ZODBCDA is not recommended but I am building a prototype that if works will allow some dollars to be spent for a more robust solution. If someone could point me in the right direction I would appreciate it.
I would not directly access the database in your product but use "ZSQL Method"s as intermediaries. Usually, you can acquire these methods from "self" via acquisition (there are a few exceptions: in some methods, "self" is not acquisition wrapped, most prominently "__init__" and "__getattr__"). -- Dieter
On Fri, 7 Nov 2003 mlong@datalong.com wrote:
Hi,
Are there any FAQ's, recipes, etc. that explain how to access a database from within a product. I am on a win2k os connecting to SQL2K. I tried looking at the source for ZODBCDA, exUserFolder and googling but have come away confused. I know that ZODBCDA is not recommended but I am building a prototype that if works will allow some dollars to be spent for a more robust solution. If someone could point me in the right direction I would appreciate it.
i have a product that i use when learning how to connect to rdb. it's not a *great* product, but it works and helps me in my journey to zopezen ;) http://www.zope.org/Members/kedai/SempoiCalendar hth
Thanks, Mike
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
participants (5)
-
Andreas Jung -
Bakhtiar A Hamid -
Dieter Maurer -
J. Cameron Cooper -
mlong＠datalong.com