Hello!
Can i have two diferent websites on same database? I´m using same webhotell.
I have try to in the webconfig file to add dnnsite2 in the row like below: (I find that i can add dnnsite2 it in another forum)
<add name="SqlDataProvider" type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider" connectionStringName="SiteSqlServer" upgradeConnectionString="" providerPath="~\Providers\DataProviders\SqlDataProvider\" objectQualifier="dnnsite2" databaseOwner="dbo" />
But it still dont working, i just get error:
Could not find stored procedure 'dbo.dnnsite2_GetPortals'.
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.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.dnnsite2_GetPortals'.
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:
[SqlException: Could not find stored procedure 'dbo.dnnsite2_GetPortals'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +44
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership)
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText)
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues)
DotNetNuke.Data.SqlDataProvider.GetPortals() +47
DotNetNuke.Entities.Portals.PortalController.GetPortals() +16
DotNetNuke.Common.Global.CacheMappedDirectory() +36
DotNetNuke.Common.Global.Application_Start(Object Sender, EventArgs E) +324
What is wrong?
Please help me
Tommy