buffelen
asked on
Connect to Access Database
Hi, how can i connect to a Access Database file in the reporting services? When i go to 127.0.0.1/reports and new data source i only got SQL as connection type, i need to mage a new connection type to a Access file. In the SQL Server Business Intelligence Development Studio ther is no problem making a shared access connection, but i need that in the reporting services to
Best regards
P. Buffelen
Best regards
P. Buffelen
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
se comment
"Create a system ODBC data source for your access db from Control Panel Administrative tools.
Create a shared ODBC data souce in RS and select the data source you just created in Control panel."