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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] 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 [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
