Thread: Doubt about ODBC Driver

On 05/26/2014 09:44 PM, Rodrigo Fabiam wrote:
> I have a web application, that I developed in ASP Classic, runs on Windows Server 2003.
> Today I tried run the app in another server, with 64-bit processor and Windows Server 2008.
>
> But I cannot connect my application in the PostgreSQL.
>
> My doubt is if your ODBC driver runs on 64-bit server, or it´s only on 32-bit?

It should work fine on a 64-bit system.

- Heikki

On 05/28/2014 12:09 PM, Heikki Linnakangas wrote:
> On 05/26/2014 09:44 PM, Rodrigo Fabiam wrote:
>> I have a web application, that I developed in ASP Classic, runs on
>> Windows Server 2003.
>> Today I tried run the app in another server, with 64-bit processor and
>> Windows Server 2008.
>>
>> But I cannot connect my application in the PostgreSQL.
>>
>> My doubt is if your ODBC driver runs on 64-bit server, or it´s only on
>> 32-bit?
>
> It should work fine on a 64-bit system.

There have two other reports recently of issues using the 32bit drivers
with Windows:

http://www.postgresql.org/message-id/537D0BD9.20063.1320DFA8@david.joffe.tshwanedje.com

http://www.postgresql.org/message-id/BLU174-W41B8887F4DD8BCC5D6BDC0AF3F0@phx.gbl

Not sure if Rodrigo is using the 32bit driver or not, but I am beginning
to sense a trend.

>
> - Heikki
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

On 06/16/2014 11:51 AM, Rodrigo Fabiam wrote:
> Hello Sirs,
>
> I have just tried to install the ODBC Driver, but I am having an error.
>
> I downloaded the most recent file: psqlodbc_09_03_0300-x64-1.zip
>
>   I have 3 files in my directory:
> - psqlodbc_x64.msi
> - README.txt
> - upgrade_x64.bat
>
> Then, I have run the psqlodbc_x64.msi.
> During the installation process, I had these error message that is attached.
>
> Could you help me at how to install this driver?

Does the user you are installing as have Administrator rights?



>
> PS: My OS is Windows Server 2008 R2 - 64 bits.
>
> Best regards.
>

--
Adrian Klaver
adrian.klaver@aklaver.com

On 06/17/2014 05:28 AM, Rodrigo Fabiam wrote:
> Yes, it has.
>


Hmm, I just tried it on a fresh EC2 instance of 2008R2 and am seeing the
same thing. I also installed the Redistributable Package like Denise
suggested:

http://www.postgresql.org/message-id/BLU174-W51F216D661442D3B02EEE7AF200@phx.gbl

but that did not work either. So I do not have a clue as to what is
going on.


--
Adrian Klaver
adrian.klaver@aklaver.com

On 06/17/2014 04:57 PM, Adrian Klaver wrote:
> On 06/17/2014 05:28 AM, Rodrigo Fabiam wrote:
>> Yes, it has.
>>
>
>
> Hmm, I just tried it on a fresh EC2 instance of 2008R2 and am seeing the
> same thing. I also installed the Redistributable Package like Denise
> suggested:
>
> http://www.postgresql.org/message-id/BLU174-W51F216D661442D3B02EEE7AF200@phx.gbl
>
> but that did not work either. So I do not have a clue as to what is
> going on.

Ah, I see. I was also able to reproduce this on a fresh EC2 instance.
The package that you need is called:

Microsoft Visual C++ 2010 Redistributable Package (x64)

http://www.microsoft.com/en-us/download/details.aspx?id=14632

After installing that, it worked for me. The message you linked to
suggests that you need the Visual C++ 2008 Redistributable Package, but
apparently the more recent installers are built against a newer
redistributable.

Is there any way we could build the driver so that it either doesn't
require that package, or to bundle it with the installer?

- Heikki