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  |  

AspDotNetStoreFront
  Ads  
OnyakTech
 


  Sponsors  

Meet Our Sponsors

The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
.: CounterSoft :.
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Reports Module ...  Use Reports Module to access a table in another database
Previous Previous
 
Next Next
New Post 11/3/2006 6:06 PM
User is offline Don Bowden
3 posts
10th Ranked


Use Reports Module to access a table in another database 

I have the reports module installed.  And I have used a sql statement accessing the dotnetnuke users table successfully.  But I don't know the snytax to access a table (Customer) and field (CustomerName) found in another database (ISSIDEMO) but still located on the same database server (SRV1).  One, will the reports module even allow you to access another database and two, what would be the correct syntax.  Thanks very much!

Don

 
New Post 2/17/2007 8:20 AM
User is offline olivier moschko
1 posts
10th Ranked


Re: Use Reports Module to access a table in another database 

try:

 select CustomerName from ISSIDEMO.dbo.Customer

 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Reports Module ...  Use Reports Module to access a table in another database
 


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.

 


FREE Skins, Modules & Control Panel!
Choose how much you want to pay on our Skins, Modules, Containers and Control Panel - Starting from FREE!
www.dnngroup.com
Disgrafic
Diseño y creación de portales web dinámicos :: Desarrollo de módulos personalizados :: Soluciones a medida :: Imagen Corporativa :: Tu proveedor DNN en España
www.disgrafic.com
DM Analytics, LLC
DM Analytics, LLC provides software solutions that facilitate rapid development of independent or dependent datamarts and their associated web-based reporting.
www.dmanalytics.com

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