March 13, 2012 at 12:13 pm
Hi Folks
I would like to know that BIDS can have 32 bit & 64 Bit versions or not ?suppose i install sql 64 bit then what's the BIDS bit?if i install 32bit sql,what's BIDS bit?
Any article/link would be helpful in this regard.
March 13, 2012 at 12:32 pm
SQL Server Management tools (SSMS, BIDS) are going to be 32-bit installations. There is no version of BIDS and SSMS available in 64bit. You will probably find it a bit hard to find that in writing but just going by the 64bit installations I have done they are 32bit.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
March 13, 2012 at 1:01 pm
Thanks ...
Since BIDS is 32 bit application,we are installing 32bit drivers and 64bit drivers For DTS and SSIS on SQL 64bit right?
March 13, 2012 at 1:39 pm
In debug you'll want to run in 32b mode. In prod, where you dont interactively run BIDS to execute the package, you'll probably want the driver/s running in 64. Unless it's Excel, in which case I dont think there *is* a 64b driver :-S
Steve.
March 13, 2012 at 1:50 pm
Suppose i copy SSIS packages or DTS packages from 32bit to 64 bit SQL server,to run these packages successfully on 64bit sql which drivers do i need to install on 64bit sql either 32bit drivers or 64bit drivers for data sources oracle and teradata?
March 13, 2012 at 1:52 pm
jgflufg (3/13/2012)
Suppose i copy SSIS packages or DTS packages from 32bit to 64 bit SQL server,to run these packages successfully on 64bit sql which drivers do i need to install on 64bit sql either 32bit drivers or 64bit drivers for data sources oracle and teradata?
The drivers need to be approriate for the server (32 bit or 64 bit).
March 14, 2012 at 2:43 am
stevefromOZ (3/13/2012)
In debug you'll want to run in 32b mode. In prod, where you dont interactively run BIDS to execute the package, you'll probably want the driver/s running in 64. Unless it's Excel, in which case I dont think there *is* a 64b driver :-S
I do believe that there now is a 64bit driver which works, just trying to find the download link, sure its been posted in a number of topics before, will update when I find more.
Edit,
I belive its for 2008, but will see if its 2005 compatable once I find the links.
The download link is below, and you will need to use the “Microsoft.ACE.OLEDB.12.0” provider passing in the correct extended properties
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255
March 14, 2012 at 3:42 am
BIDS is 32-bit, but when running a package it emulates a 64-bit environment by default.
This can cause issues with the Excel connections, as there is usually not a 64-bit JET OLE DB or ACE OLE DB installed.
To change this, you need to put the Run64BitRuntime property of the project to false.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 5, 2015 at 10:52 am
Hey Folks,
I am facing an error issue while installation of 32-bit SQL Server BIDS on my 64-bit Windows-7 professional Edition.
Kindly help.
January 5, 2015 at 12:05 pm
it.anishmca (1/5/2015)
Hey Folks,I am facing an error issue while installation of 32-bit SQL Server BIDS on my 64-bit Windows-7 professional Edition.
Kindly help.
It would be helpful if you posted the actual error.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 5, 2015 at 4:47 pm
it.anishmca (1/5/2015)
Hey Folks,I am facing an error issue while installation of 32-bit SQL Server BIDS on my 64-bit Windows-7 professional Edition.
Kindly help.
It would probably help if you told us what the error you're getting is. Otherwise, we have to go through the whole FLD.
Step 1. Is the computer turned on? 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply