Link to home
Start Free TrialLog in
Avatar of buffelen
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
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

I don't know whether this works but it's an answer given to a similar Q on a different site.

"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."

ASKER CERTIFIED SOLUTION
Avatar of buffelen
buffelen

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of buffelen
buffelen

ASKER

se comment