none
Is there a MSDASQL 64 provider on Windows 7 Ultimate x64 bit OS? RRS feed

  • Question

  • There are two providers for linked servers that can be used for SQL Anywhere 16 from SAP/Sybase.

    The ODBC Manager for Window 7 x64 bit does not have a Microsoft OLEDB provider for ODBC in the ODBC Manager. If I create a linked server using the 32bit ODBC driver (which happens to exist on Windows 7 x64bit in ODBC 32) then there is an 'architectural mismatch'. I wonder if there is a MSDASQL x64 bit for Windows 7 x64 bit?

    There is another provider SAOLEDB.16 listed for linked servers in SQL Server 2012. Is it useful, if so, is there some  documentation as to it being used somewhere?


    mysorian

    Monday, July 7, 2014 12:35 AM

Answers

  • Hi Jayaram Krishnaswamy,

    According to your description, there is no default provider that  is designated on a 64 bit platform. On 32bit platforms, MSDASQL is designated as the default provider , you must download and install the 64 bit MSDASQL provider and explicitly designate it in your ADODB.connection. However, MSDASQL ships with the Windows operating system, and Windows Server 2008 & Windows Vista SP1 are the first Windows releases to include a 64-bit version of the technology. So, there is no a MSDASQL x64 bit for Windows 7 x64 bit.

     If you want to create linked Server between SQL Server and SAP Sybase, you can uses the SAP Sybase IQ OLE DB provider (SAOLEDB.16) to obtain access to an SAP Sybase IQ database, there is a note you should enable “Dynamic parameters” and “Allow inprocess” under the  Providers ( SAOLEDB.16). For more information, you can review the following article.

    http://arbime.wordpress.com/2013/11/14/ms-sql-2005-create-a-link-server-to-sybase-iq-16/

    Regards,

    Sofiya Li


    Sofiya Li
    TechNet Community Support

    Monday, July 7, 2014 10:49 AM
    Moderator

All replies

  • Hi Jayaram Krishnaswamy,

    According to your description, there is no default provider that  is designated on a 64 bit platform. On 32bit platforms, MSDASQL is designated as the default provider , you must download and install the 64 bit MSDASQL provider and explicitly designate it in your ADODB.connection. However, MSDASQL ships with the Windows operating system, and Windows Server 2008 & Windows Vista SP1 are the first Windows releases to include a 64-bit version of the technology. So, there is no a MSDASQL x64 bit for Windows 7 x64 bit.

     If you want to create linked Server between SQL Server and SAP Sybase, you can uses the SAP Sybase IQ OLE DB provider (SAOLEDB.16) to obtain access to an SAP Sybase IQ database, there is a note you should enable “Dynamic parameters” and “Allow inprocess” under the  Providers ( SAOLEDB.16). For more information, you can review the following article.

    http://arbime.wordpress.com/2013/11/14/ms-sql-2005-create-a-link-server-to-sybase-iq-16/

    Regards,

    Sofiya Li


    Sofiya Li
    TechNet Community Support

    Monday, July 7, 2014 10:49 AM
    Moderator
  • Thank you.

    Your arrangement appears to have the following elements:

    • SQL Server 9.00.3054.00 – SP2 (Standard Edition) running on Windows 2003 server SP2 using mixed authentication mode.
    • Sybase IQ 16 SP1 running on Solaris 10 over Sun Sparc x64 architecture.

    I am not sure what architecture you had for your SQL Server and your Sybase IQ 16 SP1. There may be differences in the ODBC drivers.

    In my case both SQL Server 2012 (x64bit) and SQL Anywhere 16.0 are on the same laptop. There has been conflicting suggestions whether "Allow inprocess" to be enabled or not.


    mysorian

    Your answer 'So, there is no a MSDASQL x64 bit for Windows 7 x64 bit' is correct.
    Tuesday, July 8, 2014 1:26 AM