Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Cannot update t...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 15472 of 16112
Post > Topic >>

Cannot update table with OID with linked server in SQl Server

by KenA@[EMAIL PROTECTED] ("Ken Allen") May 6, 2008 at 04:45 PM

This is a multi-part message in MIME format.

------_=_NextPart_001_01C8AFB1.CDD02497
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I have a linked server on SQL server 2005.  I can update or write to a
table in Postgres that does not have a OID.  But the Table I have has an
OID and I cannot write or update to that table.  Anyone have any ideas.

=20


------_=_NextPart_001_01C8AFB1.CDD02497
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>
<!--
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:Arial;
	color:windowtext;}
@[EMAIL PROTECTED]
 Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:.2in;margin-right:0in;margin-bottom:
..2in;margin-left:0in;line-height:14.4pt'><font size=3D2 color=3Dblack =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:black'>I have a linked =
server
on SQL server 2005.&nbsp; I can update or write to a table in Postgres =
that
does not have a OID.&nbsp; But the Table I have has an OID and I cannot =
write
or update to that table.&nbsp; Anyone have any ideas.</span></font><font
size=3D1 color=3Dblack><span =
style=3D'font-size:8.5pt;color:black'><o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

</div>

</body>

</html>

------_=_NextPart_001_01C8AFB1.CDD02497--
 




 1 Posts in Topic:
Cannot update table with OID with linked server in SQl Server
KenA@[EMAIL PROTECTED] (  2008-05-06 16:45:57 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 20 4:36:56 CDT 2008.