Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ASP .NET - Timeout expired

5 posts in DelphidotNet Last posting was on 2006-04-28 14:58:42.0Z
Rados³aw Wójtowicz Posted on 2006-04-27 14:01:45.0Z
From: "Rados³aw Wójtowicz" <francja@elegancja>
Newsgroups: Advantage.DelphidotNet
Subject: ASP .NET - Timeout expired
Date: Thu, 27 Apr 2006 16:01:45 +0200
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 83.17.226.42
Message-ID: <4450cdfb@solutions.advantagedatabase.com>
X-Trace: 27 Apr 2006 07:58:19 -0700, 83.17.226.42
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!83.17.226.42
Xref: solutions.advantagedatabase.com Advantage.DelphidotNet:84
Article PK: 1108519

Hello
I have problem with Advantage and ASP .NET.

Timeout expired. The timeout period elapsed prior to obtaining a connection
from the pool. This may have occurred because all pooled connections were in
use and max pool size was reached.

ace32 - 7.10.0.15
Advantage.Data.Provider - 7.10.0.2
Database -Remote 7 (but i don't know exacly)
tested on Remote 8 and don't work too.


i always close connecection and FlushConnectionPool

i have exacly same project compiled on
ace32 8.0.0.4
advantage.Data.Provider 8.0.0.4 and works perfect.
Database - remote 8

What's going on ?

--
----------------------------------------------------
Rados³aw Wójtowicz
F.H.U.P ASCO
www.asco.com.pl


Mark Wilkins Posted on 2006-04-27 21:44:51.0Z
From: "Mark Wilkins" <tired@of.spam>
Newsgroups: Advantage.DelphidotNet
References: <4450cdfb@solutions.advantagedatabase.com>
Subject: Re: ASP .NET - Timeout expired
Date: Thu, 27 Apr 2006 15:44:51 -0600
Lines: 49
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 198.102.102.13
Message-ID: <44513a84@solutions.advantagedatabase.com>
X-Trace: 27 Apr 2006 15:41:24 -0700, 198.102.102.13
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.13
Xref: solutions.advantagedatabase.com Advantage.DelphidotNet:85
Article PK: 1108520

Hi,

The 7.10 provider does have a problem with the connection pool when
connections are disposed by the garbage collector. There is not currently a
service update available for that issue in 7.1. The problem was fixed 8.0.

There are a couple workarounds. If you are able to call the Close() method
on the connection object when you are finished, then it should avoid the
problem. Alternatively, if you cannot call the Close() method, it probably
makes sense to turn off connection pooling, since the pooling is not doing
anything useful if the garbage collector is closing the connections. You
can turn off the pooling with "max pool size=0" in the connection string.

Mark Wilkins
Advantage R&D

"Rados³aw Wójtowicz" <francja@elegancja> wrote in message
news:4450cdfb@solutions.advantagedatabase.com...
> Hello
> I have problem with Advantage and ASP .NET.
>
> Timeout expired. The timeout period elapsed prior to obtaining a
> connection from the pool. This may have occurred because all pooled
> connections were in use and max pool size was reached.
>
> ace32 - 7.10.0.15
> Advantage.Data.Provider - 7.10.0.2
> Database -Remote 7 (but i don't know exacly)
> tested on Remote 8 and don't work too.
>
>
> i always close connecection and FlushConnectionPool
>
> i have exacly same project compiled on
> ace32 8.0.0.4
> advantage.Data.Provider 8.0.0.4 and works perfect.
> Database - remote 8
>
> What's going on ?
>
> --
> ----------------------------------------------------
> Rados³aw Wójtowicz
> F.H.U.P ASCO
> www.asco.com.pl
>


Rados³aw Wójtowicz Posted on 2006-04-28 06:58:20.0Z
From: "Rados³aw Wójtowicz" <francja@elegancja>
Newsgroups: Advantage.DelphidotNet
References: <4450cdfb@solutions.advantagedatabase.com> <44513a84@solutions.advantagedatabase.com>
Subject: Re: ASP .NET - Timeout expired
Date: Fri, 28 Apr 2006 08:58:20 +0200
Lines: 79
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 83.17.226.42
Message-ID: <4451bc3e@solutions.advantagedatabase.com>
X-Trace: 28 Apr 2006 00:54:54 -0700, 83.17.226.42
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!83.17.226.42
Xref: solutions.advantagedatabase.com Advantage.DelphidotNet:86
Article PK: 1108522

I Always close connection and FlushConnectionPool. Is any chanse to use
Advantage.Data.Provider 8.0.0.4 with ace32.dll 7.10.0.15 ? or maybe database
7.1?

If i use Advantage.Data.Provider 8.0.0.4 I Have this error... somtimes not
always...

Unable to find an entry point named AdsIsConnectionAlive in DLL ace32.dll.
at AdvantageClientEngine.ACE.AdsIsConnectionAlive(UInt32 hConnect, UInt16&
pbConnectionIsAlive)

at
Advantage.Data.Provider.AdsConnectionPool.GetOpenPoolConnection(AdsConnectionStringHandler
handler, Int32 iConnectTimeout)

at Advantage.Data.Provider.AdsPoolManager.GetConnection(String
strConnectionString, AdsInternalConnection& internalConnection,
AdsConnectionPool& pool)

at Advantage.Data.Provider.AdsConnection.Open()




U¿ytkownik "Mark Wilkins" <tired@of.spam> napisa³ w wiadomo¶ci
news:44513a84@solutions.advantagedatabase.com...

> Hi,
>
> The 7.10 provider does have a problem with the connection pool when
> connections are disposed by the garbage collector. There is not currently
> a service update available for that issue in 7.1. The problem was fixed
> 8.0.
>
> There are a couple workarounds. If you are able to call the Close()
> method on the connection object when you are finished, then it should
> avoid the problem. Alternatively, if you cannot call the Close() method,
> it probably makes sense to turn off connection pooling, since the pooling
> is not doing anything useful if the garbage collector is closing the
> connections. You can turn off the pooling with "max pool size=0" in the
> connection string.
>
> Mark Wilkins
> Advantage R&D
>
>
> "Rados³aw Wójtowicz" <francja@elegancja> wrote in message
> news:4450cdfb@solutions.advantagedatabase.com...
>> Hello
>> I have problem with Advantage and ASP .NET.
>>
>> Timeout expired. The timeout period elapsed prior to obtaining a
>> connection from the pool. This may have occurred because all pooled
>> connections were in use and max pool size was reached.
>>
>> ace32 - 7.10.0.15
>> Advantage.Data.Provider - 7.10.0.2
>> Database -Remote 7 (but i don't know exacly)
>> tested on Remote 8 and don't work too.
>>
>>
>> i always close connecection and FlushConnectionPool
>>
>> i have exacly same project compiled on
>> ace32 8.0.0.4
>> advantage.Data.Provider 8.0.0.4 and works perfect.
>> Database - remote 8
>>
>> What's going on ?
>>
>> --
>> ----------------------------------------------------
>> Rados³aw Wójtowicz
>> F.H.U.P ASCO
>> www.asco.com.pl
>>
>
>


Mark Wilkins Posted on 2006-04-28 14:30:15.0Z
From: "Mark Wilkins" <tired@of.spam>
Newsgroups: Advantage.DelphidotNet
References: <4450cdfb@solutions.advantagedatabase.com> <44513a84@solutions.advantagedatabase.com> <4451bc3e@solutions.advantagedatabase.com>
Subject: Re: ASP .NET - Timeout expired
Date: Fri, 28 Apr 2006 08:30:15 -0600
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 198.102.102.13
Message-ID: <44522629@solutions.advantagedatabase.com>
X-Trace: 28 Apr 2006 08:26:49 -0700, 198.102.102.13
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.13
Xref: solutions.advantagedatabase.com Advantage.DelphidotNet:87
Article PK: 1108521

Hi,

It is not possible to use the 8.x provider with the 7.x ace32.dll.

If you can send a re-creation of the problem to advantage@extendsys.com, we
can investigate it.

Thanks,
Mark Wilkins
Advantage R&D

"Rados³aw Wójtowicz" <francja@elegancja> wrote in message
news:4451bc3e@solutions.advantagedatabase.com...
>I Always close connection and FlushConnectionPool. Is any chanse to use
>Advantage.Data.Provider 8.0.0.4 with ace32.dll 7.10.0.15 ? or maybe
>database 7.1?
>
> If i use Advantage.Data.Provider 8.0.0.4 I Have this error... somtimes not
> always...
>


Lance Schmidt Posted on 2006-04-28 14:58:42.0Z
From: "Lance Schmidt" <LanceSc@ExtendSys.com>
Newsgroups: Advantage.DelphidotNet
References: <4450cdfb@solutions.advantagedatabase.com> <44513a84@solutions.advantagedatabase.com> <4451bc3e@solutions.advantagedatabase.com>
Subject: Re: ASP .NET - Timeout expired
Date: Fri, 28 Apr 2006 08:58:42 -0600
Lines: 95
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 198.102.102.91
Message-ID: <44522cd3@solutions.advantagedatabase.com>
X-Trace: 28 Apr 2006 08:55:15 -0700, 198.102.102.91
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.91
Xref: solutions.advantagedatabase.com Advantage.DelphidotNet:88
Article PK: 1108524

Hello,

This error means that an incorrect version of ace32.dll is being loaded. In
this case it is the 7.10.0.15 version of ACE that is being loaded instead of
8.0.0.4. When you receive this error check where ACE is being loaded from
and either copy in a newer version to that location.

Best Regards,

Lance Schmidt
Advantage R&D

"Rados³aw Wójtowicz" <francja@elegancja> wrote in message
news:4451bc3e@solutions.advantagedatabase.com...
>I Always close connection and FlushConnectionPool. Is any chanse to use
>Advantage.Data.Provider 8.0.0.4 with ace32.dll 7.10.0.15 ? or maybe
>database 7.1?
>
> If i use Advantage.Data.Provider 8.0.0.4 I Have this error... somtimes not
> always...
>
> Unable to find an entry point named AdsIsConnectionAlive in DLL ace32.dll.
> at AdvantageClientEngine.ACE.AdsIsConnectionAlive(UInt32 hConnect, UInt16&
> pbConnectionIsAlive)
>
> at
> Advantage.Data.Provider.AdsConnectionPool.GetOpenPoolConnection(AdsConnectionStringHandler
> handler, Int32 iConnectTimeout)
>
> at Advantage.Data.Provider.AdsPoolManager.GetConnection(String
> strConnectionString, AdsInternalConnection& internalConnection,
> AdsConnectionPool& pool)
>
> at Advantage.Data.Provider.AdsConnection.Open()
>
>
>
>
> U¿ytkownik "Mark Wilkins" <tired@of.spam> napisa³ w wiadomo¶ci
> news:44513a84@solutions.advantagedatabase.com...
>> Hi,
>>
>> The 7.10 provider does have a problem with the connection pool when
>> connections are disposed by the garbage collector. There is not
>> currently a service update available for that issue in 7.1. The problem
>> was fixed 8.0.
>>
>> There are a couple workarounds. If you are able to call the Close()
>> method on the connection object when you are finished, then it should
>> avoid the problem. Alternatively, if you cannot call the Close() method,
>> it probably makes sense to turn off connection pooling, since the pooling
>> is not doing anything useful if the garbage collector is closing the
>> connections. You can turn off the pooling with "max pool size=0" in the
>> connection string.
>>
>> Mark Wilkins
>> Advantage R&D
>>
>>
>> "Rados³aw Wójtowicz" <francja@elegancja> wrote in message
>> news:4450cdfb@solutions.advantagedatabase.com...
>>> Hello
>>> I have problem with Advantage and ASP .NET.
>>>
>>> Timeout expired. The timeout period elapsed prior to obtaining a
>>> connection from the pool. This may have occurred because all pooled
>>> connections were in use and max pool size was reached.
>>>
>>> ace32 - 7.10.0.15
>>> Advantage.Data.Provider - 7.10.0.2
>>> Database -Remote 7 (but i don't know exacly)
>>> tested on Remote 8 and don't work too.
>>>
>>>
>>> i always close connecection and FlushConnectionPool
>>>
>>> i have exacly same project compiled on
>>> ace32 8.0.0.4
>>> advantage.Data.Provider 8.0.0.4 and works perfect.
>>> Database - remote 8
>>>
>>> What's going on ?
>>>
>>> --
>>> ----------------------------------------------------
>>> Rados³aw Wójtowicz
>>> F.H.U.P ASCO
>>> www.asco.com.pl
>>>
>>
>>
>
>