[postgis-users] NEED Win 64bit OleDb or ODBC Driver

[Sufficool, Stanley]

I am running PostgreSQL on 64bit Linux. I Just need to link the MS SQL
2005 Server to the UNIX PostgreSQL server. Being that MSSQL 2005 is
running 64bit, I need a 64 bit ODBC/OLEDB driver for the windows side. 

I checked out the ODBCNG source and attempted to build x64, but it is
failing on a few undefined consts
(PACKAGE_NAME/PACKAGE_VERSION/ODBCNG_FILE_NAME).

I'll try the beta x64 ODBC and see what flies.

Thanks

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Mark Cave-Ayland
> Sent: Friday, March 14, 2008 2:32 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] NEED Win 64bit OleDb or ODBC Driver
> 
> 
> On Friday 14 March 2008 00:02:48 Sufficool, Stanley wrote:
> > I am attempting to use linked servers (MSSQL / PG) on a 64bit 
> > platform. I have been searching for a 64bit driver 
> installer, but have 
> > yet to find one.
> >
> > Anyone have luck with this or do I need to roll my own?
> 
> Hmmm given that there is no 64-bit version of PostgreSQL for 
> Windows, I would 
> be very surprised  if there was a 64-bit ODBC driver. You may 
> find this 
> following link useful: 
> http://people.planetpostgresql.org/mha/index.php?/archives/162
-PostgreSQL-vs-64-bit-windows.html, 
although I'm sure Magnus has mentioned that before that the main problem
is 
to do with differing pointer sizes under Win64 compared to Unix :(


ATB,

Mark.

-- 
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk
T: +44 870 608 0063 _______________________________________________
postgis-users mailing list postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users