Re: 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