Share via

Can 32 bit connect into SQL Server 64 bit?

techresearch7777777 1,801 Reputation points
2020-10-07T21:48:26.48+00:00

Can a user connect using 32 bit SQL ODBC driver into SQL Server 64 bit version or do they need to use a 64 bit SQL ODBC driver?

Thanks in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,945 questions
0 comments
Accepted answer
  1. Dave Patrick 426.3K Reputation points MVP
    2020-10-07T22:14:52.44+00:00

    They both can connect to either 32 or 64 bit databases. Use the 32 bit driver when the client application or process is 32 bit.

    --please don't forget to Accept as answer if the reply is helpful--

    1 person found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,716 Reputation points
    2020-10-08T13:29:06.827+00:00

    Just to be clear, the driver 32/64 is a CLIENT side edition. This does not affect in any way connecting to the server.

    1 person found this answer helpful.
    0 comments
  2. techresearch7777777 1,801 Reputation points
    2020-10-08T14:20:01.837+00:00

    Thanks everyone for the replies.

    1 person found this answer helpful.
  3. Cris Zhan-MSFT 6,611 Reputation points
    2020-10-08T05:48:11.687+00:00

    Hi,

    >Can a user connect using 32 bit SQL ODBC driver into SQL Server 64 bit version or do they need to use a 64 bit SQL ODBC driver?

    Both 32-bit and 64-bit drivers can connect to 32-bit or 64-bit servers.

    some similar cases:
    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/07b1cc89-ecc4-4bf5-91bf-3fc411ff818c/client-32-bit-with-sql-server-2008-64-bit?forum=sqldataaccess
    https://stackoverflow.com/questions/8729467/can-a-32bit-application-access-a-64bit-sql-server-database

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments