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

[Sufficool, Stanley]

ODBC passes connectivity test at the manager level, however you can't
use an ODBC driver (only OleDb) to link SQL 2005 to PostgreSQL servers
:( .

I don't suppose anyone has made inroads into porting the OleDb driver...

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Sufficool, Stanley
> Sent: Friday, March 14, 2008 8:06 AM
> To: PostGIS Users Discussion
> Subject: RE: [postgis-users] NEED Win 64bit OleDb or ODBC Driver
> 
> 
> 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
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>