Migration from 64 bit to 32 bit

Question

Post reply

Migration from 64 bit to 32 bit

jeandlauro

SSC Eights!

Points: 807
More actions
January 23, 2014 at 6:29 am

#396150

Hi,
I want to try installing SQL Server Express 32-bit as I also have MS Office 32-bit pre installed on my computer. Just a couple questions I hope to get help with:
-Should I uninstall SQL server 64-bit before installing 32-bit?
-will I lose much of my schema?
-can I install both on my pc?
thanks,
J

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259015 More actions · Answer 1

Is there a specific reason SQL Server has to have the same bitness as MS Office?

You should be able to install multiple instances of Express.

I don't see how you would lose something of your schema.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

jeandlauro SSC Eights! Points: 807 More actions · Answer 2

I need to import data from excel using OPENROWSET. I can use the SSIS import export wizard but cannot save the import package with SSMS Express.

Whenever I try to use openrowset i get the error

Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

I have been told this is because I am using SQL Server 64-bit with MS Office 32-bit.

thanks

Koen Verbeeck SSC Guru Points: 259015 More actions · Answer 3

It's more likely that 64-bit SQL Server is trying to use a 64-bit JET OLE DB provider, which doesn't exist.

You could try to use the 64-bit ACE OLE DB provider to read from the Excel file. Excel files itself are independent of the bitness.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

jeandlauro SSC Eights! Points: 807 More actions · Answer 4

I will try that. I have also tried to instal the 64-bit access driver but get this message.

http://www.microsoft.com/en-us/download/confirmation.aspx?id=13255

Engine 2010 because you currently have 32bit Office products

installed. If you want to install 64bit Microsoft Access Database

Engine 2010, you will first need to remove the 32bit installation of

Office products. After uninstalling the following product(s), rerun

setup in order to install 64bit version of Microsoft Access Database

Engine 2010:

Microsoft Office Professional Plus 2007, Microsoft Office Access

database engine 2007 (English)

Lowell SSC Guru Points: 323482 More actions · Answer 5

jeandlauro (1/23/2014)
I will try that. I have also tried to instal the 64-bit access driver but get this message.
http://www.microsoft.com/en-us/download/confirmation.aspx?id=13255
Engine 2010 because you currently have 32bit Office products
installed. If you want to install 64bit Microsoft Access Database
Engine 2010, you will first need to remove the 32bit installation of
Office products. After uninstalling the following product(s), rerun
setup in order to install 64bit version of Microsoft Access Database
Engine 2010:
Microsoft Office Professional Plus 2007, Microsoft Office Access
database engine 2007 (English)

I've found the hard way there are multiple prerequisites to get Excel/Access to work via a Linked server.

install the AccessDatabaseEngine_x64.exe from microsoft:

http://www.microsoft.com/en-us/download/details.aspx?id=13255

make sure you open an Administrative command prompt window, and run it with the c:\Downloads\AccessDatabaseEngine_x64.exe /passive

parameter / command line flag;

this will force the install of the drivers, even if you have 32 bit office installed;

otherwise you get some error about 32 bit Office preventing the install.

After that is installed:

--Required settings for the provider to work correctly as a linked server

EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1

GO

EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

jeandlauro SSC Eights! Points: 807 More actions · Answer 6

I have tried this now and am getting

Microsoft Access Database Engine 2010

/extract:path, extracts the content of the package to the path folder

/log[:path to log file], enables verbose logging for the update installation

/lang:lcid, sets the user interface to the specified locale when multiple locales are

available within the package

/quiet, runs the package in silent mode

/passive, runs the update without any interaction from the user

/norestart, prevents prompting of user when reboot of machine is needed

/forcerestart, forced restart of machine once update is complete

/?, shows this help message

OK

Going to try a computer restart and see what hapens.

jeandlauro SSC Eights! Points: 807 More actions · Answer 7

I am still getting the error:

The 32-bit OLE DB provider "Microsoft.ACE.OLEDB.12.0" cannot be loaded in-process on a 64-bit SQL Server.

jeandlauro SSC Eights! Points: 807 More actions · Answer 8

hey, it actually worked! I'm getting the data now from any xls file or xlsx.

Thanks!

Lowell SSC Guru Points: 323482 More actions · Answer 9

so glad it worked out for you;

just got back from lunch, and i was just about to reply that i think you might have put a space between the slash and passsive.

/ passive instead of /passive

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

jeandlauro SSC Eights! Points: 807 More actions · Answer 10

jeandlauro

SSC Eights!

Points: 807

January 24, 2014 at 10:56 am

#1683214

thanks again.