Re: [GENERAL] help and Links using postgreSQL with ASP

2007-02-14 Thread Raymond O'Donnell

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
[EMAIL PROTECTED]
---


---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq


[GENERAL] help and Links using postgreSQL with ASP

2007-02-13 Thread Pankaj
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."