pooling = spMts

[rlevin]

I have created an active server object (com) that utilyzes TOracleSession's Mts pooling. Howevern when I register the dll on the web server machine and I try grabbing a session out of the pool I am getting the following error message;
"Initialization error Could not locate "C:\oracle\ora81\bin\oramts.dll".
I searched for this dll, but could not find it.
If anybody can help or make suggestions as to what needs to be done, I would greatly appreciate it. I am supposed to go to QA in 1 week.

Thank You,

 

[Marco Kalter]

Your Net8 installation is missing the Oracle Microsoft Transaction Server Integration DLL (oramts.dll). This is a separate installation option in the Oracle Installer.

------------------
Marco Kalter
Allround Automations

 

[rlevin]

Thank You. I have installed that and got it working.
I just created a com object which uses doa to access an oracle db. The component is loaded into com+. The main reason I chose to do this, is to utilyze MTS's ability to maintain session pooling. I have set the doa session pooling type = spMTS. After stress testing the application, I do not see the seesions remain connected to the data base for more than about 1 second.
Is there any type of configuration I can set to administer; 1) how many sessions should remain in the pool at a time? 2) how long each session should remain connected?
Any help on the topic would be greatly appreciated

 

[Marco Kalter]

Oracle's "Using Microsoft Transaction Server with Oracle" manual contains a "Tuning Oracle Service for MTS Performance" chapter that describes several client and server side settings that affect connection pool management.

------------------
Marco Kalter
Allround Automations

 

[rlevin]

I am having a hard time finding it. Can you send me a web address?

Thank You

 

[Marco Kalter]

http://otn.oracle.com/docs/tech/windows/ora_mts/oramts_doc816.pdf

If you can't download it, let me know and I will send it to you by e-mail.

------------------
Marco Kalter
Allround Automations