Help - at wits end :(

[Bernet, Eytan]

I have more info I can share offline if you need it. Hit my email.
Eytan


On 7/9/07 2:40 PM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:

> Hi Eytan,
> 
> Thanks so much for the clarification and code example.
> 
>      Barry G. Sumpter
> 
> 
> -----Original Message-----
> From: valentina-bounces at lists.macserve.net
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of Bernet, Eytan
> Sent: Tuesday, 10 July 2007 7:25 AM
> To: Valentina Developers
> Subject: Re: Help - at wits end :(
> 
> I have a timer that every 30 seconds does the following:
> 
>   if gConnection.IsConnected= true then
>     
>     tQueryString = "SELECT StudentID FROM Student WHERE StudentID = '1'"
>         vres = gDB.SqlQuery( tQueryString )
>   end if
> 
> 
> If I didn't, gConnection would close, and while reopening it would not
> generate any errors, I would run into Problems. I had no such problem when I
> closed and opened the connection manually, but then I ran into other
> problems.
> 
> Eytan
> 
> On 7/9/07 1:57 PM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:
> 
>> Brilliant!
>> 
>> Could you expand on "tickle"?
>> i.e. close and open or Select query?
>> 
>> Thanks,
>>     Barry G. Sumpter
>> 
>> 
>> -----Original Message-----
>> From: valentina-bounces at lists.macserve.net
>> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of Bernet, Eytan
>> Sent: Tuesday, 10 July 2007 6:27 AM
>> To: Valentina Developers
>> Subject: Re: Help - at wits end :(
>> 
>> Trick proposed by my co-worker....
>> 
>> I have set up a 30 second times in Director, and I just "tickle" the
>> database with a query once every 30 seconds. Seems to have resolved the
>> problem.
>> Eytan
>> 
>> 
>> 
>> On 7/9/07 12:03 PM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:
>> 
>>> Hi Eytan,
>>> 
>>> I have the same type of issues which may be completely unrelated.
>>> 
>>> I've posted warning reminders to myself on:
>>> http://www.barrysumter.com
>>> 
>>> I would be very interested to know if find any of the warnings remotely
>>> relevant.
>>> 
>>> Hth
>>>      Barry G. Sumpter
>>> 
>>> -----Original Message-----
>>> From: valentina-bounces at lists.macserve.net
>>> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of Bernet, Eytan
>>> Sent: Tuesday, 10 July 2007 4:26 AM
>>> To: Valentina Developers
>>> Subject: Help - at wits end :(
>>> 
>>> I have an application that I am supposed to ship already. All the coding
>> is
>>> done, and everything seemed to work great.
>>> 
>>> I am using the V4MD Xtra, version 2.5.10
>>> 
>>> I can get info from the database all I want, and everything works. I can
>> let
>>> the program sit idle, click on a student in my application, and have
>>> database queries work fine.
>>> I can assign an activity to the students, creating a new record, and
>>> everything works fine (again, all this using SQL queries)
>>> I can then Querry the database the same way, and everything works fine.
>>> 
>>> However, if I let my program sit idle AFTER modifying the database, for
>> more
>>> than a minute or so, the application quits (either my app is I create a
>>> runtime, or the director environment). It reports that the connection is
>> no
>>> longer open, I open it, and then havoc ensues. Note I am not CLOSING the
>>> connection, and yet it closes.
>>> 
>>> Has anyone else seen this? Does anyone else know how to solve this? I am
>>> about to add a timer to director that if no database queries are done for
>> 59
>>> seconds, I close the database, destroy the Valentina Xtra, and recreate
>> it.
>>> This is driving me crazy, I have been tackling it for a week now, with no
>>> solution in site.
>>> 
>>> 
>>> Please please please help
>>> 
>>> Eytan Bernet
>>> McGraw-Hill Education
>>> _______________________________________________
>>> Valentina mailing list
>>> Valentina at lists.macserve.net
>>> http://lists.macserve.net/mailman/listinfo/valentina
>>> 
>>> _______________________________________________
>>> Valentina mailing list
>>> Valentina at lists.macserve.net
>>> http://lists.macserve.net/mailman/listinfo/valentina
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>> 
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina