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
---------------------------------------------------------------
