This is a multi-part message in MIME format.
--===============1271532918==
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_000B_01C8A756.4A0B74F0"
This is a multi-part message in MIME format.
------=_NextPart_000_000B_01C8A756.4A0B74F0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Konstantin,
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.
I'll have to revisit this.
Thanks for the suggestion.
Regina
_____
From: postgis-users-bounces [at] postgis.refractions.net
[mailto:postgis-users-bounces [at] postgis.refractions.net] On Behalf Of
Konstantin Izmailov
Sent: Saturday, April 26, 2008 1:00 AM
To: PostGIS Users Discussion
Cc: pgsql-odbc [at] postgresql.org
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
<lr [at] paragoncorporation.com> 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.ht ml>
greSQL-as-a-Linked-Server-in-Microsoft-SQL-Server-64-bit.htm l
Thanks,
Leo and Regina
_______________________________________________
postgis-users mailing list
postgis-users [at] postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-user s
------=_NextPart_000_000B_01C8A756.4A0B74F0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.6000.16640" name=3DGENERATOR></HEAD>
<BODY>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D760342608-26042008><FONT =
face=3DArial
color=3D#0000ff size=3D2>Konstantin,</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D760342608-26042008><FONT =
face=3DArial
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D760342608-26042008><FONT =
face=3DArial
color=3D#0000ff size=3D2>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=3Dltr align=3Dleft><SPAN class=3D760342608-26042008><FONT =
face=3DArial
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D760342608-26042008><FONT =
face=3DArial
color=3D#0000ff size=3D2>I'll have to revisit this.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D760342608-26042008><FONT =
face=3DArial
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D760342608-26042008><FONT =
face=3DArial
color=3D#0000ff size=3D2>Thanks for the suggestion.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D760342608-26042008><FONT =
face=3DArial
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D760342608-26042008><FONT =
face=3DArial
color=3D#0000ff size=3D2>Regina</FONT></SPAN></DIV><BR>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B>
postgis-users-bounces [at] postgis.refractions.net
[mailto:postgis-users-bounces [at] 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 [at] 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=3D"http://www.postgresql.org/about/news.895">http://www .postgresql.o=
rg/about/news.895</A> -
version 1.2.8 supports Linked Servers).<BR><BR>
<DIV class=3Dgmail_quote>On Fri, Apr 25, 2008 at 6:02 PM, Paragon =
Corporation
<<A =
href=3D"mailto:lr [at] paragoncorporation.com">lr [at] paragoncorporat ion.com</A>&g=
t;
wrote:<BR>
<BLOCKQUOTE class=3Dgmail_quote
style=3D"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=3D"http://www.postgresonline.com/journal/index.php?/arc hives/46-Sett=
ing-up-PostgreSQL-as-a-Linked-Server-in-Microsoft-SQL-Server -64-bit.html"=
=
target=3D_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>post=
gis-users
mailing list<BR><A
=
href=3D"mailto:postgis-users [at] postgis.refractions.net">postgi s-users [at] postg=
is.refractions.net</A><BR><A
href=3D"http://postgis.refractions.net/mailman/listinfo/post gis-users" =
=
target=3D_blank>http://postgis.refractions.net/mailman/listi nfo/postgis-u=
sers</A><BR></BLOCKQUOTE></DIV><BR></BODY></HTML>
------=_NextPart_000_000B_01C8A756.4A0B74F0--
--===============1271532918==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
postgis-users mailing list
postgis-users [at] postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-user s
--===============1271532918==--
