On Mon, Oct 26, 2009 at 5:00 PM, JAGANADH G <jagana...@gmail.com> wrote: > On Mon, Oct 26, 2009 at 4:46 PM, Anand Chitipothu <anandol...@gmail.com>wrote: > >> > I was trying to connect to postgre db with Python psycopg2 . The code for >> > connecting the db is >> > >> > import psycopg2 >> > >> > try: >> > dbconn = psycopg2.connect( "dbname=%s user=%s\ >> > host='localhost' password=%s" ) % ( dbname,dbuser, dbpass ) >> > except: >> > raise >> >> You are trying to pass all db parameters. You should be doing some >> thing like this: >> >> conn = psycopg2.connect(dbname=dbname, user=dbuser, password=dbpass) >> >> Anand >> > > Now I did it . The code will be now > > dbcs = "dbname=%s user=%s host='localhost' password=%s" %(dbname, > dbuser,dbpass)
It is not same. You are trying to creating one string and pass that string as argument to connect. But I passed 3 different parameters. f(1, 2) is not same as f("1 2"). Anand _______________________________________________ BangPypers mailing list BangPypers@python.org http://mail.python.org/mailman/listinfo/bangpypers