BIDS 32bit or 64 bit application?

  • 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.

  • 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

  • It's 32-bit only. For written confirmation 😉 , look at the top of this page here.

    Steve.

  • Thanks ...

    Since BIDS is 32 bit application,we are installing 32bit drivers and 64bit drivers For DTS and SSIS on SQL 64bit right?

  • 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.

  • 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?

  • 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).

  • 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

  • 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

  • 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.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

  • 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


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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