Thread: 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@iol.ie
---------------------------------------------------------------