I am utilizing the fresh 64bit Office 2010 drivers with supplier name Microsoft.ACE.OLEDB.12.0. It all works fine for a while just reading comma-separated values (CSV) files and excel sheets and so on okay but afterward throws a "The provider reported an surprising catastrophic failure". My surroundings is 64 bit Windows 7 running VMWare Workstation, with a 64-bit Windows 7 guest running SQL Server 2008 64 Bit. Essentially I'm running the following which works infrequently receiving the failure over.
Code:
Select top 50 FROM OPENROWSET ('Microsoft.ACE.OLEDB.12.0','Text; Database=c: \temp\captell;HDR=Yes, 'SELECT * FROM [DIGDAS132101091135.TXT]')
I have as well attempted these on Windows server 2003 64 bits with SQL Server 2008 64 bit and obtain the similar error. Has anybody as well had this trouble?
Bookmarks