First - Please forgive my ignorance, I am very new to web programming with .NET 2.0. In fact I never wrote any applications with 1.1!

So here is my question/issue:
My site is written in .NET 2.0. It has the simple function of quering a database based on the URL that a user is comming in from. So what we have in our DNS server is a listing of URL's all redirecting to one location. My code works fine as long as the web client has .NET 2.0 Framework installed on the machine. So for MACs and Unix machines it won't work, or Windows PC's without .NET 2.0 Framework.

So therefore since .NET code is supposed to be independant of the client, I am sure there is an issue with my code.

Here is my code:

protected void Page_Load(object sender, EventArgs e)
{
  if (!IsPostBack)
   (
     String URL = Request.UrlRefferrer.Host.ToString();
     SqlConnection Conn = new SqlConnection(ConfigurationManager.AppSettings.Get ("DBConnection"));
     SqlCommand Cmd = new SqlCommand();
     Cmd.CommandType = CommandType.Text;
     Conn.Open();
     Cmd.Connection = Conn;
     Cmd.CommandText = "Select * from Profile where WebDNS = '" + URL +"'";

SqlDataReader Reader = Cmd.ExecuteReader();

....then the code fills out the form.

The errors I am getting back are the standard runtime errors with the text, "An application error has occured on the server, change the custom errors..."


Since this is my first .NET 2.0 website outside of book learning, I am lost. Any insight would be helpful.

Thanks,
Joe

in your web.config change the Custom errors mode property to off. (In visual studio, double click the web.config and about 3/4ths of the way down the page you will see the custom errors property, flip it to off) This way you can tell us the actual error.

And no, the host machine of a web client does not need the runtime to run your apps.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Thanks - I have done enough support that I was sure I knew that much about .NET.

Here is the actual error-
Object reference not set to an instance of an object.

 Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.]
   _Default.Page_Load(Object sender, EventArgs e) +39
   System.Web.Util.CalliHelper.EventArgFunctionCaller (IntPtr fp, Object o, Object t, EventArgs e) +15
   System.Web.Util.CalliEventHandlerDelegateProxy.Cal lback(Object sender, EventArgs e) +34
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

hey there.. do you upload the web.config file to the server too?? maybe the stringconnection is null??

looks like there is an object that is null..

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========