Re: compiling odbc x64 on windows

hi,

because there is no x64-version of the odbc-driver out there i want to
compile it myself.
I've already compiled the 32-bit driver and now I'm going further.

I've got two questions:
1.) do i need x64 openssl for compiling?
2.) if you install the odbc-driver regulary from the msi-package there are
some other dll-files in the installation\bin folder.
do i need x64-versions of these files also?

i know that the 32bit-driver works on 64bit-machines, but i always have to
run all applications in 32bit-mode to use the pgsql-odbc-driver.
that's not very sexy.

thank you.

Hi,

i didn't know that...thank you very much!
Just another question. Is there something like linkedserver in mssql for
pgsql available? does pglink support the connection to other dbms?

ty

2009/7/21 Jeff Crumbley <jeffc(at)iils(dot)com>

> 64-bit driver and setup instructions here:
>
>
>
>
> http://www.postgresonline.com/journal/index.php?/archives/46-Setting-up-PostgreSQL-as-a-Linked-Server-in-Microsoft-SQL-Server-64-bit.html
>
>
>
> Jeff
>
>
> ------------------------------
>
> *From:* pgsql-odbc-owner(at)postgresql(dot)org [mailto:
> pgsql-odbc-owner(at)postgresql(dot)org] *On Behalf Of *Jasmin Dizdarevic
> *Sent:* Tuesday, July 21, 2009 2:22 PM
> *To:* pgsql-odbc(at)postgresql(dot)org
> *Subject:* [ODBC] compiling odbc x64 on windows
>
>
>
> hi,
>
>
>
> because there is no x64-version of the odbc-driver out there i want to
> compile it myself.
>
> I've already compiled the 32-bit driver and now I'm going further.
>
>
>
> I've got two questions:
>
> 1.) do i need x64 openssl for compiling?
>
> 2.) if you install the odbc-driver regulary from the msi-package there are
> some other dll-files in the installation\bin folder.
>
> do i need x64-versions of these files also?
>
>
>
> i know that the 32bit-driver works on 64bit-machines, but i always have to
> run all applications in 32bit-mode to use the pgsql-odbc-driver.
>
> that's not very sexy.
>
>
>
> thank you.
>

Been there done that, and given up.

You need an OLEDB driver for linked servers under MSSQL x64 since they
stopped shipping x64 version of the OLEDB for ODBC providers.

Search the list, you will find where that thread died.


-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Jasmin Dizdarevic
Sent: Tuesday, July 21, 2009 12:37 PM
To: Jeff Crumbley; pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] compiling odbc x64 on windows

Hi,

i didn't know that...thank you very much!
Just another question. Is there something like linkedserver in mssql for
pgsql available? does pglink support the connection to other dbms?

ty

2009/7/21 Jeff Crumbley <jeffc(at)iils(dot)com>

64-bit driver and setup instructions here:

http://www.postgresonline.com/journal/index.php?/archives/46-Setting-up-
PostgreSQL-as-a-Linked-Server-in-Microsoft-SQL-Server-64-bit.html

Jeff

_____

From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Jasmin Dizdarevic
Sent: Tuesday, July 21, 2009 2:22 PM
To: pgsql-odbc(at)postgresql(dot)org
Subject: [ODBC] compiling odbc x64 on windows

hi,

because there is no x64-version of the odbc-driver out there i want to
compile it myself.

I've already compiled the 32-bit driver and now I'm going further.

I've got two questions:

1.) do i need x64 openssl for compiling?

2.) if you install the odbc-driver regulary from the msi-package there
are some other dll-files in the installation\bin folder.

do i need x64-versions of these files also?

i know that the 32bit-driver works on 64bit-machines, but i always have
to run all applications in 32bit-mode to use the pgsql-odbc-driver.

that's not very sexy.

thank you.

I just finished creating a VC2005 solution that allows you to build the ODBC
drivers for 64 bit.It also contains the OpenSSL binaries, and postgres
sources (in order to build libpq for 64 bit).

I can share it with you if you want.
I'm also considering uploading it to some open source hosted web site...
(since there's no free binary distribution of the 64 bit odbc drivers for
Windows).

If more than one or two people need these drivers, I probably will.

On Tue, Jul 21, 2009 at 10:21 PM, Jasmin Dizdarevic <
jasmin(dot)dizdarevic(at)gmail(dot)com> wrote:

> hi,
>
> because there is no x64-version of the odbc-driver out there i want to
> compile it myself.
> I've already compiled the 32-bit driver and now I'm going further.
>
> I've got two questions:
> 1.) do i need x64 openssl for compiling?
> 2.) if you install the odbc-driver regulary from the msi-package there are
> some other dll-files in the installation\bin folder.
> do i need x64-versions of these files also?
>
> i know that the 32bit-driver works on 64bit-machines, but i always have to
> run all applications in 32bit-mode to use the pgsql-odbc-driver.
> that's not very sexy.
>
> thank you.
>

Hello assaf,

I'm very interested into your work. And you should release it, because
x64 support is becoming more important.

Ty & greets
Jasmin

Von meinem iPhone gesendet

Am 26.07.2009 um 12:15 schrieb Assaf Lavie <assaflavie(at)gmail(dot)com>:

> I just finished creating a VC2005 solution that allows you to build
> the ODBC drivers for 64 bit.
> It also contains the OpenSSL binaries, and postgres sources (in
> order to build libpq for 64 bit).
>
> I can share it with you if you want.
> I'm also considering uploading it to some open source hosted web
> site... (since there's no free binary distribution of the 64 bit
> odbc drivers for Windows).
>
> If more than one or two people need these drivers, I probably will.
>
>
> On Tue, Jul 21, 2009 at 10:21 PM, Jasmin Dizdarevic <jasmin(dot)dizdarevic(at)gmail(dot)com
> > wrote:
> hi,
>
> because there is no x64-version of the odbc-driver out there i want
> to compile it myself.
> I've already compiled the 32-bit driver and now I'm going further.
>
> I've got two questions:
> 1.) do i need x64 openssl for compiling?
> 2.) if you install the odbc-driver regulary from the msi-package
> there are some other dll-files in the installation\bin folder.
> do i need x64-versions of these files also?
>
> i know that the 32bit-driver works on 64bit-machines, but i always
> have to run all applications in 32bit-mode to use the pgsql-odbc-
> driver.
> that's not very sexy.
>
> thank you.
>

Well, I will.
I created a whole thing with installers (InnoSetup) and all the dependencies
this morning.
The installers are pretty small (1-2 MB) so I can email you if you want.

But the thing is - in order to build psqlODBC I needed to build libPQ, and
for that I downloaded the entire source code of Postgres (AFAIK you can't
just download libpq) and the Open SSL binaries.
So at the moment the solution really contains the above projects as well,
and I'm not sure it's ok to distribute them along with my solution/project
files.

Maybe what I'll do is package the whole thing without the 230MB of postgres
source code, and just instruct people to go download it their selves...

So anyway, I can send you the installers (32 & 64 bit) tomorrow if you wish.
Uploading the solution sources would take me a while longer.

On Sun, Jul 26, 2009 at 6:48 PM, Jasmin Dizdarevic <
jasmin(dot)dizdarevic(at)gmail(dot)com> wrote:

> Hello assaf,
>
> I'm very interested into your work. And you should release it, because x64
> support is becoming more important.
>
> Ty & greets
> Jasmin
>
> Von meinem iPhone gesendet
>
> Am 26.07.2009 um 12:15 schrieb Assaf Lavie <assaflavie(at)gmail(dot)com>:
>
> I just finished creating a VC2005 solution that allows you to build the
> ODBC drivers for 64 bit.It also contains the OpenSSL binaries, and
> postgres sources (in order to build libpq for 64 bit).
>
> I can share it with you if you want.
> I'm also considering uploading it to some open source hosted web site...
> (since there's no free binary distribution of the 64 bit odbc drivers for
> Windows).
>
> If more than one or two people need these drivers, I probably will.
>
>
> On Tue, Jul 21, 2009 at 10:21 PM, Jasmin Dizdarevic <<jasmin(dot)dizdarevic(at)gmail(dot)com>
> jasmin(dot)dizdarevic(at)gmail(dot)com> wrote:
>
>> hi,
>>
>> because there is no x64-version of the odbc-driver out there i want to
>> compile it myself.
>> I've already compiled the 32-bit driver and now I'm going further.
>>
>> I've got two questions:
>> 1.) do i need x64 openssl for compiling?
>> 2.) if you install the odbc-driver regulary from the msi-package there are
>> some other dll-files in the installation\bin folder.
>> do i need x64-versions of these files also?
>>
>> i know that the 32bit-driver works on 64bit-machines, but i always have to
>> run all applications in 32bit-mode to use the pgsql-odbc-driver.
>> that's not very sexy.
>>
>> thank you.
>>
>
>

Hi Assaf,

Are this binarys available from some website?

Regards
Frode

Assaf Lavie wrote:
>
> I just finished creating a VC2005 solution that allows you to build the
> ODBC
> drivers for 64 bit.It also contains the OpenSSL binaries, and postgres
> sources (in order to build libpq for 64 bit).
>
> I can share it with you if you want.
> I'm also considering uploading it to some open source hosted web site...
> (since there's no free binary distribution of the 64 bit odbc drivers for
> Windows).
>
> If more than one or two people need these drivers, I probably will.
>
>
> On Tue, Jul 21, 2009 at 10:21 PM, Jasmin Dizdarevic <
> jasmin(dot)dizdarevic(at)gmail(dot)com> wrote:
>
>> hi,
>>
>> because there is no x64-version of the odbc-driver out there i want to
>> compile it myself.
>> I've already compiled the 32-bit driver and now I'm going further.
>>
>> I've got two questions:
>> 1.) do i need x64 openssl for compiling?
>> 2.) if you install the odbc-driver regulary from the msi-package there
>> are
>> some other dll-files in the installation\bin folder.
>> do i need x64-versions of these files also?
>>
>> i know that the 32bit-driver works on 64bit-machines, but i always have
>> to
>> run all applications in 32bit-mode to use the pgsql-odbc-driver.
>> that's not very sexy.
>>
>> thank you.
>>
>
>

--
View this message in context: http://www.nabble.com/compiling-odbc-x64-on-windows-tp24594169p24974687.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.