Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group