Doubt about ODBC Driver

[Rodrigo Fabiam]

Hello Sirs,

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?

Best regards.

[Heikki Linnakangas]

Post by Rodrigo Fabiam
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

[Adrian Klaver]

Post by Heikki Linnakangas

Post by Rodrigo Fabiam
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/***@david.joffe.tshwanedje.com

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

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

Post by Heikki Linnakangas
- Heikki

[Adrian Klaver]

Post by Rodrigo Fabiam
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
- 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?

Post by Rodrigo Fabiam
PS: My OS is Windows Server 2008 R2 - 64 bits.
Best regards.

[Adrian Klaver]

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-***@phx.gbl

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

[Heikki Linnakangas]

Post by Adrian Klaver

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

[Rodrigo Fabiam]

Yes, it has.


________________________________
De: Adrian Klaver <***@aklaver.com>
Para: Rodrigo Fabiam <***@yahoo.com.br>; Heikki Linnakangas <***@vmware.com>; "pgsql-***@postgresql.org" <pgsql-***@postgresql.org>
Enviadas: Segunda-feira, 16 de Junho de 2014 22:53
Assunto: Re: [ODBC] Doubt about ODBC Driver

Post by Rodrigo Fabiam
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
- 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?

Post by Rodrigo Fabiam
PS: My OS is Windows Server 2008 R2 - 64 bits.
Best regards.

[Rodrigo Fabiam]

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?

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

Best regards.




________________________________
De: Adrian Klaver <***@aklaver.com>
Para: Heikki Linnakangas <***@vmware.com>; Rodrigo Fabiam <***@yahoo.com.br>; "pgsql-***@postgresql.org" <pgsql-***@postgresql.org>
Enviadas: Quarta-feira, 28 de Maio de 2014 18:53
Assunto: Re: [ODBC] Doubt about ODBC Driver

Post by Heikki Linnakangas

Post by Rodrigo Fabiam
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/***@david.joffe.tshwanedje.com

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

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

Post by Heikki Linnakangas
- Heikki