A97 vs AXO (2002)

[Erik van Opmeer]

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

 

[gandalf]

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?

 

[Erik van Opmeer]

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