Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

DotNetNuke Marketplace
  Ads  
 


  Sponsors  

Meet Our Sponsors

FCKeditor Project
Salaro -- Skins and more
OnyakTech
CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Reports Module ...  Missing {databaseOwner} Statements in all SqlDataProviders
Previous Previous
 
Next Next
New Post 5/27/2007 8:03 PM
User is offline Matthias Schlomann
1507 posts
www.taunusstein.org
5th Ranked








Missing {databaseOwner} Statements in all SqlDataProviders 

In the new Version of Reports Module 04.05.02 and before there are missing the most {databaseOwner} statements.  so this Module is not funktunaly for users with other databaseOwner then 'dbo'.

Please make an update and set the correct {databaseOwner} statements on all calls of a table in the spocs.

Thanks

Matthias


Regards
Matthias
www.moonlightradio.net
Chat with me via MSN
 
New Post 5/27/2007 11:15 PM
User is offline Andrew Nurse
366 posts
8th Ranked






Re: Missing {databaseOwner} Statements in all SqlDataProviders 

You are correct that DotNetNuke is designed to allow database objects to be part of schemas other than 'dbo', but I do believe that DotNetNuke requires that if a different schema (databaseOwner) is used, that schema must be the default for the user specified in your connection string.

So while it would be prudent to add the '{databaseOwner}' token to the SQL statements in the upgrade script files, it should not be necessary, since SQL Server will by default use the default schema specified for a user. Therefore, to fix your issue, you should ensure that the user you use in the connection string (in web.config) to allow DotNetNuke to access the database has the correct default schema specified.

If you cannot change the default schema you will have to either wait until the next version, when this token is included in the scripts, or you can introduce it your self by simply unpacking the downloaded ZIP, altering the file by adding "{databaseOwner}" in front of every usage of the "{objectQualifier}" token and repackaging it into a ZIP file. This will produce a fully-installable version of the module that should resolve your problem.

I should also note that the module has been tested in environments which use schemas other than 'dbo' without issues, but mistakes are sometimes made. If you still encounter problems, please let me know, and provide as much detail as possible (feel free to remove private data such as passwords from connection strings, etc.), by either replying to this thread or by emailing me at: andrew.nurse@dotnetnuke.com


Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer

 
New Post 5/28/2007 3:22 AM
User is offline Matthias Schlomann
1507 posts
www.taunusstein.org
5th Ranked








Re: Missing {databaseOwner} Statements in all SqlDataProviders 

 The DatabaseOwner before the objectqualifier did not set the databaeOwener as Objectqualifier.  This is specified the DatabaseOwner for the access of the table. Without this setting you loosed many perfomenance on the SqlServer !

I get a high cpu usage near 100% of the SqlServer if the databaseOwner statements are not setting.  I have manuell setting this all to my spocs and functions now.  So I get a very better perfomenance of the Sql server and the weppage.  Please look to these posts too:

http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/108/threadid/133872/scope/posts/Default.aspx 

http://www.dotnetnuke.com/Community/Blogs/tabid/825/EntryID/1422/Default.aspx 

Regards

Matthias


Regards
Matthias
www.moonlightradio.net
Chat with me via MSN
 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Reports Module ...  Missing {databaseOwner} Statements in all SqlDataProviders
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


DNN Outsourcing
50% more affordable services comparing to Western Europe and US: Custom DotNetNuke module development, skins, consulting, maintainence... Over 15.000 working hours of experience in custom DotNetNuke Solutions development, 8 years experience in outsourcing, excellent references!
www.dnnoutsourcing.com
Expressnet - DotNetNuke Hosting
Expressnet provide premium quality ASP.NET Web Hosting. We specialise in Windows based products including ASP.NET and Microsoft SQL Server. We offer fantastic value packages for DotNetNuke hosting. We also offer free asp.net web hosting
www.expressnet.com.au
Softech Development, Inc.
We help your business work smarter with DotNetNuke. Whether you need a new implementation, a custom module or skin for an existing implementation, or integration with your business processes, Softech has the experience and expertise to make it happen.
www.softechdevelopment.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP