Re: compiling odbc x64 on windows

From: "Sufficool, Stanley" <ssufficool(at)sbcounty(dot)gov>
To: "Jasmin Dizdarevic" <jasmin(dot)dizdarevic(at)gmail(dot)com>, "Jeff Crumbley" <jeffc(at)iils(dot)com>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: compiling odbc x64 on windows
Date: 2009-07-21 21:21:35
Message-ID: C2F174F99918D54CA2A96E57C5079B6F015C41EB@sbc-exmsg2.sbcounty.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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.

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Saito 2009-07-22 13:48:29 Release Version 08.04.0100
Previous Message Jasmin Dizdarevic 2009-07-21 19:36:50 Re: compiling odbc x64 on windows