<!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><SPAN class=760342608-26042008><FONT face=Arial
color=#0000ff size=2>Konstantin,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=760342608-26042008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=760342608-26042008><FONT face=Arial
color=#0000ff size=2>We'll have to take a look at that. I always thought
that the PostgreSQL OLE DB provider was less tested and robust than the ODBC
one, but I have to admit its been a while since we have looked at
it. Last I tried it which was awhile ago, I couldn't get it to
go in a linked server configuration or for SSIS processing. Things
have probably changed as you mention.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=760342608-26042008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=760342608-26042008><FONT face=Arial
color=#0000ff size=2>I'll have to revisit this.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=760342608-26042008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=760342608-26042008><FONT face=Arial
color=#0000ff size=2>Thanks for the suggestion.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=760342608-26042008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=760342608-26042008><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></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>