I just switched from WH4L to Arvixe.com, and when they updated the connection string in my web.config file, everything in my website was fine except for the events module on my website. I lost all entries in my calendar, and when I tried to reenter an event, I get an error that Edit Event is unavailable. The techs at Arvixe can't seem to figure out what's wrong, and I don't have the expertise. Can someone help me with fixing this error, I think by helping me find the connection string I need to change? Thanks.

ModuleId: 521
ModuleDefId: 106
FriendlyName: Edit Event
ModuleControlSource: DesktopModules/Events/EditEvents.ascx
AssemblyVersion: 04.08.00
PortalID: 0
PortalName: Washington School PTO
UserID: 2
UserName: admin
ActiveTabID: 36
ActiveTabName: Home
RawURL: /Home/tabid/36/ctl/Edit/mid/521/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.washingtonpto.org/Home/tabid/36/Default.aspx
UserAgent: Mozilla/5.0 (iPad; U; CPU OS 3_2_1 like Mac OS X; en-us) AppleWebKit/531.21.10 (KHTML, like Gecko) Version/4.0.4 Mobile/7B405 Safari/531.21.10
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 2db975ae-5b3b-49c3-bf77-6512d6b96a1f
InnerException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.ProviderBase.DbConnectionPool.GetConnection
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Events.Data.SqlDataProvider.EventsCategoryList(Int32 PortalId) at DotNetNuke.Modules.Events.EventCategoryController.EventsCategoryList(Int32 PortalID) at DotNetNuke.Modules.Events.EditEvents.LoadCategory(Int32 Category) at DotNetNuke.Modules.Events.EditEvents.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:
Server Name: C15472-140440

DNN 4.08
Events 03.03.08

I know these are way out of date. If I can get this event module working again, then my next step will be to try to upgrade to a more current version of DNN and associated modules.

Thanks for any help you can give.

This is indeed old. The Events 03.03.08 was the version that motivated Roger en me to become (part of) the current Events project team, because is was so buggy... We have removed the need for a connection string to be in 2 places in the web.config somewhere around Events version 4.x
Be sure to make a back-up before you start upgrading.

---

Regards,
Ernst Peter



XCESS: DNN/Evoq specialist, zie www.xcess.nl

Events 7.0.1 - Released
Reports 6.1.0 - Released