Registered users    
MembershipMembership:
Latest New UserLatest:Phil Clarkson
New TodayNew Today:5
New YesterdayNew Yesterday:6
User CountOverall:22929
Private messaging    
You must be logged in to use this module.
Top 10 posters    
NamePosts
Mariette Knap12490
Marina Roos12181
Eriq Neale2071
Michael Patrick1901
Stan Guinn1817
Robert Pearman1720
Nick Pieters1425
Stewart Brown609
Kevin D.563
Eddie Kerr534
Welcome unauthorized visitor    
If you want to join us in the discussions on this forum you need to register first. Registration is free! If you are already a registered user please login to join the forum.
Small Business Server Support Forum    
Forums > Microsoft Smallbusiness Server > SQL Server 2000
Subject: SQL 2005 reporting services
Prev Next
You are not authorized to post a reply.

Author Messages
RJE Lemmens User is Offline
The Netherlands
Member since
3/30/2005

Registered Users
Posts: 15
6/11/2008 09:55 PM  
Hi,
 
I have an windows application connected with a MsAccess database (Office 2003).
Now I want to build reports for this application in SQL 2005 reporting services.
In the (near) future the MsAccess database will upgraded to SQL 2005.
Meanwhile, is it possible to connect the MsAccess database, thrue OLEDB, to the reporting services (production) of SQL 2005 workgroup edition?
Or do I need SQL 2005 standard edition.
I know this isn't possible with SQL 2005 express Advance.
Greetings,

Rogér Lemmens, MCP
Software Engineer
Byte Services ICT
Edwin Sarmiento User is Offline
Singapore
Member since
2/13/2007

Microsoft MVP
Posts: 128
6/30/2008 09:34 AM  
Yes you can. It's as simple as creating a connection. Just make sure you select Jet OLEDB for MS Access
MCP MCDBA MCAD MCSD MCT MCTS MCITP : DBA MCSA
http://bassplayerdoc.blogspot.com
Need a remote SQL Server DBA?
You are not authorized to post a reply.
Forums > Microsoft Smallbusiness Server > SQL Server 2000 > SQL 2005 reporting services


ActiveForums 3.7
Forum policy    
These Discussion Forums are dedicated to the discussion of the Small Business Server and related server and client software. For the benefit of the community please observe the following posting guidelines:
  1. No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to Small Business Server and related server and client software.
  2. No Flaming or Trolling.
  3. No Profanity, Racism, or Prejudice.
  4. Site Moderators have the final word on approving/removing a thread or post or comment.
Copyright 2002-2008 Concentrix b.v.    :   Page generated in 0.2500016 seconds.   :   Terms Of Use   :   Privacy Statement