I have a SQL Agent Job . There is a TSQL Command.
In TSQL Commad we have the Openquery which gets connected to Oracle Rdb database.
The job fails stating the connection time out.
I want to know where exactly in Oracle Rdb database I can go and change the Connection time out settings.
Please help !
See if this query works for you:
SELECT * FROM OPENQUERY(your_oracle_linked_server, 'select sysdate from dual')
If it doesn't then check your linked server/ODBC settings.
answered Sep 22, 2011 at 07:05 AM