microsoft.jet.oledb.4.0 for sql server 2008 r2 64 bit

Since making this change both Jim and I have not had further problems with this. This can cause side effects if you don't have a lot of memory (like performance and other issues), so be careful. This allocates an additional 256MB of memory from the Buffer Pool (BPool) area to the MemToLeaveĪrea. To modify this area, edit the advanced options for the SQL Service (using SQL Configuration Manager) and put in the '-g512 ' option with the other existing ones. From Jim's information, this needs to be around 71MB or more for the OpenRowSet and OpenDataSource to work. The Jet driver might have some leaks under certain conditions that cause this memory to be consumed. It turns out that by default only 256MB of memory is allocated to this area. I actually recently found out that this was due to the MemToLeave memory area running low on memory, thanks to a friend of mine (thanks Jim). For some reason, when it's inside of a transaction it never releases the lock on the file when it's done with it (I'm assuming this is the issue), so the next time it tries to access the file it fails with this error. If you're having a problem where accessing the the file works once, but then you have to restart the SQL Server service before it will work again, make sure that the procedure accessing the file isn't inside of a transaction.It will give this error message if it can't access the file, regardless of why. Make sure that something or someone doesn't have the file that's trying to be accessed open.Error: Cannot initialize the data source object of OLE DB provider '.4.0' for linked server '(null)'. If you're experiencing the error message below, you might also want to check these possibilities.

K, I have been fighting this issue for a while and have finally figured out what was happening in my situation. I'm not a admin on the pilot machine so I don't know it's exact configuration but I'm beeing assured that the only difference is that on pilot machine there is no Visual Studio installed. But when I try to execute it on my second (pilot) machine it ends with the error message posted. Strange is that when I run this code on dev machine it works fine. OLE DB provider '.4.0' for linked server 'XLS' returned message 'Unspecified error'.Ĭannot initialize the data source object of OLE DB provider '.4.0' for linked server 'XLS'. When executing the select statement I get following error message I'm using following code to create linked server and then access dataĮXEC sp_addlinkedsrvlogin N'XLS', FALSE, NULL, Admin, NULL

Microsoft.jet.oledb.4.0 for sql server 2008 r2 64 bit