<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16640" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=416103208-26042008>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.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV dir=ltr align=left><SPAN class=416103208-26042008><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN><SPAN class=416103208-26042008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=416103208-26042008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=416103208-26042008><FONT face=Arial
color=#0000ff size=2>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=416103208-26042008><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=416103208-26042008></SPAN></FONT> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Konstantin Izmailov<BR><B>Sent:</B> Saturday, April 26, 2008 1:00
AM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Cc:</B>
pgsql-odbc@postgresql.org<BR><B>Subject:</B> Re: [postgis-users] PostgreSQL
Linked Server on SQL Server 2005 64-bit<BR></FONT><BR></DIV>
<DIV></DIV>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 <A
href="http://www.postgresql.org/about/news.895">http://www.postgresql.org/about/news.895</A> -
version 1.2.8 supports Linked Servers).<BR><BR>
<DIV class=gmail_quote>On Fri, Apr 25, 2008 at 6:02 PM, Paragon Corporation
<<A href="mailto:lr@paragoncorporation.com">lr@paragoncorporation.com</A>>
wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><BR>Sorry
for the cross-post here. I think the issue of being able to
connect<BR>to PostgreSQL from a 64-bit Windows system and in particular 64-bit
SQL<BR>Server 2005 has come up a couple of times on both PostGIS and
PostgreSQL<BR>ODBC groups. Jeff Crumbley kindly notified us that
Microsoft released this<BR>month a 64-bit OLEDB for ODBC driver which now
makes connecting from a 64-it<BR>SQL Server install via a Linked Server
configuration possible. We thank him<BR>greatly for that and have our
linked servers working now.<BR><BR>We have posted the steps we took to achieve
this on an Intel 64-bit SQL<BR>Server 2005 install. So far seems to work
well for us. We hope this<BR>information is valuable to
others.<BR><BR><A
href="http://www.postgresonline.com/journal/index.php?/archives/46-Setting-up-PostgreSQL-as-a-Linked-Server-in-Microsoft-SQL-Server-64-bit.html"
target=_blank>http://www.postgresonline.com/journal/index.php?/archives/46-Setting-up-Post<BR>greSQL-as-a-Linked-Server-in-Microsoft-SQL-Server-64-bit.html</A><BR><BR>Thanks,<BR>Leo
and
Regina<BR><BR><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR></BLOCKQUOTE></DIV><BR></BODY></HTML>