Got an error when trying to upgrade from 4.5.5 to 4.6.2. I looked at the source and it looks like it can't find the uid=xxxxxxxx in my connection string so the index is out of bounds? Any ideas? My site is out of commission.... BTW, before you all ask, my connection string is a valid SQL Server 2005 connection string... I also posted the code of the routine it's blowing up in... It would never get this far if it couldn't read in the web.config would it? (i.e. a permissions issue)?
Server Error in '/' Application.
Index was outside the bounds of the array.
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.IndexOutOfRangeException: Index was outside the bounds of the array.
Source Error:
Line 171: Response.Write("<h2>Upgrade Status Report</h2>")
Line 172: Response.Flush()
Line 173: Services.Upgrade.Upgrade.UpgradeDNN(strProviderPath, strDatabaseVersion.Replace(".", ""))
Line 174:
Line 175: 'Install Resources
|
Source File: E:\kunden\homepages\44\d178323825\Install\Install.aspx.vb Line: 173
Stack Trace:
[IndexOutOfRangeException: Index was outside the bounds of the array.]
DotNetNuke.Data.SqlDataProvider.GetConnectionStringUserID() +676
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) +683
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script) +6
DotNetNuke.Services.Upgrade.Upgrade.ExecuteScript(String strScriptFile, String version, Boolean writeFeedback) +113
DotNetNuke.Services.Upgrade.Upgrade.UpgradeVersion(String strScriptFile, Boolean writeFeedback) +165
DotNetNuke.Services.Upgrade.Upgrade.UpgradeDNN(String strProviderPath, String strDatabaseVersion) +380
DotNetNuke.Services.Install.Install.UpgradeApplication() in E:\kunden\homepages\44\d178323825\Install\Install.aspx.vb:173
DotNetNuke.Services.Install.Install.Page_Load(Object sender, EventArgs e) in E:\kunden\homepages\44\d178323825\Install\Install.aspx.vb:346
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
|
Private Function GetConnectionStringUserID() As String
Dim DBUser As String = "public"
Dim ConnSettings() As String
Dim ConnSetting() As String
Dim s As String
ConnSettings = ConnectionString.Split(";"c)
'If connection string does not use integrated security, then get user id.
If ConnectionString.ToUpper().Contains("USER ID") Or ConnectionString.ToUpper().Contains("UID") Or ConnectionString.ToUpper().Contains("USER") Then
ConnSettings = ConnectionString.Split(";"c)
ConnSetting = s.Split("="c)
For Each s In ConnSettingsIf "USER ID|UID|USER".Contains(ConnSetting(0).Trim.ToUpper()) Then
DBUser = ConnSetting(1).Trim()
End If
Next
End If
Return DBUserEnd Function