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

[Bruce Rindahl]

Use the ODBC driver to configure a connection to PostgreSQL.  Then use the
Microsoft OLEDB - ODBC driver to connect to the PostgreSQL database.  I have
done this using the 32 bit drivers.  I don't know about 64 bit.
Bruce

-----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 9:56 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] NEED Win 64bit OleDb or ODBC Driver

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
> 
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users