Обсуждение: help and Links using postgreSQL with ASP
Hi
Need help if there is any script source or links to provide help how to you PostgreSQL with ASP
Thanks & Regards
Pankaj
"SELF REALIZATION IS THE FIRST ENCOUNTER WITH REALITY -Sahajayoga.org."
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 ---------------------------------------------------------------