SQLServer Timeout Problem

Posted on 2014-08-12
Last Modified: 2014-08-14
Trying to retrieve from Oracle database and getting timeout errors on MS side.
SQL Server side, the errors are OLEDB Fetch errors like the one shown below:
Source.PS_STDNT_ENRL (0 Rows in 00:09:05 - 0.00 rps) (Cannot fetch a row from OLE DB provider "OraOLEDB.Oracle" for linked server "hebprd".)

What do i look for on MSSQLServer side for 2008?
Question by:xoxomos
    LVL 23

    Accepted Solution

    There could be a problem in one of 2 spots - either the ODBC connect or the linked server definition in the MSSQL server.

    ODBC: Log into the same server that SQL is running on.  Go to Start -> [Control Panel] -> Administrative Tools -> Data Sources (ODBC).  Your connection is likely under the "System DSN" tab.  Click on it and then click on "Configure" - check the settings to connect to your Oracle database.

    For the Linked Server, open SSMS and connect to the MSSQL database.  Expand the server in the Object Explorer and then expand "Server Objects" and then expand "Linked Servers".  The link to your Oracle database should appear here.  Right click on it and select "Properties".  Go through the General, Security, and Server Options settings.

    Author Closing Comment


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    26 Experts available now in Live!

    Get 1:1 Help Now