Re: [DB-SIG] Oracle API

2005-05-05 Thread Gerhard Haering
On Tue, May 03, 2005 at 05:14:45PM -0400, [EMAIL PROTECTED] wrote: > Is it necessary to have the Oracle Client installed in a machine that > wishes to connect to an Oracle database? Yes, but a minimal install will do. > If not, what are the requisite files for making the connection? It's possib

Re: [DB-SIG] Oracle API

2005-05-05 Thread Andy Todd
Stephen Day wrote: > No need the have the Oracle client. There are a few > modules that should work listed here (not all > Oracle!): > > http://www.python.org/topics/database/modules.html > > I've used cx_Oracle with success. > > Stephen Day > > > --- [EMAIL PROTECTED] wrote: > > >>Is it ne

Re: [DB-SIG] Oracle API

2005-05-05 Thread Gerhard Häring
Andy Todd wrote: > [...] The Python db-api modules (such as cx_Oracle and DCOracle2) still > require you to have the Oracle client software installed. > > Oracle do ship a class (III or is it IV?) pure Java JDBC driver which > you can use from Jython. > > The only other way I'm aware of that yo

Re: [DB-SIG] Oracle API

2005-05-05 Thread Andy Todd
Gerhard Häring wrote: > Andy Todd wrote: > >>[...] The Python db-api modules (such as cx_Oracle and DCOracle2) still >>require you to have the Oracle client software installed. >> >>Oracle do ship a class (III or is it IV?) pure Java JDBC driver which >>you can use from Jython. >> >>The only oth

[DB-SIG] cx_Oracle and Unicode ???

2005-05-05 Thread Mark Bennett
Good morning Folks,   I've looked around on Google for this a few times and really haven't come up with anything definitive.   I'm trying to update values in Oracle with the .execute() method from cx_Oracle.   If I create a Python unicode string object and try to pass it in, Python complain

Re: [DB-SIG] Oracle API

2005-05-05 Thread Stephen Day
Sorry about that, I have the Oracle client installed... but didn't know it was needed. --- Stephen Day <[EMAIL PROTECTED]> wrote: > No need the have the Oracle client. There are a few > modules that should work listed here (not all > Oracle!): > > http://www.python.org/topics/database/modules.htm

Re: [DB-SIG] cx_Oracle and Unicode ???

2005-05-05 Thread jno
db-sig ping -- sorry guys... ___ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig

Re: [DB-SIG] cx_Oracle and Unicode ???

2005-05-05 Thread Guido van Rossum
Maybe this is more an issue for the cx-oracle mailing list? (Google for it.) I'd be interested in hearing the answer too. On 5/5/05, Mark Bennett <[EMAIL PROTECTED]> wrote: > > Good morning Folks, > > I've looked around on Google for this a few times and really haven't come up > with anythi

[DB-SIG] Dealing with bogus date in MySql

2005-05-05 Thread Mark Rages
Hi, I hope this list can help me. I have a MySQL table with some dates, like this: mysql> select MIN(change_date),MAX(change_date) from status_history; +-+-+ | MIN(change_date)| MAX(change_date)| +-+-+ | 2000-

Re: [DB-SIG] Dealing with bogus date in MySql

2005-05-05 Thread Andy Dustman
Follow-up off-list or on the mysql-python sourceforge Help forum. On 5/5/05, Mark Rages <[EMAIL PROTECTED]> wrote: > Hi, > > I hope this list can help me. > > I have a MySQL table with some dates, like this: > mysql> select MIN(change_date),MAX(change_date) from status_history; > +--

Re: [DB-SIG] Oracle API

2005-05-05 Thread Eric Brunson
Gerhard Haering wrote: On Tue, May 03, 2005 at 05:14:45PM -0400, [EMAIL PROTECTED] wrote: Is it necessary to have the Oracle Client installed in a machine that wishes to connect to an Oracle database? Yes, but a minimal install will do. If not, what are the r

Re: [DB-SIG] Dealing with bogus date in MySql

2005-05-05 Thread M.-A. Lemburg
Andy Dustman wrote: > Follow-up off-list or on the mysql-python sourceforge Help forum. > > On 5/5/05, Mark Rages <[EMAIL PROTECTED]> wrote: > >>Hi, >> >>I hope this list can help me. >> >>I have a MySQL table with some dates, like this: >>mysql> select MIN(change_date),MAX(change_date) from stat