This topic has been archived. It cannot be replied.
-
工作学习 / 专业技术讨论 / Have a linked server AS/400 DB2 on SQL2000, From query analyzer, the select query runs ok but update/insert query fails to update DB2 table.. any expert DBA been through this? suggestion please. Thank you!
-sunday8(sunday8);
2006-8-2
(#3119530@0)
-
Show your update/insert command, it might help.
-morningboy01(Moring Boy);
2006-8-3
(#3121533@0)
-
update [LinkedServer].[CATALOG].[SCHEMANAME].[MYTABLE] set MYDATA=1
error: Could not open table '"LinkedServer"."SCHEMA"."MYTABLE"' from OLE DB
provider 'DB2OLEDB'. Unknown provider error.
-sunday8(sunday8);
2006-8-3
(#3121941@0)
-
Have your DB2/400 table got journaled? If you can inquiry, which means the setting should be correct.
-elac(elac);
2006-8-4
(#3124552@0)
-
this i am not sure. I have read an article that I don't have to set journal as long as I set Distributed Transaction to false or auto commit to true. it should work regardless enabling journal.
-sunday8(sunday8);
2006-8-4
(#3124634@0)
-
权限...看看你建立linked server的那个帐户是否有update和insert的权限.
-hard20(hard20);
2006-8-4
(#3124658@0)
-
I can update the table thru WinSQL with same username. The problem is that I need to update it from SQL2000.
-sunday8(sunday8);
2006-8-4
(#3124666@0)
-
说的就是看看你用AS400的帐号和密码能不能updateAS400那边的table.
-hard20(hard20);
2006-8-4
(#3124712@0)
-
再查看一下你ODBC的AS400 connection的设置,如果data access是read only的话,你也不能update AS400上的数据.
-hard20(hard20);
2006-8-4
(#3124740@0)