Our network nazi doesn't want us running a webserver on the server that
has a connection to the campus database so we created a remote object
that runs as a windows service. The windows service runs on the server
with a connection to the campus database and we make calls to it. My
question is, how best to connect to this object via asp.net, in an aspx
page?. The example I had used a console ap to connect and that works,
but we want to connect to the remote object from an asp.net web page.
Here is the remote object
using System;
using System.Data;
using System.Data.Sql Client;
using System.Diagnost ics;
namespace RemoteObject
{
/// <summary>
/// Summary description for Class1.
/// </summary>
public class Relay : MarshalByRefObj ect
{
private SqlConnection mySqlConn = new SqlConnection(" Network
Library=DBMSSOC N;Data Source=server;I nitial Catalog=proddb; User
ID=user;Passwor d=password;");
private SqlCommand mySqlComm = new SqlCommand();
public Relay()
{
//
// TODO: Add constructor logic here
//
}
public String GetTestString(S tring str)
{
return str;
}
public DataSet GetDataSet(Stri ng strSqlQry)
{
DataSet myDS = new DataSet();
SqlDataAdapter myDA = new SqlDataAdapter( strSqlQry,
mySqlConn);
myDA.Fill(myDS) ;
myDA.Dispose();
mySqlConn.Close ();
return myDS;
}
public SqlDataReader GetDataReader(S tring strSqlQry)
{
mySqlComm.Comma ndText = strSqlQry;
mySqlComm.Conne ction = mySqlConn;
mySqlConn.Open( );
SqlDataReader myDR = mySqlComm.Execu teReader
(CommandBehavio r.CloseConnecti on);
return myDR;
}
}
}
And the config file for the windows service looks like
<configuratio n>
<system.runtime .remoting>
<application name="RemoteHos tService">
<service>
<wellknown type="RemoteObj ect.Relay, RemoteObject"
objectUri="Remo teObject.Relay"
mode="Singleton " />
</service>
<channels>
<channel ref="http" port="8085">
<serverProvider s>
<formatter ref="soap" />
</serverProviders >
</channel>
</channels>
</application>
</system.runtime. remoting>
</configuration>
And here is a working example of the console ap that can connect
remotely:
using System;
using System.Runtime. Remoting.Channe ls;
using System.Runtime. Remoting.Channe ls.Http;
using RemoteObject;
namespace RemotingClient
{
/// <summary>
/// Summary description for Class1.
/// </summary>
class RemoteClient
{
/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main(string[] args)
{
//
// TODO: Add code to start application here
//
HttpChannel chan = new HttpChannel();
ChannelServices .RegisterChanne l(chan);
Relay r = (Relay)Activato r.GetObject(
typeof(RemoteOb ject.Relay),
"http://server:8085/RemoteObject.Re lay");
if (r == null)
System.Console. WriteLine("Coul d not locate
server");
else
{
System.Data.Sql Client.SqlDataR eader _sqlReader;
_sqlReader = r.GetDataReader ("select [Name] from
dbo.CMN_Terms WHERE CMN_TermsID=1") ;
_sqlReader.Read ();
Console.WriteLi ne(_sqlReader["Name"].ToString
());
}
}
}
}
This works, but we've been having trouble connecting to the remote
object 'relay' from an aspx page which is what we need. How does one
connect from an aspx page to a remote object?
