DTS Oracle->SQL2000, who connects to ora?
- Using the wizard from SQL Enterprise Manager on a client PC I set up and
run a DTS package to import tables from a Oracle DB to SQL Server 2000. It
- Some investigation showed, that the connection to the Oracle Server was
made from the client PC (I think by SQL*Net), not from the SQL Server. Surprise!
- In case I want to schedule this package, the connection to Oracle definitely
has be made from the SQL Server. Right?
How can I influence in DTS, who connects to Oracle (in this example), as
long as I start the job in EntManager from my WS?
I assume: if I am sure, that the connection from the SQLServer to OraServer
works, it also should be easy to setup Oracle as a linked server in SQLServer?
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL