Thanks Ray and Edson, I was able to finally connect. And the ODBCAD32.exe for 32 as well as 64 bit compatible was
presentin SYSWOW64 folder. This ODBCAD32.exe contained the PostgreSQL driver in DNS window. Thanks for all the inputs
whichhelped me to figure out the driver and connection string.
Cheers,
Mamatha
-----Original Message-----
From: Raymond O'Donnell [mailto:rod@iol.ie]
Sent: Thursday, October 20, 2011 3:54 PM
To: Chan, Mamatha Kagathi
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] psqlODBC connection
On 20/10/2011 05:23, Mamatha_Kagathi_Chan@DELL.com 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-bitODBC manager.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie