ACE.OLEDB Error 7303 - SQL Server Forums

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.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

ACE.OLEDB Error 7303

Author

Topic

Billpl
Yak Posting Veteran

71 Posts

Posted - 2011-11-07 : 03:19:54

Hi All,

We have multiple servers running Excel imports/exports via OpenDataSource and linked servers. All using ACE.OLEDB 12.00.

All except one new one (Server 2008/32bit SQL 2008 Web Edition) running under WMWare. It positively, absolutely refuses to run no matter what the query, which excel file or file location.

The SQL Error is 7303, which is either a syntax or rights issue.
The Syntax is fine and the file rights are set to full control to everyone.

Our test example:(which works on all the other servers)

select one,two
FROM OpenDataSource( 'Microsoft.ACE.OLEDB.12.0','Data Source=C:\Excel\test.xlsx;Extended properties="Excel 12.0;HDR=yes;IMEX=1";')...Sheet1$

The Error:

OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".

SQL Command Configuration Script

Execute sp_configure 'show advanced options', 1
reconfigure 
Execute sp_configure 'Ad Hoc Distributed Queries', 1 
reconfigure 
Execute sp_configure 'show advanced options', 1 
RECONFIGURE
Execute sp_configure 'Ole Automation Procedures', 1
RECONFIGURE 
Execute sp_configure'xp_cmdshell',1
RECONFIGURE 
USE master
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1  
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1

I'm thinking (hoping) it's a simple Windows Server or SQL Server Configuration problem.
Our last resort is scrap the whole Server and build a new one from scratch and hope the problem goes away on it own

Thanks
Bill Plander

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources