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  |  

PortalWebHosting
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
The best choice for your web site host, email hosting, and domain registration.
 


  Sponsors  

Meet Our Sponsors

Salaro -- Skins and more
OnyakTech
The best choice for your web site host, email hosting, and domain registration.
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 ...  Error While Executing the Data Source
Previous Previous
 
Next Next
New Post 6/11/2008 1:25 PM
Accepted Answer 
User is offline Lars Tungen
13 posts
10th Ranked


Re: Error While Executing the Data Source 

I am seeing the same Oracle error. Looks like all report parameters needs to be in the query string, otherwise you will get an error. In my simple query I didn't use any parameters. When I added "WHERE :ModuleID=:ModuleId AND :PortalID=:PortalID AND :UserID=:UserID AND :TabID=:TabID" it worked.

Query giving error:

SELECT * FROM T_USERS

 

Query that works:

SELECT * FROM T_USERS WHERE :ModuleID=:ModuleId AND :PortalID=:PortalID AND :UserID=:UserID AND :TabID=:TabID

 

I guess the Oracle data source hasn't been used that much....

 
 
New Post 6/11/2008 9:54 PM
User is offline Sanjay Mehrotra
506 posts
www.acuitisolutions.com
8th Ranked




Re: Error While Executing the Data Source 

 Lars Tungen wrote

I am seeing the same Oracle error. Looks like all report parameters needs to be in the query string, otherwise you will get an error. In my simple query I didn't use any parameters. When I added "WHERE :ModuleID=:ModuleId AND :PortalID=:PortalID AND :UserID=:UserID AND :TabID=:TabID" it worked.

Query giving error:

SELECT * FROM T_USERS

 

Query that works:

SELECT * FROM T_USERS WHERE :ModuleID=:ModuleId AND :PortalID=:PortalID AND :UserID=:UserID AND :TabID=:TabID

 

I guess the Oracle data source hasn't been used that much....

 

 

I think I remember seeing this before - are you using the default report module for SQL Server and trying to get it to connect to Oracle? I know I had to re-write some of the oracle implementations of ExecuteHelper, etc to get it to work correctly with the Reports module. I was thinking (silly me) that you were using the oracle version of this for some silly reason..

Sanjay

 

AcuitiDP - Oracle Data Provider for DotNetNuke
 
New Post 6/12/2008 6:19 AM
User is offline Derek
94 posts
10th Ranked


Re: Error While Executing the Data Source 

That worked out great.  Still confused as to why those parameters are need since the database that I was querying has nothing to do with my DNN installation.

Thanks for your help.

Derek
 
New Post 6/12/2008 10:27 AM
User is offline Lars Tungen
13 posts
10th Ranked


Re: Error While Executing the Data Source 

 Sanjay Mehrotra wrote

I think I remember seeing this before - are you using the default report module for SQL Server and trying to get it to connect to Oracle? I know I had to re-write some of the oracle implementations of ExecuteHelper, etc to get it to work correctly with the Reports module. I was thinking (silly me) that you were using the oracle version of this for some silly reason..

Sanjay

I am using Report core module with "OracleClient DataProvider" selected as the ADO.NET Data Provider. Maybe the Report module always create all of the 4 parameters on the command object, regardless if they are used in the query string or not. The MS SQL Server ignores the unused parameters. Oracle raises an error.
 
 Page 2 of 2Previous12 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Reports Module ...  Error While Executing the Data Source
 


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.
 


Active Modules, Inc.
Creators of Active Forums, the best forum module for DotNetNuke
www.activemodules.com 		DotNetNuke Marketplace - Modules & Skins
The DotNetNuke Marketplace is the official e-commerce gateway for the DNN ecosystem. It's the place to buy and sell DotNetNuke modules, DotNetNuke skins, and other DNN offerings.
DotNetNuke Marketplace 		ExactTarget Email Marketing Software and Solutions
ExactTarget delivers on-demand email software solutions for permission-based email marketing. ExactTarget offers solutions that meet the needs of all industry verticals and all size organizations, including SMB, corporate divisions, not-for-profits, large retail/direct marketers, agencies and enterprises.
ExactTarget.com

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