SQL 2005-64 bit

Last post 03-14-2008 7:22 PM by MohammedU. 4 replies.
Page 1 of 1 (5 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next
  • 03-13-2008 12:46 PM

    SQL 2005-64 bit

    Will my 32-bit application works, if i move my SQL 2000 Database to SQL 2005-64 bit running on OS 2003 64 bit? What are the advantages of moving to 2005 64 bit?

    Cali
  • 03-14-2008 1:16 AM In reply to

    Re: SQL 2005-64 bit

    There are numerous articles on the WWW regarding the advantages of 64-bit environments that can be Googled, perhaps the most relevant article for your specific question is http://www.microsoft.com/sql/editions/64bit/overview.mspx 

    In short, 32-bit applications are only in danger of failing if they are installed and run directly on the 64-bit hardware itself. If your 32-bit application is running on a 32-bit client computer and is merely connecting to the 64-bit SQL server instance, then everything should be fine.

    I have encountered one notable difference between 32-bit and 64-bit SQL server versions when using older Visual Basic connection strings from VBscript files or "classic" ASP pages, in that connections to 64-bit instances require a SQLOLEDB connection: 

    When connecting to 32-bit versions, it was possible to use this syntax:

    Set Db = CreateObject("adodb.Connection")
    Db.ConnectionString = "driver={SQL Server};server=<ServerName>;uid=<username>;pwd=<password>;database=<databasename>

    The same connection to a 64-bit instance requires a change: 

    Set Db = CreateObject("adodb.Connection")
    Db.ConnectionString = "Provider=SQLOLEDB;server=<ServerName>;uid=<username>;pwd=<password>;database=<databasename>

    Hope this helps.

     

  • 03-14-2008 6:48 AM In reply to

    • satya
    • Top 10 Contributor
    • Joined on 11-05-2002
    • United Kingdom
    • Posts 22,713
    • Microsoft MVP
      Moderator

    Re: SQL 2005-64 bit

    -Satya S K J

    SQL Server MVP



    Knowledge is Power, you will gain by sharing it. SSQA.net - Invisible contributions to the users & visible success in SQL Community.
  • 03-14-2008 5:12 PM In reply to

    Re: SQL 2005-64 bit

    Thanks for the answers Satya. I have gone through the provided links and they are very helpful.

    Cali
  • 03-14-2008 7:22 PM In reply to

    Re: SQL 2005-64 bit

    MohammedU.
    Microsoft SQL Server MVP
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
Page 1 of 1 (5 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.