Re: [Zope-DB] - Please help me about Driver Adapter to connect relational databases
Am 12.03.2007, 08:37 Uhr, schrieb Nguyen Viet Minh Quang <[EMAIL PROTECTED]>: In the current, I'm using mxODBC Zope DA 1.0 with trial version (one month). It's very good, it doesn't have any problem in the during time. However, it's out of date (March 14, 2004). I have sent the email to them (sales of egenix.com) to give me use it one and two more months but I haven't recieved any reply from them. Will you give us a chance? The request came in the middle of last night and we have issued you with an additional evaluation licence. However, if your project will need more time then you will need to purchase a licence. Sincerely Charlie Clark ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] - Please help me about Driver Adapter to connect relational databases
Dear all, I mentioned my problem before but I would like all you to help me again. First of all, my problem relate to connect relational databases although Driver Adapter (DA). In the current, I'm using mxODBC Zope DA 1.0 with trial version (one month). It's very good, it doesn't have any problem in the during time. However, it's out of date (March 14, 2004). I have sent the email to them (sales of egenix.com) to give me use it one and two more months but I haven't recieved any reply from them. Actually, I mentioned about it with my advisor but only by e-mail because I haven't met him for a long time (He's very busy). But I also think that they buy only this product in the future. As you know, I'm a student and my work is only reach. You can tell me should buy it but I think that it's very difficult to me in this time. Moreover, I have used some other product such as pymssql, ZODBCDA but it's not working. I would like really to use open source product. Of course, It's wonderful if I can use free mxODBC around two months. Could you help me to install the product except mxODBC? Today is a March 12, 2007, it's nearby out of date to use mxODBC product. Please help me to solve my problem. On my PC I have: - Window XP (Linux will be used in the future) - Zope 2.9.5-final - python 2.4.3 (from Plone 2.5.1 package) - Relational databases: SQL server 2000 and Oracle 9i - mxODBC Zope DA 1.0 Thank you very much. Best regards, Minh Quang ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Please help me about driver adapter
Am 17.02.2007, 13:52 Uhr, schrieb Robert-Reinder Nederhoed <[EMAIL PROTECTED]>: Dear Nguyen, For as far as I know, mxODBC is free to use in a non-commercial environment. So you can freely use it for your research or graduation project. Once your school adopts your application, they can licence mxODBC. This is not correct. Only the Python mxODBC driver which is part of the mxCommercial package is free for non-commerical use. However, due to persistent abuse (we sell less than one licence for every thousand downloads) we are reviewing this policy for future releases. So for you, it seems to be legally free after all No (but then neither is MS SQL), but we have issued Minh Quang with an evaluation licence and are prepared to extend evaluation periods providing we are given full details. BTW. a lot of people seem to be using mxODBC together with Oracle and Oracle's Instant Client driver. Unfortunately if our support requests are anything to go by the Instant Client driver seems to crash a lot. Charlie ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Please help me about driver adapter
Dear Nguyen, For as far as I know, mxODBC is free to use in a non-commercial environment. So you can freely use it for your research or graduation project. Once your school adopts your application, they can licence mxODBC. So for you, it seems to be legally free after all :) Good luck with your research project, Robert-Reinder Nederhoed http://nederhoed.com/weblog/ -- ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Please help me about driver adapter
--On 17. Februar 2007 19:35:22 +0700 Nguyen Viet Minh Quang <[EMAIL PROTECTED]> wrote: If you know about pymssql, please help me. This module is not widely used. It you don't want to stick with the mainstream stuff you have to fight and struggle. The "best practice" solution is mxODBC. -aj pgpprKorec9mb.pgp Description: PGP signature ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Please help me about driver adapter
Dear AJ, Yes, I know about that but I'm a student. Moreover, It is a part of my research that mean I do it as my study. I think that If I develop it successful then my school will use it. They will buy it but not now. You see? I think free product is the best way to me in the current. If you know about pymssql, please help me. Best regards, Minh Quang On 2/17/07, Andreas Jung <[EMAIL PROTECTED]> wrote: --On 17. Februar 2007 19:01:26 +0700 Nguyen Viet Minh Quang <[EMAIL PROTECTED]> wrote: > > By the way, I'm using mxODBC but I don't like because it's not free. It's cheap enough (I think 99 USD or so). Multiply the hours you're trying to get the other thing running with your hour rate and you'll see how cheap mxODBC is. But obviously your hour rate seems to be very low :-) -aj -- -- Nguyen Viet Minh Quang Thua Thien Hue Center of Information Tecnology - HueCIT Hue Software Center - Huesoft Address:06 Le Loi street, Hue city, Vietnam Work Tel: (84-54) 824141 - Ext 13 Cellphone: 0914 173 117 Website:www.huecit.com.vn -- "Share with all, All will share"! ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Please help me about driver adapter
--On 17. Februar 2007 19:01:26 +0700 Nguyen Viet Minh Quang <[EMAIL PROTECTED]> wrote: By the way, I'm using mxODBC but I don't like because it's not free. It's cheap enough (I think 99 USD or so). Multiply the hours you're trying to get the other thing running with your hour rate and you'll see how cheap mxODBC is. But obviously your hour rate seems to be very low :-) -aj pgpmmxheBGZy3.pgp Description: PGP signature ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Please help me about driver adapter
Dear Robert, Thanks a lot. For pymssql, I installed it follow the instruction, however it's not working. I can't create a new connection because in "Add" drop-down It's no exist. I don't know why. Pymssql use for SQL Server, no MySQL. By the way, I'm using mxODBC but I don't like because it's not free. Actually, I would like to use pymssql but It is still a problem with me. I read this book that you said, however it isn't to help me more. If you know about it. Please help me. Best regards, Minh Quang On 2/16/07, robert rottermann <[EMAIL PROTECTED]> wrote: I do not think any one of us can help you unless you tell us what exactly your problem with installing pymssql ist. by the way: do you mean MySQLdb? there is very good documentation on using Z SQL in the zope book: http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx there you find examples how to use a query with like. robert Nguyen Viet Minh Quang wrote: > Dear Dieter and All, > > Thank you for your mail. > > I have now a trial version of mxODBC. However I don't really like it > because it's not free. I would like to use pymssql and another one, > although I try to install it more times but it's not working. Can you > help me to install it? > > Moreover, I'm testing my product with mxODBC. I have a problem about > query. I want to use keyword 'LIKE' and '%' inside SQL query but I > don't know how to do it. In the current, I use dtml-sqlvar and > dtml-sqltest to do it. Do you know about my problem and can help me to > solve it? > > Further, How can I format the text to get from database, about HTML tag? > > Thank you for your help. > > Best regards, > > > ___ > Zope-DB mailing list > Zope-DB@zope.org > http://mail.zope.org/mailman/listinfo/zope-db > -- -- Nguyen Viet Minh Quang Thua Thien Hue Center of Information Tecnology - HueCIT Hue Software Center - Huesoft Address:06 Le Loi street, Hue city, Vietnam Work Tel: (84-54) 824141 - Ext 13 Cellphone: 0914 173 117 Website:www.huecit.com.vn -- "Share with all, All will share"! ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Please help me about driver adapter
Nguyen Viet Minh Quang wrote at 2007-2-16 12:42 +0700: > ... >I would like to use pymssql and another one, although I try >to install it more times but it's not working. Can you help me to install >it? No. I do not have an MS SQL server (I do not like MicroSoft and do not want to pay them any money). All, I can tell you is: look for the installation instructions. Follow them carefully. And an additional note: usually, you need two pieces to let Zope interface with a database: a Python-database interface module and a Zope database adapter. The Zope database adapter is usually a Zope product (Zope's extension mechanism) and needs to be place in "/Products". > >Further, How can I format the text to get from database, about HTML tag? You use a template (PageTemplate, maybe DTMLMethod) to render the result of you Z SQL method. I would expect that you find examples in the Zope Book (2.7 edition, online on "plope.org"). -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Please help me about driver adapter
An alternative is: select * from students where surname like '%%' This is a bit more succinct, but if you use it, be sure not to forget the sql_quote, or you will be open to sql injection problems. jim penny [EMAIL PROTECTED] wrote on 02/16/2007 02:57:37 AM: > On Fri, 2007-02-16 at 07:38 +0100, robert rottermann wrote: > > I do not think any one of us can help you unless you tell us what > > exactly your problem with installing pymssql ist. > > by the way: do you mean MySQLdb? > > > > there is very good documentation on using Z SQL in the zope book: > > http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx > > > > there you find examples how to use a query with like. > > robert > Here's an example of how to use like and wildcards in sqlvar's > > select * from students > where surname ilike > > Regards > Garry > > ___ > Zope-DB mailing list > Zope-DB@zope.org > http://mail.zope.org/mailman/listinfo/zope-db ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Please help me about driver adapter
On Fri, 2007-02-16 at 07:38 +0100, robert rottermann wrote: > I do not think any one of us can help you unless you tell us what > exactly your problem with installing pymssql ist. > by the way: do you mean MySQLdb? > > there is very good documentation on using Z SQL in the zope book: > http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx > > there you find examples how to use a query with like. > robert Here's an example of how to use like and wildcards in sqlvar's select * from students where surname ilike Regards Garry ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Please help me about driver adapter
I do not think any one of us can help you unless you tell us what exactly your problem with installing pymssql ist. by the way: do you mean MySQLdb? there is very good documentation on using Z SQL in the zope book: http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx there you find examples how to use a query with like. robert Nguyen Viet Minh Quang wrote: > Dear Dieter and All, > > Thank you for your mail. > > I have now a trial version of mxODBC. However I don't really like it > because it's not free. I would like to use pymssql and another one, > although I try to install it more times but it's not working. Can you > help me to install it? > > Moreover, I'm testing my product with mxODBC. I have a problem about > query. I want to use keyword 'LIKE' and '%' inside SQL query but I > don't know how to do it. In the current, I use dtml-sqlvar and > dtml-sqltest to do it. Do you know about my problem and can help me to > solve it? > > Further, How can I format the text to get from database, about HTML tag? > > Thank you for your help. > > Best regards, > > > ___ > Zope-DB mailing list > Zope-DB@zope.org > http://mail.zope.org/mailman/listinfo/zope-db > begin:vcard fn:robert rottermann n:rottermann;robert email;internet:[EMAIL PROTECTED] tel;work:031 333 10 20 tel;fax:031 333 10 23 tel;home:031 333 36 03 x-mozilla-html:FALSE version:2.1 end:vcard ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] Please help me about driver adapter
Dear Dieter and All, Thank you for your mail. I have now a trial version of mxODBC. However I don't really like it because it's not free. I would like to use pymssql and another one, although I try to install it more times but it's not working. Can you help me to install it? Moreover, I'm testing my product with mxODBC. I have a problem about query. I want to use keyword 'LIKE' and '%' inside SQL query but I don't know how to do it. In the current, I use dtml-sqlvar and dtml-sqltest to do it. Do you know about my problem and can help me to solve it? Further, How can I format the text to get from database, about HTML tag? Thank you for your help. Best regards, ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Please help me
Nguyen Viet Minh Quang wrote at 2007-2-14 04:52 +0700: > ... >I would like to develop a new product running on Plone that can get data >from relational databases (SQL Server and Oracle). I know also to connect to >relational databases to install driver adapter. > >Yes, I found some driver adapter as ZODBCDA, pymssql, mxODBC (not free) and I fear the best approach is to use the commercial "ZmxODBCDA" and carefully follow the installation instructions. Before you pay, you can install it on a (limited) trial base. Once, you have successfully managed "ZmxODBCDA", you may rething whether you pay the (reasonable, as I have been told) fees for "mxODBC" or try again with "pymssql" (for access to the MS SQL server) or "cxOracle".(for access to Oracle). The "ZODBCDA" is no longer reliably maintained (at least as far as I know). -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Please help me
If MxODBC adapter is available on free license you could install that. --Suson - Original Message - From: Nguyen Viet Minh Quang To: zope-db@zope.org Sent: Tuesday, February 13, 2007 4:52 PM Subject: [Zope-DB] Please help me Dear All, My name's Quang, a new member. I have a problem to want everybody to help me. I would like to develop a new product running on Plone that can get data from relational databases (SQL Server and Oracle). I know also to connect to relational databases to install driver adapter. Yes, I found some driver adapter as ZODBCDA, pymssql, mxODBC (not free) and I installed it but it's not working. I don't know why. In event.log file, it warm "ERROR Zope Could not import Products.ZODBCDA " and the same anothe different driver. I can't create a new Z SQL database connection because I can't see it on "Add" drop-down. I'm using window XP with Zope 2.9.5-final, Plone 2.5, Python 2.4.3. Please help me to install one driver adapter to connect to relational databases. Thanks a lot Best regards, Minh Quang -- ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] Please help me
Dear All, My name's Quang, a new member. I have a problem to want everybody to help me. I would like to develop a new product running on Plone that can get data from relational databases (SQL Server and Oracle). I know also to connect to relational databases to install driver adapter. Yes, I found some driver adapter as ZODBCDA, pymssql, mxODBC (not free) and I installed it but it's not working. I don't know why. In event.log file, it warm "ERROR Zope Could not import Products.ZODBCDA " and the same anothe different driver. I can't create a new Z SQL database connection because I can't see it on "Add" drop-down. I'm using window XP with Zope 2.9.5-final, Plone 2.5, Python 2.4.3. Please help me to install one driver adapter to connect to relational databases. Thanks a lot Best regards, Minh Quang ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db