Database experiences in Python: Good or Bad?

brueckd at tbye.com brueckd at tbye.com
Wed Aug 7 00:04:16 CEST 2002


On Tue, 6 Aug 2002, Gerhard Häring wrote:

> * brueckd at tbye.com <brueckd at tbye.com> [2002-08-06 07:52 -0700]:
> > Of the commercial DBs, I've had good results using DCOracle2 on Linux
> > You can also specify the full connection string inside of your program
> > instead of editing the TNSNAMES.ORA file, further eliminating the
> > client-side setup work.
> 
> Could you perhaps send me an example of such a setup string for
> DCOracle2? Could you perhaps cc gerhard.haering at opus-gmbh.net ? That
> would be very kind.

Sure. Here's the format (all a one-line string):

frank/knarf@(description=(address=(host=1.2.3.4)(protocol=tcp)
(port=1521))(connect_data=(sid=mydb)))

where username/password = frank/knarf, the DB is at IP address 1.2.3.4, 
and the DB instance name is mydb. Just plop that in the connect string 
property of your Z Oracle Database Connection object and it should work.

-Dave





More information about the Python-list mailing list