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 Novice > SQl Server Link...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 3102 of 3177
Post > Topic >>

SQl Server Linked Server-Cant write to table with OID

by KenA@[EMAIL PROTECTED] ("Ken Allen") May 5, 2008 at 09:05 AM

This is a multi-part message in MIME format.

------_=_NextPart_001_01C8AEA8.48B58725
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.


------_=_NextPart_001_01C8AEA8.48B58725
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><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>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.<o:p></o:p></span></font></p>

</div>

</body>

</html>

------_=_NextPart_001_01C8AEA8.48B58725--
 




 1 Posts in Topic:
SQl Server Linked Server-Cant write to table with OID
KenA@[EMAIL PROTECTED] (  2008-05-05 09:05:17 

Post A Reply:
  Go here to Signup

AddThis Feed Button


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

Contact
tan13V112 Thu Jul 24 5:14:15 CDT 2008.