This is a multi-part message in MIME format.
------_=_NextPart_001_01C8A190.F3E65A8F
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hello,
=20
I have successfully created a linked server in my 32 bit test
environment using Windows 2003 R2 server to Postgres on SCO Unix. I can
query Postgres and run stored procedures from SQL Server and return
information from Postgres with no problems. Where I have encountered
issues is that my production environment is 64 bit Windows 2003 R2 and
64 bit SQL Server 2005. The issue is that even though I can install and
configure the 32 bit version of the ODBC driver, the 64 bit version of
SQL Server will not recognize the 32 bit ODBC driver. This makes it so
I cannot create a linked server in SQL Server using this ODBC driver and
hence run stored procedures that pull data from Postgres.
=20
I don't want to downgrade a production machine (because it won't be
easy) and it seems like such an easy fix. The pieces are there they
just won't talk. Does anyone know of a 64 bit Postgres driver (and
possibly how to configure it) or have any other ideas on how to resolve
this?
=20
Thanks in advance,
=20
Jeff Crumbley
=20
------_=_NextPart_001_01C8A190.F3E65A8F
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" =
xmlns:p=3D"urn:schemas-microsoft-com:office:powerpoint" =
xmlns:a=3D"urn:schemas-microsoft-com:office:access" =
xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" =
xmlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" =
xmlns:rs=3D"urn:schemas-microsoft-com:rowset" xmlns:z=3D"#RowsetSchema" =
xmlns:b=3D"urn:schemas-microsoft-com:office:publisher" =
xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet" =
xmlns:c=3D"urn:schemas-microsoft-com:office:component:spreadsheet" =
xmlns:oa=3D"urn:schemas-microsoft-com:office:activation" =
xmlns:html=3D"http://www.w3.org/TR/REC-html40"
=
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/"
xmlns:D=3D"DAV:" =
xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/xml"
=
xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/ois/"
=
xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/directory/"
=
xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#"
=
xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp"
=
xmlns:udc=3D"http://schemas.microsoft.com/data/udc"
=
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema"
=
xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/"=
xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"
=
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/"
=
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/"
=
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance"
=
xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile"
=
xmlns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/workflow/"
=
xmlns:mver=3D"http://schemas.openxmlformats.org/markup-compatibility/2006=
" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml"
=
xmlns:mrels=3D"http://schemas.openxmlformats.org/package/2006/relation****=
ps" =
xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/services/2006/types"=
=
xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/services/2006/messag=
es" xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@[EMAIL PROTECTED]
"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@[EMAIL PROTECTED]
15 5 2 2 2 4 3 2 4;}
@[EMAIL PROTECTED]
"Brush Script MT";
panose-1:3 6 8 2 4 4 6 7 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
..MsoChpDefault
{mso-style-type:ex****t-only;}
@[EMAIL PROTECTED]
Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal>Hello,<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>I have successfully created a linked server in my =
32 bit
test environment using Windows 2003 R2 server to Postgres on SCO =
Unix. I
can query Postgres and run stored procedures from SQL Server and return
information from Postgres with no problems. Where I have
encountered issues is that my production environment is 64 bit Windows =
2003 R2
and 64 bit SQL Server 2005. The issue is that even though I can =
install
and configure the 32 bit version of the ODBC driver, the 64 bit version =
of SQL
Server will not recognize the 32 bit ODBC driver. This makes it so =
I cannot
create a linked server in SQL Server using this ODBC driver and hence =
run
stored procedures that pull data from Postgres.<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>I don’t want to downgrade a production =
machine (because
it won’t be easy) and it seems like such an easy fix. The =
pieces
are there they just won’t talk. Does anyone know of a 64 bit
Postgres driver (and possibly how to configure it) or have any other =
ideas on
how to resolve this?<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Thanks in advance,<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal><span style=3D'font-size:14.0pt;font-family:"Brush =
Script MT"'>Jeff
Crumbley<o:p></o:p></span></p>
<p class=3DMsoNormal><o:p> </o:p></p>
</div>
</body>
</html>
------_=_NextPart_001_01C8A190.F3E65A8F--
|
