x

Oracle Rdb Database - Connection Time Out Error

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 !

more ▼

asked Sep 08, 2011 at 09:52 AM in Default

avatar image

Kirman
334 29 29 34

Any thoughts on the above query...

Thanks

Sep 09, 2011 at 02:02 AM Kirman
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Sep 22, 2011 at 07:05 AM

avatar image

alexsdba
221 1 1 4

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1096
x434

asked: Sep 08, 2011 at 09:52 AM

Seen: 1768 times

Last Updated: Sep 09, 2011 at 05:53 AM

Copyright 2016 Redgate Software. Privacy Policy