remoting error

[AVL]

Hi,
I'm getting the following message.when trying to connect to the server from
my client...

"No connection could be made as the server refused it".

Here is my serverside code..
TcpServerChanne l tcp1 = new TcpServerChanne l(49157);
ChannelServices .RegisterChanne l(tcp1);
RemotingConfigu ration.Register WellKnownServic eType(typeof(Re motableClass.Db Connect),"DbCon nect",WellKnown ObjectMode.Sing leCall);

Here is my client code...
TcpClientChanne l tcpClient = new TcpClientChanne l();
ChannelServices .RegisterChanne l(tcpClient);

RemotingConfigu ration.Register WellKnownClient Type(typeof(DbC onnect),"tcp://10.236.230.117: 49157/DbConnect");

Here is my remotable object...

public class DbConnect : MarshalByRefObj ect
{
public DataSet ExecuteQuery(st ring strQuery)
{
Console.Write(" Starting to execute " +
"the query...");
// Create a SqlCommand object
// to represent the query
sqlConn.Open();
SqlCommand sqlcmd =
sqlConn.CreateC ommand();
sqlcmd.Connecti on = sqlConn;
sqlcmd.CommandT ype = CommandType.Tex t;
sqlcmd.CommandT ext = strQuery;
// Create a SqlDataAdapter object
// to talk to the database
SqlDataAdapter sqlda = new SqlDataAdapter( );
sqlda.SelectCom mand = sqlcmd;
// Create a DataSet to hold the results
DataSet ds = new DataSet();
try
{
// Fill the DataSet
sqlda.Fill(ds, "Results");
}
catch (Exception ex)
{
Console.WriteLi ne(ex.Message,
"Error executing query");
}
Console.WriteLi ne("Done.");
return ds;

}}

Can anyone help me out.???????/ it's urgent......... ..

[Paul Glavich [MVP ASP.NET]]

Does the server have a firewall installed? ie. Is the port you are using
open?

--
- Paul Glavich
MVP ASP.NET
http://weblogs.asp.net/pglavich
ASPInsiders member - http://www.aspinsiders.com
"AVL" <AV*@discussion s.microsoft.com > wrote in message
news:59******** *************** ***********@mic rosoft.com...

Hi,
I'm getting the following message.when trying to connect to the server
from
my client...

"No connection could be made as the server refused it".

Here is my serverside code..
TcpServerChanne l tcp1 = new TcpServerChanne l(49157);
ChannelServices .RegisterChanne l(tcp1);
RemotingConfigu ration.Register WellKnownServic eType(typeof(Re motableClass.Db Connect),"DbCon nect",WellKnown ObjectMode.Sing leCall);

Here is my client code...
TcpClientChanne l tcpClient = new TcpClientChanne l();
ChannelServices .RegisterChanne l(tcpClient);

RemotingConfigu ration.Register WellKnownClient Type(typeof(DbC onnect),"tcp://10.236.230.117: 49157/DbConnect");

Here is my remotable object...

public class DbConnect : MarshalByRefObj ect
{
public DataSet ExecuteQuery(st ring strQuery)
{
Console.Write(" Starting to execute " +
"the query...");
// Create a SqlCommand object
// to represent the query
sqlConn.Open();
SqlCommand sqlcmd =
sqlConn.CreateC ommand();
sqlcmd.Connecti on = sqlConn;
sqlcmd.CommandT ype = CommandType.Tex t;
sqlcmd.CommandT ext = strQuery;
// Create a SqlDataAdapter object
// to talk to the database
SqlDataAdapter sqlda = new SqlDataAdapter( );
sqlda.SelectCom mand = sqlcmd;
// Create a DataSet to hold the results
DataSet ds = new DataSet();
try
{
// Fill the DataSet
sqlda.Fill(ds, "Results");
}
catch (Exception ex)
{
Console.WriteLi ne(ex.Message,
"Error executing query");
}
Console.WriteLi ne("Done.");
return ds;

}}

Can anyone help me out.???????/ it's urgent......... ..