Hello,

When i try to install the link module, i get this sql error:

Info	Executing 03.03.00.SqlDataProvider
StartJob	Start Sql execution: 03.03.00.SqlDataProvider file
Failure	SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid object name 'dbadmin.sysobjects'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbadmin.sysobjects where id = object_id(N'dbadmin.[GetLink]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbadmin.GetLink System.Data.SqlClient.SqlException: Invalid object name 'dbadmin.sysobjects'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbadmin.sysobjects where id = object_id(N'dbadmin.[GetLinks]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbadmin.GetLinks System.Data.SqlClient.SqlException: There is already an object named 'GetLink' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE procedure dbadmin.GetLink @ItemId int, @ModuleId int as select Links.ItemId, Links.ModuleId, Links.Title, Links.URL, Links.ViewOrder, Links.Description, Links.CreatedByUser, Links.CreatedDate, UrlTracking.TrackClicks, UrlTracking.NewWindow from Links left outer join UrlTracking on Links.URL = UrlTracking.Url and UrlTracking.ModuleId = @ModuleID where Links.ItemId = @ItemId and Links.ModuleId = @ModuleId System.Data.SqlClient.SqlException: There is already an object named 'GetLinks' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE procedure dbadmin.GetLinks @ModuleId int as select Links.ItemId, Links.ModuleId, Links.CreatedByUser, Links.CreatedDate, Links.Title, Links.URL, Links.ViewOrder, Links.Description, UrlTracking.TrackClicks, UrlTracking.NewWindow from Links left outer join UrlTracking on Links.URL = UrlTracking.Url and UrlTracking.ModuleId = @ModuleID where Links.ModuleId = @ModuleId order by Links.ViewOrder, Links.Title
EndJob	End Sql execution: 03.03.00.SqlDataProvider file

I can install and use other modules, so, my DB is configured well (i think).

Anyone an idea?

Thomas

Hi Leupold,

The database owner is: dbadmin
the objectqualifier is: "" empty.

Should i change this?
thx


Thomas

dear Leupold,

Is it possible, if i download the source package and change the dbo to dbadmin? in the sqldataprovider?

Thx


Thomas