<

Connecting To SQL Server From Oracle Using Heterogeneous Services Generic Gateway

Posted on
6,454 Points
3,155 Views
3 Endorsements
Last Modified:
Published
Experience Level: Beginner
5:20
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
3
Author:Steve Wales
0 Comments
One of the most common issues faced while connecting to a SQL Server instance is "Login failed for user 'username'. (Microsoft SQL Server, Error: 18456)". In addition to the Error No. SQL Server will provide an Error State no. which will be helpful…
This article discusses various scenarios that can end up in a DBCC CHECKDB process getting stuck in a Killed/Rollback state and how to resolve the problem.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month