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
