Re: help and Links using postgreSQL with ASP

Pankaj wrote:

> Need help if there is any script source or links to provide help how to you
> PostgreSQL with ASP

I just use ODBC and ADO - set up a DSN, and then it's as simple as:

set conn = Server.CreateObject("ADODB.Connection")
conn.Open "dsn=your_dsn;uid=your_user;pwd=your_pwd;"
set rs = conn.Execute "select * from your_table"
while not rs.EOF
[do something with the results]
wend
rs.Close
set rs = nothing
conn.Close
set conn = nothing

The ODBC driver is here: http://www.postgresql.org/ftp/odbc. There is
also an OLE-DB driver for PostgreSQL at
http://pgfoundry.org/projects/oledb/, but I haven't used it.

HTH.

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------