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  Transact-SQL (2000)  Linkserver problem while writing to Oracle DB

Author  Topic  vpeetham Starting Member 1 Post Posted - 2004-10-01 : 11:59:50 I need to insert data into Oracle database from SQL Server. I ran add link server, add link server login stored procedures and created Oracle link server. My T-SQL stored procedure runs successfully in Query analyzer and inserts data into Oracle tables. But the procedure fails while running in the SQL server job. The error message is "Could not initialize data source object of OLE DB provider 'MSDAORA'. [SQLSTATE 42000]" I appreciate your help.