MTS Errror 1002: Failure to Create Dispen

[rpynor]

I am getting an error when i make a connection to the database: MTS Error 1002: Failure to create dispen.

This error does not occur all the time, it appears for the first few connection attempts after leaving the COM+ application running overnight. Is it possible that the Oracle server is somehow disconnecting / invalidating connections in the pool on the client machine, and when we try to re-use these connections, this error is raised?

Is there an MTS / DOA setting we need to use to overcome this problem

Thanks

 

[Marco Kalter]

I'm not aware of this restriction. One would expect that Oracle can handle this connection pool in a proper way.

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

 

[rpynor]

I have also noticed that i get this MTS error when an Invalid Username or password is passed to the session..The following code generates the same exception:

procedure TForm1.BitBtn1Click(Sender: TObject);
var
lSess : TOracleSession;
begin
lSess:= TOracleSession.Create(self);
lSess.Pooling := spMTS;

lSess.LogonUsername := 'myUserName';
lSess.LogonPassword := 'anInavlidPassword';
lSess.LogonDatabase := 'database';
lSess.Connected := true;
end;

Is it possible that there is a configuration issue with Oracle on our machine? We are using an Oracle 9i Server.

Thanks