On further inspection I see the one you are pointing at is a commercial implementation of the PostgreSQL OLE DB Provider and not the one packaged with PostgreSQL source and binaries. We haven't tried that one at all so can't vouch for its strength compared to using ODBC over the OLEDB Provider for ODBC. A really robust solution I would suspect would be a Native SQL Server .NET provider for PostgreSQL, but I haven't figured out how all that works to see if the NpgSQL.NET driver can be fashioned as such. I think native SQL Server for Oracle and DB2 providers exist. Thanks, Regina
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Konstantin Izmailov Sent: Saturday, April 26, 2008 1:00 AM To: PostGIS Users Discussion Cc: [EMAIL PROTECTED] Subject: Re: [postgis-users] PostgreSQL Linked Server on SQL Server 2005 64-bit I have doubt about performance and scalability of this approach. Correct me if I'm wrong but native PostgreSQL OLE DB Provider would have done work more efficiently (see http://www.postgresql.org/about/news.895 - version 1.2.8 supports Linked Servers). On Fri, Apr 25, 2008 at 6:02 PM, Paragon Corporation <[EMAIL PROTECTED]> wrote: Sorry for the cross-post here. I think the issue of being able to connect to PostgreSQL from a 64-bit Windows system and in particular 64-bit SQL Server 2005 has come up a couple of times on both PostGIS and PostgreSQL ODBC groups. Jeff Crumbley kindly notified us that Microsoft released this month a 64-bit OLEDB for ODBC driver which now makes connecting from a 64-it SQL Server install via a Linked Server configuration possible. We thank him greatly for that and have our linked servers working now. We have posted the steps we took to achieve this on an Intel 64-bit SQL Server 2005 install. So far seems to work well for us. We hope this information is valuable to others. http://www.postgresonline.com/journal/index.php?/archives/46-Setting-up-Post <http://www.postgresonline.com/journal/index.php?/archives/46-Setting-up-Pos tgreSQL-as-a-Linked-Server-in-Microsoft-SQL-Server-64-bit.html> greSQL-as-a-Linked-Server-in-Microsoft-SQL-Server-64-bit.html Thanks, Leo and Regina _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
