Thanks Ray and Edson, I was able to finally connect. And the ODBCAD32.exe for 32 as well as 64 bit compatible was present in SYSWOW64 folder. This ODBCAD32.exe contained the PostgreSQL driver in DNS window. Thanks for all the inputs which helped me to figure out the driver and connection string. Cheers, Mamatha -----Original Message----- From: Raymond O'Donnell [mailto:rod@xxxxxx] Sent: Thursday, October 20, 2011 3:54 PM To: Chan, Mamatha Kagathi Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: psqlODBC connection On 20/10/2011 05:23, Mamatha_Kagathi_Chan@xxxxxxxx wrote: > 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. Hi Mamatha, As Edson said upthread, you might have installed the 32-bit driver on 64-bit Windows, in which case you have to use the 32-bit ODBC manager. 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
