Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blackX
Posting Yak Master
102 Posts |
 Posted - 2008-06-25 : 13:35:40
|
| I have a report (created with Crystal) that has a view for the datasource. Inside the view a database table is joined with an excel file. When I log in as 'sa' in Crystal to run the report it runs fine. However when I log in as a different user I get an error.Failed to retrieve data from the database.Details: ADO Error Code: 0x80040e14Source: Microsoft OLE DB Provider for SQL ServerDescription: Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server.SQL state: 42000Native Error: 7415[Database Vendor Code:7415]Failed to Open OpenRowsetAny help would be great |
|
|
blackX
Posting Yak Master
102 Posts |
Posted - 2008-06-25 : 14:18:31
|
| I changed the provider to Excel 8.0 from 5.0 and it seemed to have fixed the problem |
 |
|
|
|
|
|
Linked Servers