SQL Server Timeout Error

[neilpadilla]

Hi Guys,

Good day!

I am currently encountering the following error during the run of my job.

<ODBC call <SQLDriverConnect> for data source <bodssql\bodssql,12345> failed:<[Microsoft][SQL Server Native Client 10.0]TCP Provider: Timeout error [258]. >

I would like to ask for your help with the following:
     1. Where can I find the ODBC Configuration in BODS?
     2. Where can I find/modify the timeout values?

     3. Is this error related with the timeout configuration?
     4. What are the possible causes of this issue?

BODS Version: 4.0

Target Database 1: Microsoft SQL Server 2008
Target Database 2: Microsoft SQL Server 2005

Thanks,

Neil

[Former Member · Accepted solution]

Hi,

I think SQL Server timeout issue is related to Non-Availability of the Host / Cluster.

Below are answers for your Questions......

1. Where can I find the ODBC Configuration in BODS?

     This Information is available in ODBC.INI file on your Job Server (/usr/sap/{SID}/dataservices/DataDirect/odbc

2. Where can I find/modify the timeout values?

     You will be able to get tie out value from QueryTimeOut Parameter in odbc.ini file

3. Is this error related with the timeout configuration?

     I am not sure, this could be related to incorrect parameters in the connection string (Check HostName, UserID      and Password)
4. What are the possible causes of this issue?

     Can you try to login using SQL Server Management console and see how it goes..this will help you      troubleshoot and will help you narrow down on the exact issue