Hello,

I was just wondering if on your server you have setup a System DSN that is named "support"?

The following is my sessionState info. I noticed that mine had a port number of 42424. Could there be something there? Seeing your version of this maybe you don't need the DSN on the server???

<sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;user id=sa;password=" cookieless="false" timeout="20"/>

Good luck!

>So, i've completed my MM asp.net app and deployed it to our web host. All is good, except accessing my sql data via my MM custom data access classes.
>
>I created custom data access classes following the steps in the MM Dev Guide. These worked great in development, accessing my local sql server. However, when i attempt to load a 'live' web page with databound MM controls i get the following error:
>
>---------------------------------------------
>Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
>
>Stack Trace:
>[NullReferenceException: Object reference not set to an instance of an object.]
> OakLeaf.MM.Main.mmAppBase.get_DatabaseMgr()
> OakLeaf.MM.Main.Business.mmBusinessObject.GetDataAccessObject(String databaseKey)
> OakLeaf.MM.Main.Business.mmBusinessObject.GetDataAccessObject()
> GLBRI.SupportWebsite.Business.Documents.GetAllDocumentsWithCatType() +12
> GLBRI.SupportWebsite.Admin.AdminDocuments.Page_Load(Object sender, EventArgs e) +225
> System.Web.UI.Control.OnLoad(EventArgs e) +67
> System.Web.UI.Control.LoadRecursive() +35
> System.Web.UI.Control.LoadRecursive() +98
> System.Web.UI.Control.LoadRecursive() +98
> System.Web.UI.Page.ProcessRequestMain() +750
>--------------------------------------------------------
>
>Here are my connection settings from web.config:
>-------------------------------------------------------
>sessionState mode="InProc" stateConnectionString="tcpip=216.250.116.39" sqlConnectionString="Provider=SQLOLEDB.1;User ID=glbri;Password=cranberry;Initial Catalog=support;Data Source=216.250.116.39" cookieless="false" timeout="20"
>
> databases
> add key="Support\Connection" value="server=216.250.116.39;uid=glbri;pwd=cranberry;database=support;"
> add key="Support\DataAccessClass" value="DataAccessSql"
> databases
>--------------------------------------------------------
>
>Any advice would be greatly apprecited. Thanks.
>nat