Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

installing 32-bit SQL Server 2008 on 64-bit Vista Ultimate Expand / Collapse
Author
Message
Posted Sunday, June 7, 2009 5:41 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 7, 2014 7:51 PM
Points: 40, Visits: 2,469
Hi All,
I'm trying to install 32-bit SQL Server Standard on 64-bit Vista Ultimate, I need to do this because I want access to the 32-bit ODBC drivers and I understand from reading numerous posts that this can be done. However, going through the setup routines there seems to be no option for selecting which os platforms should be targeted. Am I missing something? Can anyone advise of the appropriate steps to get this installation done? Also, assuming I can get it installed, are there any special steps needed to get Microsoft.ACE.OLEDB.12.0 installed for use int eh 32 bit SQL instance.

Ta.
Post #730441
Posted Sunday, June 7, 2009 7:30 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 7, 2014 7:51 PM
Points: 40, Visits: 2,469
Ok, I figured this out myself. On the first page of the SQL Server 2008 setup routine there is an Options option which allows setting the architecture, once this is set to x86 it will install SQL in the wow environment. I also believe there was an issue with the initial SQL Server 2008 distributable packages int hat there was some issue with them missing some required folders, this has been resolved with later releases, certainly the current sql server 2008 standard x86,x64 download seems to be installing fine.
Post #730453
Posted Sunday, June 7, 2009 8:04 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, August 25, 2014 10:22 AM
Points: 3,433, Visits: 14,428
I am just seeing your post but the SQL Server 2008 binaries are AnyCPU that is it can install as both x86 and x64 and you don't need to install x86 to use x86 ODBC drivers because both are in all x64 operating systems. And you should be able to access your ACE driver through the x86 ODBC. Now dependning on your needs you may need to manually reference MDAC in code because Vista and Win2008 comes with new data access.


Kind regards,
Gift Peddie
Post #730457
Posted Sunday, June 7, 2009 10:36 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 7, 2014 7:51 PM
Points: 40, Visits: 2,469
Hi there,
Thanks for you reply, however I'm pretty sure the ACE drivers are only 32 bit and won't load into a 64 bit installation of SQL. To access say a CSV file or an excel spreadsheet using OPENROWSET I use the Microsoft.ACE.OLEDB.12.0 driver and this will anly load into a 32 bit installation. So I'm setting up a 32 bit instance to do all the extranal data reading and a linked server from my 64bit to the 32bit to make this available to my application. I don't use SSIS as data importing and scheduling etc. is handled by my app. Having said all that I'm more than happy to be proven wrong as I for one, can;t believe Microsoft have not released a 64 bit version of ACE.
Post #730478
Posted Monday, June 8, 2009 7:56 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, August 25, 2014 10:22 AM
Points: 3,433, Visits: 14,428
I am just seeing your post but the SQL Server 2008 binaries are AnyCPU that is it can install as both x86 and x64 and you don't need to install x86 to use x86 ODBC drivers because both are in all x64 operating systems. And you should be able to access your ACE driver through the x86 ODBC.


I did not say there are x64 ACE drivers I rather said you can use the x86 ODBC driver in the WOW64 directory of your x64 Vista to load on the x86 directory of your x64 SQL Server 2008. That is the application must build x86, you only get issues when you try to load it as x64 or AnyCPU if you are in managed code. So I am trying to save you the extra hop to the x86 SQL Server because everything x64 in the Microsoft platform also loads the x86 version of that dll.


Kind regards,
Gift Peddie
Post #730687
Posted Monday, June 8, 2009 4:00 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 7, 2014 7:51 PM
Points: 40, Visits: 2,469
Sorry, I must be having a bit of a thick moment.

Are you saying that the ACE drivers can be used in an openrowset query in a x64 installation of SQL. If this is the case do you have some instructions on how to do this please? Everything I've read on the web seems to indicate that this is not possible and I have some clients that would be very pleased to see this functionality without having to have an additional x86 instance of SQL.
Post #731008
Posted Monday, June 8, 2009 4:31 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, August 25, 2014 10:22 AM
Points: 3,433, Visits: 14,428
The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.

Look for the above folder in the WOW64 directory to configure your connection to the ACE OLE DB driver for Access 2007 and you should also look for the x86 SQL Server directory the only requirement your application must build x86. That includes SSIS packages because when you are using x86 with x64 you build lower.



Kind regards,
Gift Peddie
Post #731017
Posted Tuesday, June 9, 2009 2:53 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:55 AM
Points: 2,868, Visits: 3,214
If you have a 64-bit installation of SQL Server 2008 available, it is definitely worth trying to connect to it with your 32-bit application. There are very few issues with using 32-bit applications connecting to 64-bit SQL Server 2008.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #731242
Posted Tuesday, June 9, 2009 3:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 7, 2014 7:51 PM
Points: 40, Visits: 2,469
My application has no problems connecting and using 64 SQL Server apart from the inability to use ACE drivers. My application created views which use OPENROWSET to access external data. These OPENROWSET vqueries use the ACE drivers which don't work in this environment because (I guess) the views are running under the 64 bit SQL Server instance. Sure, my application (the actual executable) could open connections directly on the external data source using ACE but thats not the way it works. It uses SQL views with OPENROWSET, it is this situation that requires a separate 32 bit instance of SQL, the 32 bit instance holds the views which because the instance is 32 bit can reference and use the 32 bit ACE drivers. The 64 bit instance uses a linked server to ref0erence the data in the external files via the OPENROWSET views on the 32 bit instance.
Post #731257
Posted Tuesday, June 9, 2009 3:47 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:55 AM
Points: 2,868, Visits: 3,214
Can I suggest you open a case for this with Microsoft. There should be a better solution than installing a 32-bit version of SQL Server 2008 on a 64-bit box.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #731273
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse