• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 138
  • Last Modified:

SQLServer Timeout Problem

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?
1 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.
xoxomosAuthor Commented:

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now