compiling odbc x64 on windows

--000e0cd2474028885c046f3c2af3
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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.

--000e0cd2474028885c046f3c2af3
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Re: compiling odbc x64 on windows

--000e0cd2513e3e2c1d046f3c60a9
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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

> 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-S erver-64-bit.html
>
>
>
> Jeff
>
>
> ------------------------------
>
> *From:* pgsql-odbc-owner@postgresql.org [mailto:
> pgsql-odbc-owner@postgresql.org] *On Behalf Of *Jasmin Dizdarevic
> *Sent:* Tuesday, July 21, 2009 2:22 PM
> *To:* pgsql-odbc@postgresql.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.
>

--000e0cd2513e3e2c1d046f3c60a9
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Re: compiling odbc x64 on windows

--001636c5bbd12f28fc046f99207a
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

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.dizdarevic@gmail.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.
>

--001636c5bbd12f28fc046f99207a
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Re: compiling odbc x64 on windows

--Apple-Mail-1--263248065
Content-Type: text/plain;
charset=us-ascii;
format=flowed;
delsp=yes
Content-Transfer-Encoding: 7bit

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 :

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

--Apple-Mail-1--263248065
Content-Type: text/html;
charset=utf-8
Content-Transfer-Encoding: 7bit

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

Re: compiling odbc x64 on windows

--001636c5a90b148841046f9fa402
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

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.dizdarevic@gmail.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 :
>
> 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.dizdarevic@gmail.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.
>>
>
>

--001636c5a90b148841046f9fa402
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Re: compiling odbc x64 on windows

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.dizdarevic@gmail.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-tp245941 69p24974687.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc