Cannot initialize the data source object of OLE DB provider "Microsoft

[rfoote]

Getting the error

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "EXCEL_SRV".

when trying to create a spreadsheet from an SQL Table.

This just started when we has to starting windows Authentication as a login.

Please Help.

Thanks

 

[Qik3Coder]

What is the name of your datasource on the EXCEL_SRV?

Does the specific user have rights to do this on that database?

If [blue]you have problems[/blue], I want [green]source code[/green] AND [green]error messages[/green], none of this [red]"there was an error crap"[/red]