Re: [Pypgsql-users] Is there a How-To with scripting examples?

[Billy G. A. <Bil...@mu...>]

"Dave Strickler" wrote:
> I tried to to this, and the "from" command worked, and I got a lot
> further. But, as you can see from below, it wasn't 100% sucsessful. Any
> clues as to what is going wrong? I made a pg_hba.conf in the PgSQL
> directory, and added in my 10.0.0.120 address (that's my workstation),
> but it didn't help.
>  
> Any clues?
> ========================================
>  
> >>> dsn = "dbname='xamime' user='root' host='10.0.0.21'"
> >>> db =  PgSQL.connect(dsn)

The syntax for connect requires either a string in the form of:

	'host:port:database:user:password:options:tty'

i.e:

	dsn = '10.0.0.21::xamime:root'
	db = PgSQL.connect(dsn)

or passing named parameters:

	db = PgSQL.connect(database='xamime', user='root', host='10.0.0.21')

See the README file and the DB-API 2.0 spec for more details.

Later.
___________________________________________________________________________
____       | Billy G. Allie    | Domain....: Bil...@mu...
|  /|      | 7436 Hartwell     | MSN.......: B_G...@em...
|-/-|----- | Dearborn, MI 48126|
|/  |LLIE  | (313) 582-1540    |