insert into Oracle table from SQL Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

insert into Oracle table from SQL Server

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-05-15 : 07:23:20

Diana writes "I have found no one that has ever done this simple task. I can select from the Oracle table but not insert into. I have to build some logic around this and execute this daily to keep the 2 in sync.

SELECT *
FROM OPENQUERY([risexw.caemilusa_test.local],
'SELECT * FROM LaborOwner.salary_approvals_backup')

Successfully runs

insert into
[risexw.caemilusa_test.local]..LaborOwner.salary_approvals_backup
select employee_id,
week_ending_date,
date_of_employee_approval,
supervisor_id,
date_of_supervisor_approval,
comment_text,
uniform_allow_day,
date_added from LaborOwner.salary_approvals;

Error Returned -
Server: Msg 7314, Level 16, State 1, Line 1
OLE DB provider 'risexw.caemilusa_test.local' does not contain table
'"laborowner"."salary_approvals_backup"'. The table either does not
exist or the current user does not have permissions on that table.
OLE DB error trace [Non-interface error: OLE DB provider does not
contain the table: ProviderName='risexw.caemilusa_test.local',
TableName='"laborowner"."salary_approvals_backup"'].

I am out of ideas to try.
Diana"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources