Our LAN has a server with an Oracle DB. I need data from that database, and I can ALREADY get that data through DTS. I use "Microsoft OLE DB Provider for Oracle" to run the packages. So I know that a connection IS possible.
Now I want to make a view that draws data from Oracle. How do I do that? There is no obvious way to make the connection.
Now I want to make a view that draws data from Oracle. How do I do that? There is no obvious way to make the connection.