'Microsoft.ACE.OLEDB.12.0' 64x Sql Server and 86x Office???

Posted by Chris on Stack Overflow See other posts from Stack Overflow or by Chris
Published on 2010-05-24T18:17:02Z Indexed on 2010/05/24 18:21 UTC
Read the original article Hit count: 1398

Filed under:

64bit

|

oledb

|

32bit

|

openrowset

The error: OLE DB provider 'Microsoft.ACE.OLEDB.12.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.

And the answers I'm seeing is a conflict between 64 bit Sql Server and 32 bit Office. Is there a way to run an openrowset on Excel into Sql Server?

insert into dbo.FiscalCalendar 
select * from 
openrowset('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0 Xml;Database=C:\Users\v-chrha\Desktop\fy11.xlsx;',
'Select * from [Sheet1]')

© Stack Overflow or respective owner

Related posts about 64bit

How do I install Geomatica?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I wanted to try the latest version(trial) of Geomatica, Geomatica 2012 on Ubuntu 11.10 beta. When I tried to run the bin file I got a whole list of dependencies. It also seems that it is a RPM package. Instead of going through each entry manually, is there any easy way to search and install a list… >>> More
Java 64bit install throwing non compatible 64bit error in 64bit Windows 7

as seen on Stack Overflow - Search for 'Stack Overflow'
JRE and JDK 64bit install executable are throwing a non compatible win32 error: jre_7u1_windows-x64bit.exe is not a valid Win32 application. I thought this could be a system environment variable problem, but from what I can tell it is not, the variable PROCESSOR_ARCHITECTURE is set as: AMD64 and… >>> More
ColdFusion 9 64bit / MAMP Pro 1.9 64Bit on OSX

as seen on Server Fault - Search for 'Server Fault'
I followed this thread and it's associated links. But there is nothing i can do to get CF9 to work. MAMP Pro now has the 64bit version of apache 2.2. Whenever i start apache i get an error saying it couldn't start and to check the logs. i check the logs and this is what i see. 6/1/10 12:39:12 PM… >>> More
Using Toad with 64bit Oracle Client and Windows 7 64bit Operating System

as seen on Stack Overflow - Search for 'Stack Overflow'
After downloading the latest version of Toad for Windows 7 64bit, I am struggling to get it to connect to the database using the existing full Oracle Client that is already on the desktop. The Oracle Client that is there is a 64bit version and is version 12c. When running Toad it says that there is… >>> More
how to find if the machine is 32bit or 64bit

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there anyway from a C prog to find whether the OS is currently running in 32bit or 64bit mode. I am using a simple program as below int main(void){ switch(sizeof(void*)){ case 4: printf("32\n"); break; case 8: printf("64\n"); break; } } Is this a correct… >>> More

Related posts about oledb

Running OLEDB VB6 Windows Progam Under Wine

as seen on Super User - Search for 'Super User'
I'm trying to install a VB6 Windows program that uses OLEDB to access VFP tables to run under Wine 1.0.1 on Ubuntu 9.10. Wine is configured to Windows version Windows XP. The program install ran okay, and I used winetricks to install MDAC 2.8 and JET 4.0 sp7. I also installed Microsoft's vfpoledb… >>> More
Using OLEDB parameters in .NET when connecting to an AS400/DB2

as seen on Stack Overflow - Search for 'Stack Overflow'
I have been pulling my hair out trying to figure out what I can't get parameters to work in my query. I have the code written in VB.NET trying to do a query to an AS/400. I have IBM Access for Windows installed and I am able to get queries to work, just not with parameters. Any time I include a parameter… >>> More
How to determine MS Access field size via OleDb

as seen on Stack Overflow - Search for 'Stack Overflow'
The existing application is in C#. During startup the application calls a virtual method to make changes to the database (for example a new revision may need to calculate a new field or something). An open OleDb connection is passed into the method. I need to change a field width. The ALTER TABLE… >>> More
OleDb database to DataSet and back in c#?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm writing a program that lets a user: Connect to an (arbitrary) View all of the tables in that database in separate DataGridViews Edit them in the program, generate random data, and see the results Choose to commit those changes or revert So I discovered the DataSet class, which looks like it's… >>> More
Exception:Cannot Start your application.The Workgroup information file is missing or opened exclusiv

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
We were getting this error when trying to connect to a password protected access file. This is what the connection string looked likestring conString =@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="Path to your access file";User Id=;Password=password";To fix the issue this is what… >>> More