The provider did not return a ProviderManifestToken string.

Hi

We downloaded Nop 2.3 with source code I installed it on workstation (server) and developing
both front end and Back end. We backed our databases up and placed onto another Sql Server. The Nop folder containing the source files was also transfered to the other machine. With the exact same source file.

We changed the connection string in Nop.Data/Settings.setting to correspond with the Sql server on
the other machine and went through the process of launching the solution by setting up the start up application Nop.Web and pressing F5. But we where hit with the following error. The provider did not return Provider Manifest Token String


Nop.Services\Schedule Task Services

/// <summary>
         /// Gets all tasks
         /// </summary>
         /// <returns>Tasks</returns>
         public virtual IList<ScheduleTask> GetAllTasks()
         {
             var query = _taskRepository.Table;
          query = query.OrderByDescending(t => t.Seconds);  

            var tasks = query.ToList();
             return tasks;
         }

Can anyone provide any information or help with specified problem


All help would be highly regarded

Richard

Can you provide the full error stack? Or it would be better if you could post the entire screenshot of error page

Hi

Sorry for the extremly late reply and I'm aware you are very busy...

We are moving the application from my local machine onto a testing server and setting my machine as a work station.
we want to port the application up through.

We Backed up the Nop.db and placed it onto a different SQL Server and changed the connection string in the Web.Config and the Nop.Data Setting's file. To match the approiate setting.

I also copied the source code file and placed it on to the local C drive on the AD server, on my workstation I connected to the Z network driver and have the access to the source code. I have Visual Studio on my local machine..

When I go to open the Sln file in Visual Studio from the Z network drive it will not launch and Visual Studio crashes but I can cancel.

When I double click the sln file I get the warning

You should only open projects from a trustworthy source.

The project file may have come from a location that isn't fully trusted and could course a secruity risk by executing custom build steps when opened in Visual Studio...

When I open it on the different server it comes up with this error. (Not all)

Message=Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
       Source=.Net SqlClient Data Provider
       ErrorCode=-2146232060
       Class=11
       LineNumber=0
       Number=-2
       Procedure=""
       Server=SHOP
       State=0
       StackTrace:

Is there somewhere I need to change the Server name from Shop to the server name that we moved to???

With this in mind I have had converstation's with my manager whom was having the same issues when we went through the process on his computer. We are just wondering if we are going through the right procedures or are there any parameters we are missing.

I do have the stack error's would it possible to send them to you in a PM??? If nessercary?

I hope this makes sense as I'm an absolute novice to Computer Science but I'm an extemly fast learner..

All help would be highly regarded

Kind regards

Richard.

Here is error stack trace it throws, I have highlighted in bold where I think the error is coming from, as we move dthe application to a different server. Is there work arounds so we don't need to reinstal as we have made a great deal of changes to the Entity Framework and the source code???

System.Data.ProviderIncompatibleException was unhandled by user code
  Message=The provider did not return a ProviderManifestToken string.
  Source=System.Data.Entity
  StackTrace:
       at System.Data.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection)
       at System.Data.Entity.ModelConfiguration.Utilities.DbConnectionExtensions.GetProviderInfo(DbConnection connection, DbProviderManifest& providerManifest)
       at System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection)
       at System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext)
       at System.Data.Entity.Internal.RetryLazy`2.GetValue(TInput input)
       at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
       at System.Data.Entity.Internal.InternalContext.Initialize()
       at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
       at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize()
       at System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext()
       at System.Data.Entity.Infrastructure.DbQuery`1.System.Linq.IQueryable.get_Provider()
       at System.Linq.Queryable.OrderByDescending[TSource,TKey](IQueryable`1 source, Expression`1 keySelector)
       at Nop.Services.Tasks.ScheduleTaskService.GetAllTasks() in C:\Nop 1\Libraries\Nop.Services\Tasks\ScheduleTaskService.cs:line 66
       at Nop.Services.Tasks.TaskManager.Initialize() in C:\Nop 1\Libraries\Nop.Services\Tasks\TaskManager.cs:line 41
       at Nop.Web.MvcApplication.Application_Start() in C:\Nop 1\Presentation\Nop.Web\Global.asax.cs:line 61
  InnerException: System.Data.SqlClient.SqlException
       Message=Login failed for user 'CONCORDCCC\Admin'.
       Source=.Net SqlClient Data Provider
       ErrorCode=-2146232060
       Class=14
       LineNumber=65536
       Number=18456
       Procedure=""
       Server=SHOP
       State=1
       StackTrace:
            at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
            at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
            at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
            at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
            at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
            at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
            at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
            at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
            at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
            at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
            at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
            at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
            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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
            at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
            at System.Data.SqlClient.SqlProviderServices.GetDbProviderManifestToken(DbConnection connection)
            at System.Data.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection)
       InnerException:

Did you ever resolve this?

Yesterday I set the Visual Studio project up, pressed F5 and I was away.

Today I tried to run it again, I first got:

Access to the path 'C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\a450bf71\e95f9f89\Nop.Plugin.DiscountRules.BillingCountry.dll' is denied.

So to resolve that I deleted the folders under C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root (which it permitted me to, including the a450bf71 folder).

I then tried to debug again, and received:

ProviderIncompatibleException was unhandled by user code

System.Data.ProviderIncompatibleException was unhandled by user code
  Message=The provider did not return a ProviderManifestToken string.
  Source=System.Data.Entity
  StackTrace:
       at System.Data.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection)
       at System.Data.Entity.ModelConfiguration.Utilities.DbConnectionExtensions.GetProviderInfo(DbConnection connection, DbProviderManifest& providerManifest)
       at System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection)
       at System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext)
       at System.Data.Entity.Internal.RetryLazy`2.GetValue(TInput input)
       at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
       at System.Data.Entity.Internal.InternalContext.Initialize()
       at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
       at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize()
       at System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext()
       at System.Data.Entity.Infrastructure.DbQuery`1.System.Linq.IQueryable.get_Provider()
       at System.Linq.Queryable.OrderByDescending[TSource,TKey](IQueryable`1 source, Expression`1 keySelector)
       at Nop.Services.Tasks.ScheduleTaskService.GetAllTasks() in D:\Projects\WebtechyWebsite\WebtechyPCShop\Libraries\Nop.Services\Tasks\ScheduleTaskService.cs:line 63
       at Nop.Services.Tasks.TaskManager.Initialize() in D:\Projects\WebtechyWebsite\WebtechyPCShop\Libraries\Nop.Services\Tasks\TaskManager.cs:line 40
       at Nop.Web.MvcApplication.Application_Start() in D:\Projects\WebtechyWebsite\WebtechyPCShop\Presentation\Webtechy.Nop.Web\Global.asax.cs:line 63
  InnerException: System.Data.SqlClient.SqlException
       Message=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)
       Source=.Net SqlClient Data Provider
       ErrorCode=-2146232060
       Class=20
       LineNumber=0
       Number=-1
       Server=""
       State=0
       StackTrace:
            at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
            at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
            at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
            at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
            at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
            at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
            at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
            at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
            at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
            at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
            at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
            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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
            at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
            at System.Data.SqlClient.SqlProviderServices.GetDbProviderManifestToken(DbConnection connection)
            at System.Data.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection)
       InnerException:

Throw on line 63 of ScheduleTaskService.cs which is:

query = query.OrderByDescending(t => t.Seconds);

Would attach an image if I could ...

Regards,

Ben