query handles / connection objects .. (OpenInsight Specific)
At 06 OCT 1998 10:56:56AM bwk@akribi.se wrote:
Hi .. I've found a problem .. don't really know if it's an
error .. or ..
anyway .. I'm running OI3.2 (still :) ..) under WinNT (the
problem is the same under Win95), and MSSQL 6.5 or Oracle 7.3
on the other end of the network.
I access the database through a BFS .. (worx fine..) all tables
are using the same QH.
However .. to speed up some reports I did the following:
1. Create a new QH (qh2)
2. The main report query is executed over this QH (qh2)
3. Smaller queries (eg. records from files) are read over the
ordinary QH (qh1)
4. When everything is ready qh2 is closed down
This works great when connected to an Oracle database (over
ODBC …), but .. when using MSSQL (native) .. no results
are returned from the ordinary QH (qh1) during the operation.
After qh2 is closed down however, qh1 works fine again ..
any1 knowing 'bout a solution to this one ?
why does it work differently depending on the connection ?
is the only way to solve this to create a second XO for MSSQL
native ??
?
/bengt
At 06 OCT 1998 04:20PM Cameron Revelation wrote:
Bengt,
If you are using the direct MSSQL connection, you must open a second connection. The DBLIB API supports only one active result set at a time per connection. The trade-off is that connections are cheap (50k or so on the server).
With Oracle, keep it as you have it, since OCI has a big price (300k) per connection but a small price per query.
Cameron Purdy
Revelation Software