RE: Help!!! [Microsoft][ODBC SQL Server Driver]Timeout expired

Hi

Sounds like blocking at table level. If network connection issues occur, DTC
notices it and aborts.

Regards
Mike

"Chan" wrote:

> Hi all...
>
> Environment
> OS : Windows 2000 Advanced Server(SP4)
> SQL Server : Microsoft SQL Server 2000(SP3)
> DB Accessing : MSDTC, ODBC, COM+(VC++) calling Stored Procedure through
> firewall
>
> i have four databases, each size are 8G, 400M, 18G, 500M
> there is a firewall between COM+ Server and SQL Server
>
> so, i have configured port configuration for MSDTC as recommended by
> Microsoft Support site
> http://support.microsoft.com/kb/250367
>
> almost for the past 1.5 years. my com+ application has worked 99.9999% fine
> but from about a month ago i got this error at every particular NIGHT
> time(ie. 22:00)
> on particular database
>
> [Microsoft][ODBC SQL Server Driver]Timeout expired
> Com Error : DESC-->[Microsoft][ODBC SQL Server Driver]Timeout expired
> MSG-->OR_20001_SN_ReceiptOrder
> IDispatch error #3121 Error Count:1 GetLastError Number:0.
>
> once this error occurrs, all other components which are using "transaction"
> get the same error over and over and over again till i restart MSDTC service
> or
> SQL Server Database.
> really strange thing is that this error NEVER occurrs at a daytime
>
> i found the fact that sp starts and never completed after tracing by using
> query profiler
>
> is this related to network resource or table locking?
> has anybody seen this case? or any ideas?
.

Relevant Pages

  • Re: Avoid application hanging
    ... // valid network connection ... "Tim De Vogel" wrote: ... I developed a pocketpc application that connects directly to a SQL Server ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Avoid application hanging
    ... you have to handle the case where the network connection might not be ... I developed a pocketpc application that connects directly to a SQL Server ... usign wifi. ... whatever) the mobile application hangs, ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Unusual mapped drive in my exchange server machine --- help
    ... The network connection could not be found. ... but sure as crap its still there. ... The Nt patches were as up to date as that day, but that for some reason I ... >> drive is my SQL server drive on my SQL server machine. ...
    (microsoft.public.exchange.admin)
  • No connection to local SQL Server when no network connection
    ... The computer is a SONY notebook. ... SQL server is running on the same machine as the application. ... When there is no network connection, ... The connection string for connecting our app to the database is something ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL server question
    ... Microsoft is deprecating it even for new development, ... An Access project is an Access file that provides a direct, ... You can connect an Access project to a remote SQL Server ... a local SQL Server database, or a local installation of the SQL Server ...
    (comp.databases.ms-access)
Loading