Hi Ray, Thanks for the help. Since I am using classic ASP this is exactly what I am looking for. But there is a problem here. When I go the "Create New Data Source" window as mentioned in step ii, Ifind only sql server and Oracle drivers. I do not see PostgreSQL ODBC driver. But I am sure PsqlODBC is installed as it appears in the installed program list. Is there anything else I am missing, because of which the driver does not appear in the source?? Please let me know.
Thanks, Mamatha -----Original Message----- From: Raymond O'Donnell [mailto:r...@iol.ie] Sent: Wednesday, October 19, 2011 10:38 PM To: Chan, Mamatha Kagathi Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] psqlODBC connection On 19/10/2011 07:26, mamatha_kagathi_c...@dell.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 r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
