OpenDataSource fails pls help
- by Vivek Chandraprakash
I'm trying export records from SQL Server 2008 to mdb file using OpenDataSource. It works when I log in using Windows authentication. But it fails when I use SQL Server authentication.
This is the error i get
OLE DB provider
"Microsoft.Jet.OLEDB.4.0" for linked
server "(null)" returned message
"Could not delete from specified
tables.". Msg 7320, Level 16, State 2,
Procedure EXPORT_Employee, Line 110
Cannot execute the query "DELETE FROM
employee_export " against OLE DB
provider "Microsoft.Jet.OLEDB.4.0" for
linked server "(null)".
Thanks
-Vivek