From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | Mamatha_Kagathi_Chan(at)DELL(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: psqlODBC connection |
Date: | 2011-10-19 17:08:03 |
Message-ID: | 4E9F03F3.3010109@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 19/10/2011 07:26, Mamatha_Kagathi_Chan(at)DELL(dot)com wrote:
> Hi,
>
>
>
> I have installed psqlODBC and I can see the dll files in the bin
> folder. But what shall I do next to connect My ASP page? Please help.
I moved away from ASP a long time ago, so memory is rusty, but here goes:
(i) Go to the ODBC data sources manager (under Administrative tools on
my Windows 7 laptop)
(ii) Create a new data source, using the PostgreSQL ODBC driver.
(iii) In your ASP page, do something like:
dim conn
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DSN=your_data_source_name"
This is using classic ASP, mind you, not ASP.NET - the latter may be
different.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | Edson Richter | 2011-10-19 17:15:49 | Re: psqlODBC connection |
Previous Message | Tom Lane | 2011-10-19 17:03:19 | Re: pg_dump not including custom CAST based on table types |