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

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

--000e0cd2474028885c046f3c2af3--
Jasmin Dizdarevic [ Di, 21 Juli 2009 21:21 ] [ ID #2009330 ]

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

<div>Hi, </div>
<div>=A0</div>
<div>i didn't know that...thank you very much! </div>
<div>Just another question. Is there something like linkedserver in mssql f=
or pgsql available? does pglink support=A0the connection to other dbms?</di=
v>
<div>=A0</div>
<div>ty<br><br></div>
<div class=3D"gmail_quote">2009/7/21 Jeff Crumbley <span dir=3D"ltr"><<a=
href=3D"mailto:jeffc [at] iils.com">jeffc [at] iils.com</a>></span><br>
<blockquote style=3D"BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex=
; PADDING-LEFT: 1ex" class=3D"gmail_quote">
<div lang=3D"EN-US" vlink=3D"purple" link=3D"blue">
<div>
<p><font color=3D"navy" size=3D"2" face=3D"Tahoma"><span style=3D"FONT-FAMI=
LY: Tahoma; COLOR: navy; FONT-SIZE: 11pt">64-bit driver and setup instructi=
ons here:</span></font></p>
<p><font color=3D"navy" size=3D"2" face=3D"Tahoma"><span style=3D"FONT-FAMI=
LY: Tahoma; COLOR: navy; FONT-SIZE: 11pt">=A0</span></font></p>
<p><font color=3D"navy" size=3D"2" face=3D"Tahoma"><span style=3D"FONT-FAMI=
LY: Tahoma; COLOR: navy; FONT-SIZE: 11pt"><a title=3D"blocked::http://www.p=
ostgresonline.com/journal/index.php?/archives/46-Setting-up- PostgreSQL-as-a=
-Linked-Server-in-Microsoft-SQL-Server-64-bit.html" href=3D"http://www.post=
gresonline.com/journal/index.php?/archives/46-Setting-up-Pos tgreSQL-as-a-Li=
nked-Server-in-Microsoft-SQL-Server-64-bit.html" target=3D"_blank">http://w=
ww.postgresonline.com/journal/index.php?/archives/46-Setting -up-PostgreSQL-=
as-a-Linked-Server-in-Microsoft-SQL-Server-64-bit.html</a></span></font></p=
>

<p><font color=3D"navy" size=3D"2" face=3D"Tahoma"><span style=3D"FONT-FAMI=
LY: Tahoma; COLOR: navy; FONT-SIZE: 11pt">=A0</span></font></p>
<div>
<p><font color=3D"blue" size=3D"4" face=3D"Brush Script MT"><span style=3D"=
FONT-FAMILY: 'Brush Script MT'; COLOR: blue; FONT-SIZE: 14pt">Jeff<=
/span></font><font color=3D"navy" size=3D"4"><span style=3D"COLOR: navy; FO=
NT-SIZE: 14pt"></span></font></p>
</div>
<p><font color=3D"navy" size=3D"2" face=3D"Tahoma"><span style=3D"FONT-FAMI=
LY: Tahoma; COLOR: navy; FONT-SIZE: 11pt">=A0</span></font></p>
<div>
<div style=3D"TEXT-ALIGN: center" align=3D"center"><font size=3D"3" face=3D=
"Times New Roman"><span style=3D"FONT-SIZE: 12pt">
<hr align=3D"center" size=3D"2" width=3D"100%">
</span></font></div>
<p><b><font size=3D"2" face=3D"Tahoma"><span style=3D"FONT-FAMILY: Tahoma; =
FONT-SIZE: 10pt; FONT-WEIGHT: bold">From:</span></font></b><font size=3D"2"=
face=3D"Tahoma"><span style=3D"FONT-FAMILY: Tahoma; FONT-SIZE: 10pt"> <a h=
ref=3D"mailto:pgsql-odbc-owner [at] postgresql.org" target=3D"_blank">pgsql-odbc=
-owner [at] postgresql.org</a> [mailto:<a href=3D"mailto:pgsql-odbc-owner [at] postgr=
esql.org" target=3D"_blank">pgsql-odbc-owner [at] postgresql.org</a>] <b><span s=
tyle=3D"FONT-WEIGHT: bold">On Behalf Of </span></b>Jasmin Dizdarevic<br>
<b><span style=3D"FONT-WEIGHT: bold">Sent:</span></b> Tuesday, July 21, 200=
9 2:22 PM<br><b><span style=3D"FONT-WEIGHT: bold">To:</span></b> <a href=3D=
"mailto:pgsql-odbc [at] postgresql.org" target=3D"_blank">pgsql-odbc [at] postgresql.=
org</a><br>
<b><span style=3D"FONT-WEIGHT: bold">Subject:</span></b> [ODBC] compiling o=
dbc x64 on windows</span></font></p></div>
<div>
<div></div>
<div class=3D"h5">
<p><font size=3D"3" face=3D"Times New Roman"><span style=3D"FONT-SIZE: 12pt=
">=A0</span></font></p>
<div>
<p><font size=3D"3" face=3D"Times New Roman"><span style=3D"FONT-SIZE: 12pt=
">hi, </span></font></p></div>
<div>
<p><font size=3D"3" face=3D"Times New Roman"><span style=3D"FONT-SIZE: 12pt=
">=A0</span></font></p></div>
<div>
<p><font size=3D"3" face=3D"Times New Roman"><span style=3D"FONT-SIZE: 12pt=
">because there is no x64-version of the odbc-driver out there i want to co=
mpile it myself.</span></font></p></div>
<div>
<p><font size=3D"3" face=3D"Times New Roman"><span style=3D"FONT-SIZE: 12pt=
">I've already compiled the 32-bit driver and now I'm going further=
.. </span></font></p></div>
<div>
<p><font size=3D"3" face=3D"Times New Roman"><span style=3D"FONT-SIZE: 12pt=
">=A0</span></font></p></div>
<div>
<p><font size=3D"3" face=3D"Times New Roman"><span style=3D"FONT-SIZE: 12pt=
">I've got two questions:</span></font></p></div>
<div>
<p><font size=3D"3" face=3D"Times New Roman"><span style=3D"FONT-SIZE: 12pt=
">1.) do i need x64 openssl for compiling?</span></font></p></div>
<div>
<p><font size=3D"3" face=3D"Times New Roman"><span style=3D"FONT-SIZE: 12pt=
">2.) if you install the odbc-driver regulary from the msi-package there ar=
e some other dll-files in the installation\bin folder.</span></font></p></d=
iv>

<div>
<p><font size=3D"3" face=3D"Times New Roman"><span style=3D"FONT-SIZE: 12pt=
">do i need x64-versions of these files also?</span></font></p></div>
<div>
<p><font size=3D"3" face=3D"Times New Roman"><span style=3D"FONT-SIZE: 12pt=
">=A0</span></font></p></div>
<div>
<p><font size=3D"3" face=3D"Times New Roman"><span style=3D"FONT-SIZE: 12pt=
">i know that the 32bit-driver works on 64bit-machines, but i always have t=
o run all applications in 32bit-mode to use the pgsql-odbc-driver. </span><=
/font></p>
</div>
<div>
<p><font size=3D"3" face=3D"Times New Roman"><span style=3D"FONT-SIZE: 12pt=
">that's not very sexy.</span></font></p></div>
<div>
<p><font size=3D"3" face=3D"Times New Roman"><span style=3D"FONT-SIZE: 12pt=
">=A0</span></font></p></div>
<div>
<p><font size=3D"3" face=3D"Times New Roman"><span style=3D"FONT-SIZE: 12pt=
">thank you.</span></font></p></div></div></div></div></div></blockquote></=
div><br>

--000e0cd2513e3e2c1d046f3c60a9--
Jasmin Dizdarevic [ Di, 21 Juli 2009 21:36 ] [ ID #2009331 ]

Re: compiling odbc x64 on windows

------_=_NextPart_001_01CA0A49.3A5CBD49
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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.org
[mailto:pgsql-odbc-owner [at] postgresql.org] On Behalf Of Jasmin Dizdarevic
Sent: Tuesday, July 21, 2009 12:37 PM
To: Jeff Crumbley; pgsql-odbc [at] postgresql.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.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.org
[mailto:pgsql-odbc-owner [at] postgresql.org] On Behalf Of Jasmin Dizdarevic
Sent: Tuesday, July 21, 2009 2:22 PM
To: pgsql-odbc [at] 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.



------_=_NextPart_001_01CA0A49.3A5CBD49
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<TITLE>Message</TITLE>

<META content=3D"MSHTML 6.00.6000.16850" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D049581721-21072009><FONT face=3DArial color=3D#0000ff =
size=3D2>Been
there done that, and given up. </FONT></SPAN></DIV>
<DIV><SPAN class=3D049581721-21072009><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D049581721-21072009><FONT face=3DArial color=3D#0000ff =
size=3D2>You
need an OLEDB driver for linked servers under MSSQL x64 since they =
stopped
shipping x64 version of the OLEDB for ODBC =
providers.</FONT></SPAN></DIV>
<DIV><SPAN class=3D049581721-21072009><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D049581721-21072009><FONT face=3DArial color=3D#0000ff =
size=3D2>Search
the list, you will find where that thread died.</FONT></SPAN></DIV>
<DIV><SPAN class=3D049581721-21072009></SPAN><SPAN =
class=3D049581721-21072009><FONT
face=3DArial color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D049581721-21072009><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN> </DIV>
<DIV></DIV>
<DIV><FONT face=3DTahoma size=3D2>-----Original =
Message-----<BR><B>From:</B>
pgsql-odbc-owner [at] postgresql.org [mailto:pgsql-odbc-owner [at] postgresql.org] =
<B>On
Behalf Of </B>Jasmin Dizdarevic<BR><B>Sent:</B> Tuesday, July 21, 2009 =
12:37
PM<BR><B>To:</B> Jeff Crumbley; =
pgsql-odbc [at] postgresql.org<BR><B>Subject:</B> Re:
[ODBC] compiling odbc x64 on windows<BR><BR></DIV></FONT>
<BLOCKQUOTE
style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px =
solid; MARGIN-RIGHT: 0px">
<DIV>Hi, </DIV>
<DIV> </DIV>
<DIV>i didn't know that...thank you very much! </DIV>
<DIV>Just another question. Is there something like linkedserver in =
mssql for
pgsql available? does pglink support the connection to other =
dbms?</DIV>
<DIV> </DIV>
<DIV>ty<BR><BR></DIV>
<DIV class=3Dgmail_quote>2009/7/21 Jeff Crumbley <SPAN =
dir=3Dltr><<A
href=3D"mailto:jeffc [at] iils.com">jeffc [at] iils.com</A>></SPAN><BR>
<BLOCKQUOTE class=3Dgmail_quote
style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: =
#ccc 1px solid">
<DIV lang=3DEN-US link=3D"blue" vlink=3D"purple">
<DIV>
<P><FONT face=3DTahoma color=3Dnavy size=3D2><SPAN
style=3D"FONT-SIZE: 11pt; COLOR: navy; FONT-FAMILY: Tahoma">64-bit =
driver and
setup instructions here:</SPAN></FONT></P>
<P><FONT face=3DTahoma color=3Dnavy size=3D2><SPAN
style=3D"FONT-SIZE: 11pt; COLOR: navy; FONT-FAMILY: =
Tahoma"></SPAN></FONT> </P>
<P><FONT face=3DTahoma color=3Dnavy size=3D2><SPAN
style=3D"FONT-SIZE: 11pt; COLOR: navy; FONT-FAMILY: Tahoma"><A
=
title=3Dblocked::http://www.postgresonline.com/journal/index .php?/archive=
s/46-Setting-up-PostgreSQL-as-a-Linked-Server-in-Microsoft-S QL-Server-64-=
bit.html
=
href=3D"http://www.postgresonline.com/journal/index.php?/arc hives/46-Sett=
ing-up-PostgreSQL-as-a-Linked-Server-in-Microsoft-SQL-Server -64-bit.html"=

=
target=3D_blank>http://www.postgresonline.com/journal/index. php?/archives=
/46-Setting-up-PostgreSQL-as-a-Linked-Server-in-Microsoft-SQ L-Server-64-b=
it.html</A></SPAN></FONT></P>
<P><FONT face=3DTahoma color=3Dnavy size=3D2><SPAN
style=3D"FONT-SIZE: 11pt; COLOR: navy; FONT-FAMILY: =
Tahoma"></SPAN></FONT> </P>
<DIV>
<P><FONT face=3D"Brush Script MT" color=3Dblue size=3D4><SPAN
style=3D"FONT-SIZE: 14pt; COLOR: blue; FONT-FAMILY: 'Brush Script =
MT'">Jeff</SPAN></FONT><FONT
color=3Dnavy size=3D4><SPAN
style=3D"FONT-SIZE: 14pt; COLOR: navy"></SPAN></FONT></P></DIV>
<P><FONT face=3DTahoma color=3Dnavy size=3D2><SPAN
style=3D"FONT-SIZE: 11pt; COLOR: navy; FONT-FAMILY: =
Tahoma"></SPAN></FONT> </P>
<DIV>
<DIV style=3D"TEXT-ALIGN: center" align=3Dcenter><FONT face=3D"Times =
New Roman"
size=3D3><SPAN style=3D"FONT-SIZE: 12pt">
<HR align=3Dcenter width=3D"100%" SIZE=3D2>
</SPAN></FONT></DIV>
<P><B><FONT face=3DTahoma size=3D2><SPAN
style=3D"FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">From:</SPAN></FONT></B><FONT
face=3DTahoma size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma"> <A
href=3D"mailto:pgsql-odbc-owner [at] postgresql.org"
target=3D_blank>pgsql-odbc-owner [at] postgresql.org</A> [mailto:<A
href=3D"mailto:pgsql-odbc-owner [at] postgresql.org"
target=3D_blank>pgsql-odbc-owner [at] postgresql.org</A>] <B><SPAN
style=3D"FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Jasmin
Dizdarevic<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> =
Tuesday,
July 21, 2009 2:22 PM<BR><B><SPAN style=3D"FONT-WEIGHT: =
bold">To:</SPAN></B>
<A href=3D"mailto:pgsql-odbc [at] postgresql.org"
target=3D_blank>pgsql-odbc [at] postgresql.org</A><BR><B><SPAN
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> [ODBC] compiling =
odbc x64 on
windows</SPAN></FONT></P></DIV>
<DIV>
<DIV></DIV>
<DIV class=3Dh5>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN
style=3D"FONT-SIZE: 12pt"></SPAN></FONT> </P>
<DIV>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: =
12pt">hi,
</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN
style=3D"FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: =
12pt">because
there is no x64-version of the odbc-driver out there i want to =
compile it
myself.</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: =
12pt">I've
already compiled the 32-bit driver and now I'm going further.
</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN
style=3D"FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: =
12pt">I've
got two questions:</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: =
12pt">1.) do
i need x64 openssl for compiling?</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: =
12pt">2.) if
you install the odbc-driver regulary from the msi-package there are =
some
other dll-files in the installation\bin =
folder.</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: =
12pt">do i
need x64-versions of these files also?</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN
style=3D"FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: =
12pt">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.
</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: =
12pt">that's
not very sexy.</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN
style=3D"FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: =
12pt">thank
=
you.</SPAN></FONT></P></DIV></DIV></DIV></DIV></DIV></BLOCKQUOTE></DIV><B=
R></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01CA0A49.3A5CBD49--
ssufficool [ Di, 21 Juli 2009 23:21 ] [ ID #2009460 ]

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 [at] 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

<div dir=3D"ltr">I just finished creating a VC2005 solution that allows you=
to build the ODBC drivers for 64 bit.<div>It also contains the OpenSSL bin=
aries, and postgres sources (in order to build libpq for 64 bit).</div><div=
>

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

<div><br></div><div>If more than one or two people need these drivers, I pr=
obably will.</div><div><br><br><div class=3D"gmail_quote">On Tue, Jul 21, 2=
009 at 10:21 PM, Jasmin Dizdarevic <span dir=3D"ltr"><<a href=3D"mailto:=
jasmin.dizdarevic [at] gmail.com">jasmin.dizdarevic [at] gmail.com</a>></span> wro=
te:<br>

<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex;"><div>hi, </div>
<div>=C2=A0</div>
<div>because there is no x64-version of the odbc-driver out there i want to=
compile it myself.</div>
<div>I've already compiled the 32-bit driver and now I'm going furt=
her. </div>
<div>=C2=A0</div>
<div>I've got two questions:</div>
<div>1.) do i need x64 openssl for compiling?</div>
<div>2.) if you install the odbc-driver regulary from the msi-package there=
are some other dll-files in the installation\bin folder.</div>
<div>do i need x64-versions of these files also?</div>
<div>=C2=A0</div>
<div>i know that the 32bit-driver works on 64bit-machines, but i always hav=
e to run all applications in 32bit-mode to use the pgsql-odbc-driver. </div=
>
<div>that's not very sexy.</div>
<div>=C2=A0</div>
<div>thank you.</div>
</blockquote></div><br></div></div>

--001636c5bbd12f28fc046f99207a--
Assaf Lavie [ So, 26 Juli 2009 12:15 ] [ ID #2009887 ]

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 <assaflavie [at] gmail.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.dizdarevic [at] 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.
>

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

<html><body bgcolor="#FFFFFF"><div>Hello assaf, </div><div><br></div><div>I'm very interested into your work. And you should release it, because x64 support is becoming more important.</div><div><br></div><div>Ty & greets</div><div>Jasmin    <br><br>Von meinem iPhone gesendet</div><div><br>Am 26.07.2009 um 12:15 schrieb Assaf Lavie <assaflavie [at] gmail.com>:<br><br></div><div></div><blockquote type="cite"><div><div dir="ltr">I just finished creating a VC2005 solution that allows you to build the ODBC drivers for 64 bit.<div>It also contains the OpenSSL binaries, and postgres sources (in order to build libpq for 64 bit).</div><div>

<br></div><div>I can share it with you if you want.</div><div>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).</div>

<div><br></div><div>If more than one or two people need these drivers, I probably will.</div><div><br><br><div class="gmail_quote">On Tue, Jul 21, 2009 at 10:21 PM, Jasmin Dizdarevic <span dir="ltr"><<a href="mailto:jasmin.dizdarevic [at] gmail.com">jasmin.dizdarevic [at] gmail.com</a>></span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div>hi, </div>
<div> </div>
<div>because there is no x64-version of the odbc-driver out there i want to compile it myself.</div>
<div>I've already compiled the 32-bit driver and now I'm going further. </div>
<div> </div>
<div>I've got two questions:</div>
<div>1.) do i need x64 openssl for compiling?</div>
<div>2.) if you install the odbc-driver regulary from the msi-package there are some other dll-files in the installation\bin folder.</div>
<div>do i need x64-versions of these files also?</div>
<div> </div>
<div>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. </div>
<div>that's not very sexy.</div>
<div> </div>
<div>thank you.</div>
</blockquote></div><br></div></div>
</div></blockquote></body></html>
--Apple-Mail-1--263248065--
Jasmin Dizdarevic [ So, 26 Juli 2009 18:48 ] [ ID #2009888 ]

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 [at] 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 <assaflavie [at] gmail.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.dizdarevic [at] gmail.com>
> jasmin.dizdarevic [at] 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

<div dir=3D"ltr">Well, I will.<br>I created a whole thing with installers (=
InnoSetup) and all the dependencies this morning.<br>The installers are pre=
tty small (1-2 MB) so I can email you if you want.<br><br>But the thing is =
- in order to build psqlODBC I needed to build libPQ, and for that I downlo=
aded the entire source code of Postgres (AFAIK you can't just download =
libpq) and the Open SSL binaries.<br>

So at the moment the solution really contains the above projects as well, a=
nd I'm not sure it's ok to distribute them along with my solution/p=
roject files.<br><br>Maybe what I'll do is package the whole thing with=
out the 230MB of postgres source code, and just instruct people to go downl=
oad it their selves... <br>

<br>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.<br><=
br><br><div class=3D"gmail_quote">On Sun, Jul 26, 2009 at 6:48 PM, Jasmin D=
izdarevic <span dir=3D"ltr"><<a href=3D"mailto:jasmin.dizdarevic [at] gmail.c=
om">jasmin.dizdarevic [at] gmail.com</a>></span> wrote:<br>

<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div bgcolor=3D"#=
FFFFFF"><div>Hello assaf,=C2=A0</div><div><br></div><div>I'm very inter=
ested into your work. And you should release it, because x64 support is bec=
oming more important.</div>

<div><br></div><div>Ty & greets</div><div>Jasmin =C2=A0 =C2=A0<br><br>V=
on meinem iPhone gesendet</div><div><br>Am 26.07.2009 um 12:15 schrieb Assa=
f Lavie <<a href=3D"mailto:assaflavie [at] gmail.com" target=3D"_blank">assaf=
lavie [at] gmail.com</a>>:<br>

<br></div><div><div></div><div class=3D"h5"><div></div><blockquote type=3D"=
cite"><div><div dir=3D"ltr">I just finished creating a VC2005 solution that=
allows you to build the ODBC drivers for 64 bit.<div>It also contains the =
OpenSSL binaries, and postgres sources (in order to build libpq for 64 bit)=
..</div>

<div>

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



<div><br></div><div>If more than one or two people need these drivers, I pr=
obably will.</div><div><br><br><div class=3D"gmail_quote">On Tue, Jul 21, 2=
009 at 10:21 PM, Jasmin Dizdarevic <span dir=3D"ltr"><<a href=3D"mailto:=
jasmin.dizdarevic [at] gmail.com" target=3D"_blank"></a><a href=3D"mailto:jasmin=
..dizdarevic [at] gmail.com" target=3D"_blank">jasmin.dizdarevic [at] gmail.com</a>>=
;</span> wrote:<br>



<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>hi, </div>
<div>=C2=A0</div>
<div>because there is no x64-version of the odbc-driver out there i want to=
compile it myself.</div>
<div>I've already compiled the 32-bit driver and now I'm going furt=
her. </div>
<div>=C2=A0</div>
<div>I've got two questions:</div>
<div>1.) do i need x64 openssl for compiling?</div>
<div>2.) if you install the odbc-driver regulary from the msi-package there=
are some other dll-files in the installation\bin folder.</div>
<div>do i need x64-versions of these files also?</div>
<div>=C2=A0</div>
<div>i know that the 32bit-driver works on 64bit-machines, but i always hav=
e to run all applications in 32bit-mode to use the pgsql-odbc-driver. </div=
>
<div>that's not very sexy.</div>
<div>=C2=A0</div>
<div>thank you.</div>
</blockquote></div><br></div></div>
</div></blockquote></div></div></div></blockquote></div><br></div>

--001636c5a90b148841046f9fa402--
Assaf Lavie [ So, 26 Juli 2009 20:02 ] [ ID #2009889 ]

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 [at] 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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
frodewj [ Fr, 14 August 2009 18:32 ] [ ID #2012278 ]
Datenbanken » gmane.comp.db.postgresql.odbc » compiling odbc x64 on windows

Vorheriges Thema: Pre-Built Binaries of psqlODBC for 64-bit Windows
Nächstes Thema: Is there a mysthical problem with psqlODBC + MSAccess + sequencesIN SCHEMAS ?