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

[S_Sriram]

Hi Neil

1. For you time out issue kindly refer the SAP KBA

1671058 - ERROR: ODBC call <SQLDriverConnect> for data source <datasource> failed

2.

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

Check this SAP Note   1248222 - ODBC DBSL profile parameters and connect options

BR

SS

[neilpadilla]

Hi SS,

Thanks for your answers. However, the timeout error that I am encountering is not related to a login error.

Thanks,

Neil