OCBC connection

[Sugrue, Sean]

I'm trying to make an odbc connection to postgresql which is on a server
using python.
Does anyone have a code snippet to make a basic connection with a select
query?

Sean

[kyosohma]

On Sep 28, 9:57 am, "Sugrue, Sean" <Sean.Sug...@an alog.comwrote:

I'm trying to make an odbc connection to postgresql which is on a server
using python.
Does anyone have a code snippet to make a basic connection with a select
query?

Sean

Sean,

This appears to be what you're looking for:

http://www.devx.com/opensource/Article/29071

See also Python Database spec and module page:

http://www.python.org/topics/database/

Mike

[Steve Holden]

ky******@gmail. com wrote:

On Sep 28, 9:57 am, "Sugrue, Sean" <Sean.Sug...@an alog.comwrote:

>I'm trying to make an odbc connection to postgresql which is on a server
using python.
Does anyone have a code snippet to make a basic connection with a select
query?

Sean

Sean,

This appears to be what you're looking for:

http://www.devx.com/opensource/Article/29071

See also Python Database spec and module page:

http://www.python.org/topics/database/

Mike:

This doesn't address the ODBC part of the inquiry. I was actually going
to respond saying I wasn't aware of an ODBC driver for PostgreSQL
(though I'd be surprised if there wasn't one).

Using the psycopg2 module, which is my preferred PostgreSQL interface
module, it's easy to answer:

>>curs = conn.cursor()
import psycopg2 as db
conn = db.connect(data base="pycon", user="username" ,

password="passw ord", host="localhost ", port=5432)

>>curs = conn.cursor()
curs.execute( "SELECT orgid, orgname FROM organization")
from pprint import pprint # just for neatness
pprint(curs.f etchall())

[(1, 'AB Strakt'),
(79, 'DevIS'),
...
(113, 'Test Organization'),
(19, 'Holden Web LLC')]

>>>

regards
Steve
--
Steve Holden [phone] [phone]
Holden Web LLC/Ltd http://www.holdenweb.com
Skype: holdenweb http://del.icio.us/steve.holden

Sorry, the dog ate my .sigline

[kyosohma]

On Sep 28, 1:07 pm, Steve Holden <st...@holdenwe b.comwrote:

kyoso...@gmail. com wrote:

On Sep 28, 9:57 am, "Sugrue, Sean" <Sean.Sug...@an alog.comwrote:

I'm trying to make an odbc connection to postgresql which is on a server
using python.
Does anyone have a code snippet to make a basic connection with a select
query?

Sean

Sean,

This appears to be what you're looking for:

http://www.devx.com/opensource/Article/29071

See also Python Database spec and module page:

http://www.python.org/topics/database/

Mike:

This doesn't address the ODBC part of the inquiry. I was actually going
to respond saying I wasn't aware of an ODBC driver for PostgreSQL
(though I'd be surprised if there wasn't one).

Using the psycopg2 module, which is my preferred PostgreSQL interface
module, it's easy to answer:

>>curs = conn.cursor()
>>import psycopg2 as db
>>conn = db.connect(data base="pycon", user="username" ,

password="passw ord", host="localhost ", port=5432)

>>curs = conn.cursor()
>>curs.execute( "SELECT orgid, orgname FROM organization")
>>from pprint import pprint # just for neatness
>>pprint(curs.f etchall())

[(1, 'AB Strakt'),
(79, 'DevIS'),
...
(113, 'Test Organization'),
(19, 'Holden Web LLC')]

>>>

regards
Steve
--
Steve Holden [phone] [phone]
Holden Web LLC/Ltd http://www.holdenweb.com
Skype: holdenweb http://del.icio.us/steve.holden

Sorry, the dog ate my .sigline

Whoops! I almost posted some code using the adodb or the odbc module,
which is what I would have probably used, but I figured I'd take a
look and see if there was a postgres module available. I'm not seeing
any basic differences between your code and the code I linked to
though...except that if I ran your first line of code, I would get an
exception as "conn" hasn't been defined yet.

Whatever. I apologize for being misleading(?)

Mike

[Steve Holden]

ky******@gmail. com wrote:
[...]

>>

> >>curs = conn.cursor()
import psycopg2 as db
conn = db.connect(data base="pycon", user="username" ,

password="passw ord", host="localhost ", port=5432)

> >>curs = conn.cursor()
curs.execute( "SELECT orgid, orgname FROM organization")
from pprint import pprint # just for neatness
pprint(curs.f etchall())

[(1, 'AB Strakt'),
(79, 'DevIS'),
...
(113, 'Test Organization'),
(19, 'Holden Web LLC')]

> >>>

Whoops! I almost posted some code using the adodb or the odbc module,
which is what I would have probably used, but I figured I'd take a
look and see if there was a postgres module available. I'm not seeing
any basic differences between your code and the code I linked to
though...except that if I ran your first line of code, I would get an
exception as "conn" hasn't been defined yet.

Whatever. I apologize for being misleading(?)

I screwed up anyway - the first line shouldn't have been included.

But perhaps Sean could enlighten us as to whether ODBC is really a
requirement, or simply the first solution that he thought of. I don't
know why one would *require* ODBC.

regards
Steve
--
Steve Holden [phone] [phone]
Holden Web LLC/Ltd http://www.holdenweb.com
Skype: holdenweb http://del.icio.us/steve.holden

Sorry, the dog ate my .sigline