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

[Sufficool, Stanley]

This is with SQL 2005? I don't have the OLEDB --> ODBC option as far as
I can tell. I have tried SQLOLEDB and MSDAOSP and both fail with:
 
SELECT * FROM 
OPENROWSET('SQLOLEDB',
'Driver={PostgreSQL
AMD64A};Server=server;Port=5432;Database=gis;Uid=user;Pwd=pass;',
'SELECT * FROM PRECINCT LIMIT 100')

OLE DB provider "SQLNCLI" for linked server "(null)" returned message
"Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "(null)" returned message
"An error has occurred while establishing a connection to the server. 
Named Pipes Provider: Could not open a connection to SQL Server [2]. 
OLE DB provider "SQLNCLI" for linked server "(null)" returned message
"Invalid connection string attribute".

I think the simple fact here is that SQL 2005 has removed support for
ODBC linked servers. 

I'm not sure if I can get PgOleDb to port to AMD64 with my version of
VC++ 2008 Express since the driver uses ATL.

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