1) No querys run perfectly, as do they in Access
2) At the very end, when i close my progress form and
want to return to the menu.
3) Yes on "every", 4 permenant users and tested on 6
more ...
As you can see the problem may not be in the ODBC but in
Access it self...
Thanx for your response, I hope you (or anybody else) can
help me in the end...
Regards
>-----Original Message-----
>1)Try one or more queries straight on the Oracle database
>using SQL PLUS or alike
>Does it take a long time?
>Has the database changed?
>
>2)where does it "hang"
>Place several breakpoint or aids to monitor the flow of
>the program
>3)Same problem on each pc?
>
>
>>-----Original Message-----
>>Hi all,
>>
>>I am at my wits end...
>>I have an application that had been running fine (even
in
>>XP) however the last week or so it is Freezing.
>>
>>In the taskbar it shows as "Responding" but no way....
>>
>>This is the setup:
>>The application does a bunch of ODBCs to an Oracle
>>database, 250 or so records in Access averaging about 3
>>ODBCs each.
>>I am connecting using:
>>Set con = wrkODBC.OpenConnection("ODBCConnection", , , _
>> "ODBC;DSN=" & DSN & _
>> ";UID=" & User & _
>> ";PWD=" & PW & _
>> ";SERVER=" & Server & _
>> ";")
>>
>>Then i am creating my query:
>>Set qry = con.CreateQueryDef("", mySQL)
>>Where mySQL contains a perfectly nice (but long) SQL
>>statement (select)
>>
>>Next, open the (DAO) recordset:
>>Set rst = qry.OpenRecordset
>>Then working a bit with this and 2 other recordsets.
>>
>>After all that is done, i do:
>>rst.Close
>>set rst = nothing
>>
>>And start the loop all over.... (without connecting
again
>>offcourse)
>>
>>Any wise people out there that can help me along?
>>Oh, one more thing... This app had been running
smoothly
>>in XP as well for atleast 3 months before this problem
>>occured.
>>
>>Greets & many thanks
>>
>>Erik
>>.
>>
>.
>
|
Similar Threads
