Re: 126 Error Connecting With psqlODBC 32 bit

Well, guess what? After much pain, but absolutely worth it, I've gotten it to work. It turns out that some postgre is compiled in C++ and with Windows 2008, the C++ Redistributable is not installed by default. So I installed this:
http://www.microsoft.com/en-us/download/details.aspx?id=29
And now I am able to configure the 32bit postgreSQL Unicode driver on my server, and of course I am also able to use it through my .asp page with connection string:
connstr= "Driver={PostgreSQL UNICODE};DATABASE=dbname;Server=ipaddress;UID=userid;PWD=password;"
I really hope this helps, and thanks to all who looked into it.
Thanks again,Denise

> Date: Sun, 1 Jun 2014 19:29:32 -0700
> From: adrian(dot)klaver(at)aklaver(dot)com
> To: denisemichele(at)outlook(dot)com; pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] 126 Error Connecting With psqlODBC 32 bit
>
> On 06/01/2014 01:53 PM, Adrian Klaver wrote:
> > On 05/22/2014 04:37 PM, Denise McGrath wrote:
> >> Hi,
> >>
> >> I got your email from the faq page
> >> http://psqlodbc.projects.pgfoundry.org/faq.html. I am having a really
> >> difficult time setting up the 32 bit psqlodbc driver. I have the 9.3
> >> version of PostgreSQL. It downloaded the psqlodbc_09_03_0210-x64
> >> <http://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_09_03_0210-x64.zip>
> >> and
> >> that worked fine as far as connecting to the database through
> >> pgAdminIII, but I need to use a 32 bit because I am running an asp page
> >> that connects to the PostgreSQL 9.3 database.
> >>
> >> So I downloaded the psqlodbc_09_03_0210.zip
> >> <http://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_09_03_0210-x64.zip>
> >> latest
> >> driver.
> >
> >>
> >> "The setup routines for the PostgreSQL ANSI ODBC driver could not be
> >> loaded due to system error code 126: The specified module could not be
> >> found. (C:\Program Files (x86)\psqlODBC\0903\bin\psqlodbc35w.dll)."
> >>
> >
> >> Is there anything else that I am missing? Please please help as I have
> >> working on this for almost a week with no luck and am completely
> >> baffled :-(
> >
> > Anyone have an idea on what is going on here. I confirmed the error
> > using a clean Windows Server 2008R2 AMI on AWS. I tried to add a 32bit
> > DataSource and got the same error.
>
> Well the previous comment was about psqlodbc_09_03_0210.zip.
>
> With psqlodbc_09_03_0300-x64.zip I cannot even get it to install.
> Running Dependency Walker psqlodbc30a.dll shows several issues seen in
> the attached screenshot.
>
> I see the same thing with psqlodbc_09_03_0300.zip
>
> >
> >>
> >> Thanks!
> >> Denise
> >
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com