Remoting Using TcpChannel (Urgent)

[Ahmet AKGUN]

Hi;

I am trying to make a server that handles db connection pool.
Clients use TcpChannel to make a call to this server and get one
database connection (OleDbConnectio n) from pool.

But when I try to connect to server using TcpChannel,
I get this message "Only one usage of each socket address (protocol/network
adress /port)"
is normally permitted.
But then my call to GetDbConnFromPo ol succees and I get connection from
server.
Why I get the message above ?

Below you can see my server and client codes
Server code
using System;

using System.Runtime. Remoting;

using System.Runtime. Remoting.Channe ls;

using System.Runtime. Remoting.Channe ls.Tcp;

using System.Data.Ole Db;

using System.Windows. Forms;

namespace PoolManager

{

public class PoolServer : MarshalByRefObj ect

{

private int iConnCnt;

public PoolServer()

{

try

{

TcpChannel channel = new TcpChannel(5000 );

ChannelServices .RegisterChanne l(channel);

RemotingConfigu ration.Register WellKnownServic eType(typeof(Po olServer),

"MilenasDbPool" ,

WellKnownObject Mode.Singleton

);

}

catch(System.Ex ception eSysExc)

{

MessageBox.Show (eSysExc.Messag e);

}

}
public OleDbConnection NewConnFromPool ()

{

iConnCnt++;

OleDbConnection dbNewConn;

dbNewConn = new OleDbConnection ("Provider=MSDA ORA.1;Password= pwd;User
ID=usr;Data Source=DATABASE ;Pooling=true") ;

return dbNewConn;

}
public void DisposeConn(Ole DbConnection dbConn)

{

dbConn.Dispose( );

iConnCnt--;

}

}

}

////////////////////////////////////////////////////////////////////////////
///////////////////////

////////////////////////////////////////////////////////////////////////////
///////////////////////

My Client Code is Below

public class PoolClient

{

public PoolClient(stri ng host,string port)

{

try

{

string strDest = "tcp://" + host + ":" + port + "/MilenasDbPool";

TcpChannel chn = new TcpChannel();

ChannelServices .RegisterChanne l(chn);

PoolServer plMan = (PoolServer)Act ivator.GetObjec t(

typeof(PoolServ er),strDest);

OleDbConnection refConnFromPool = plMan.NewConnFr omPool();

MessageBox.Show (refConnFromPoo l.ConnectionStr ing);

refConnFromPool .Open();

}

catch(System.Ex ception eSysExc)

{

MessageBox.Show (eSysExc.Messag e);

}

}

}

Helps will be appreciated..

Ahmet.

[Scott C. Wagner]

You're registering the remoting channel in the constructor of the object
that is being created. Therefore, you're attempting to register the
channel every time a client requests the object be created.

HTH,
Scott Wagner
Seisint, Inc.

Ahmet AKGUN wrote:

Hi;

I am trying to make a server that handles db connection pool.
Clients use TcpChannel to make a call to this server and get one
database connection (OleDbConnectio n) from pool.

But when I try to connect to server using TcpChannel,
I get this message "Only one usage of each socket address (protocol/network
adress /port)"
is normally permitted.
But then my call to GetDbConnFromPo ol succees and I get connection from
server.
Why I get the message above ?

Below you can see my server and client codes
Server code
using System;

using System.Runtime. Remoting;

using System.Runtime. Remoting.Channe ls;

using System.Runtime. Remoting.Channe ls.Tcp;

using System.Data.Ole Db;

using System.Windows. Forms;

namespace PoolManager

{

public class PoolServer : MarshalByRefObj ect

{

private int iConnCnt;

public PoolServer()

{

try

{

TcpChannel channel = new TcpChannel(5000 );

ChannelService s.RegisterChann el(channel);

RemotingConfig uration.Registe rWellKnownServi ceType(typeof(P oolServer),

"MilenasDbPool ",

WellKnownObjec tMode.Singleton

);

}

catch(System.E xception eSysExc)

{

MessageBox.Sho w(eSysExc.Messa ge);

}

}
public OleDbConnection NewConnFromPool ()

{

iConnCnt++;

OleDbConnectio n dbNewConn;

dbNewConn = new OleDbConnection ("Provider=MSDA ORA.1;Password= pwd;User
ID=usr;Data Source=DATABASE ;Pooling=true") ;

return dbNewConn;

}
public void DisposeConn(Ole DbConnection dbConn)

{

dbConn.Dispose ();

iConnCnt--;

}

}

}

////////////////////////////////////////////////////////////////////////////
///////////////////////

////////////////////////////////////////////////////////////////////////////
///////////////////////

My Client Code is Below

public class PoolClient

{

public PoolClient(stri ng host,string port)

{

try

{

string strDest = "tcp://" + host + ":" + port + "/MilenasDbPool";

TcpChannel chn = new TcpChannel();

ChannelService s.RegisterChann el(chn);

PoolServer plMan = (PoolServer)Act ivator.GetObjec t(

typeof(PoolSer ver),strDest);

OleDbConnectio n refConnFromPool = plMan.NewConnFr omPool();

MessageBox.Sho w(refConnFromPo ol.ConnectionSt ring);

refConnFromPoo l.Open();

}

catch(System.E xception eSysExc)

{

MessageBox.Sho w(eSysExc.Messa ge);

}

}

}

Helps will be appreciated..

Ahmet.

[Ahmet AKGUN]

that solved the problem.
thanks.
"Scott C. Wagner" <sw*******@SPAM seisint.com> wrote in message
news:3F******** ******@SPAMseis int.com...

You're registering the remoting channel in the constructor of the object
that is being created. Therefore, you're attempting to register the
channel every time a client requests the object be created.

HTH,
Scott Wagner
Seisint, Inc.

Ahmet AKGUN wrote:

Hi;

I am trying to make a server that handles db connection pool.
Clients use TcpChannel to make a call to this server and get one
database connection (OleDbConnectio n) from pool.

But when I try to connect to server using TcpChannel,
I get this message "Only one usage of each socket address (protocol/networkadress /port)"
is normally permitted.
But then my call to GetDbConnFromPo ol succees and I get connection from
server.
Why I get the message above ?

Below you can see my server and client codes
Server code
using System;

using System.Runtime. Remoting;

using System.Runtime. Remoting.Channe ls;

using System.Runtime. Remoting.Channe ls.Tcp;

using System.Data.Ole Db;

using System.Windows. Forms;

namespace PoolManager

{

public class PoolServer : MarshalByRefObj ect

{

private int iConnCnt;

public PoolServer()

{

try

{

TcpChannel channel = new TcpChannel(5000 );

ChannelService s.RegisterChann el(channel);

RemotingConfig uration.Registe rWellKnownServi ceType(typeof(P oolServer),

"MilenasDbPool ",

WellKnownObjec tMode.Singleton

);

}

catch(System.E xception eSysExc)

{

MessageBox.Sho w(eSysExc.Messa ge);

}

}
public OleDbConnection NewConnFromPool ()

{

iConnCnt++;

OleDbConnectio n dbNewConn;

dbNewConn = new OleDbConnection ("Provider=MSDA ORA.1;Password= pwd;User
ID=usr;Data Source=DATABASE ;Pooling=true") ;

return dbNewConn;

}
public void DisposeConn(Ole DbConnection dbConn)

{

dbConn.Dispose ();

iConnCnt--;

}

}

}

///////////////////////////////////////////////////////////////////////////

/

///////////////////////

///////////////////////////////////////////////////////////////////////////

/

///////////////////////

My Client Code is Below

public class PoolClient

{

public PoolClient(stri ng host,string port)

{

try

{

string strDest = "tcp://" + host + ":" + port + "/MilenasDbPool";

TcpChannel chn = new TcpChannel();

ChannelService s.RegisterChann el(chn);

PoolServer plMan = (PoolServer)Act ivator.GetObjec t(

typeof(PoolSer ver),strDest);

OleDbConnectio n refConnFromPool = plMan.NewConnFr omPool();

MessageBox.Sho w(refConnFromPo ol.ConnectionSt ring);

refConnFromPoo l.Open();

}

catch(System.E xception eSysExc)

{

MessageBox.Sho w(eSysExc.Messa ge);

}

}

}

Helps will be appreciated..

Ahmet.