<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=551095911-14032008><FONT face=Arial
color=#0000ff size=2>I didn't read your last part about the linked servers
deal. I was planning to do the same thing for a SQL Server 2005
64-bit server and went as far as installing the 64-bit driver I mentioned
here</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=551095911-14032008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=551095911-14032008><FONT face=Arial
color=#0000ff size=2><A
href="http://www.geocities.jp/inocchichichi/psqlodbc/index.html">http://www.geocities.jp/inocchichichi/psqlodbc/index.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=551095911-14032008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=551095911-14032008><FONT face=Arial
color=#0000ff size=2>Then I ran into another snaffu - (a Microsoft one) -
evidentally or at least last I checked, Microsoft has not released a 64-bit
version of the OLEDB Provider for ODBC needed to make 64-bit ODBC connections
via Linked Server</FONT></SPAN></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=551095911-14032008>I think its called MSDAOSP or something of that sort
which I think was called <FONT color=#000000><FONT
size=2>MSDASQL</FONT> in prior versions</FONT><FONT
color=#ff0000>.</FONT></SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=551095911-14032008></SPAN></FONT></FONT></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=551095911-14032008><SPAN class=551095911-14032008><A
href="http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2495186&SiteID=17">http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2495186&SiteID=17</A></SPAN></SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=551095911-14032008></SPAN></FONT></FONT></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=551095911-14032008></SPAN></FONT></FONT></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=551095911-14032008>Let me know if you find out otherwise since I would be
VERY INTERESTED too.</SPAN> <SPAN class=551095911-14032008>
</SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=551095911-14032008></SPAN></FONT></FONT></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=551095911-14032008>I was thining of trying the OLEDB PostgreSQL driver,
but not sure if there is a 64-bit version of that and I think its a lot
less tested than ODBC.</SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=551095911-14032008></SPAN></FONT></FONT></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=551095911-14032008>I was hoping I could use the ADO.NET driver but haven't
quite figured out how to register that in the Linked servers providers list or
if I am missing yet another piece of glue.</SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=551095911-14032008></SPAN></FONT></FONT></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=551095911-14032008>Sorry couldn't be more
helpful,</SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=551095911-14032008>Regina</SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=551095911-14032008></SPAN></FONT></FONT></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=551095911-14032008><A
href="http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2495186&SiteID=17"></A></SPAN></FONT></FONT></FONT> </DIV>
<DIV dir=ltr align=left><SPAN class=551095911-14032008><FONT face=Arial
color=#0000ff size=2></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>Sufficool, Stanley<BR><B>Sent:</B> Thursday, March 13, 2008 8:03
PM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] NEED Win 64bit OleDb or ODBC Driver<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=484455923-13032008><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=484455923-13032008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=484455923-13032008><FONT face=Arial size=2>Anyone have luck
with this or do I need to roll my own?</FONT></SPAN></DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>