Search Postgresql Archives

Re: psqlODBC connection

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 19/10/2011 07:26, Mamatha_Kagathi_Chan@xxxxxxxx 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@xxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux