Hi

On some reasons we still use in one place of our module this code

IDataReader dr = DotNetNuke.Data.DataProvider.Instance().ExecuteSQL(Query);

where Query is our SQL-query. Until versions 4.3.7 and 4.4.0 all was ok. But from version 4.3.7 appears error:

Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

[SqlException (0x80131904): Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.]
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734851
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
   System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130
   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.SqlClient.SqlConnection.Open() +111
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +201
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText) +40
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +262
   CookDNN.DNN.Modules.UniversalList.Data.SqlDataProvider.GetTablesList() +94
   CookDNN.DNN.Modules.UniversalList.Business.ULController.GetTablesList() +35
   CookDNN.DNN.Modules.UniversalList.GetTables.DrawTables(String TableName) +57
   CookDNN.DNN.Modules.UniversalList.GetTables.DrawAction() +855
   CookDNN.DNN.Modules.UniversalList.GetTables.Page_Load(Object sender, EventArgs e) +28
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

Will be glad to any help!

Thanks a lot!

Cathal

Thank you very much for answer. Just read both articles. But i am using Win XP and tested on SQL 2000 and SQL Server 2005. Both have the same error.

How i try to replace Instance().ExecuteSQL(Query) to stored proc with EXEC. So who i confused, when i got error for module at all - no one SQL Method calls for both SQL 2000 or SQL 2005 :( Below is new error:

Error: UniversalList is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The type initializer for 'CookDNN.DNN.Modules.UniversalList.Data.DataProvider' threw an exception. ---> System.TypeInitializationException: The type initializer for 'CookDNN.DNN.Modules.UniversalList.Data.DataProvider' threw an exception. ---> System.ArgumentNullException: Value cannot be null. Parameter name: type at System.Activator.CreateInstance(Type type, Boolean nonPublic) at DotNetNuke.Framework.Reflection.CreateObject(String TypeName, String CacheKey, Boolean UseCache) at DotNetNuke.Framework.Reflection.CreateObject(String ObjectProviderType, String ObjectProviderName, String ObjectNamespace, String ObjectAssemblyName, Boolean UseCache) at DotNetNuke.Framework.Reflection.CreateObject(String ObjectProviderType, String ObjectNamespace, String ObjectAssemblyName) at CookDNN.DNN.Modules.UniversalList.Data.DataProvider.CreateProvider() at CookDNN.DNN.Modules.UniversalList.Data.DataProvider..cctor() --- End of inner exception stack trace --- at CookDNN.DNN.Modules.UniversalList.Data.DataProvider.Instance() at CookDNN.DNN.Modules.UniversalList.Business.ULFieldsController.GetULFieldList() at CookDNN.DNN.Modules.UniversalList.Business.ULFieldsController.GetULFieldList(Int32 intPortalID) at CookDNN.DNN.Modules.UniversalList.UniversalList.FillHostPath() at CookDNN.DNN.Modules.UniversalList.UniversalList.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Can be problem, that module was developed with VS 2003 for DNN 3.x and now converted for VS 2005 for DNN 4.x, but code not changed?

Thank you for all your help!

In your dataprovider, if you have code such as this:

Private Shared Sub CreateProvider()CType(Framework.Reflection.CreateObject("data", "UniversalList", "UniversalList.dll"), DataProvider)

change it to:

Private Shared Sub CreateProvider()CType(Framework.Reflection.CreateObject("data", "UniversalList", ""), DataProvider)