Questions about 32- and 64-bit ODBC

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have several questions about the behavior of 32- and 64-bit ODBC
drivers in Windows.

1. If I have a 64-bit application, can it make use of 32-bit ODBC
connectors?

2. If I have a 32-bit ODBC connector, can it connect to a 64-bit
database application (for instance, a 32-bit SQL Server ODBC driver
that talks to the 64-bit version of SQL Server)?

3. If I have a 32-bit system that has the 32-bit SQL Server ODBC driver
installed, can I use that to connect to a remote 64-bit SQL Server via
named pipes or TCP/IP?

4. Would a scenario like #3 be possible locally? Example: I have a
32-bit SQL Server ODBC driver that talks to a locally installed
instance of 64-bit SQL Server via TCP/IP or named pipes.

I've scoured a bit for details about the interactions between 32- and
64-bit databases and data components and the details still seem very
sketchy, so any help is appreciated.

.

Relevant Pages

  • RE: VFP8/SQL Server locks not being dropped after insert?
    ... Are they connecting to SQL Server using the SQL Server ODBC driver or the ... Have you tried creating an ODBC trace log from the machine ...
    (microsoft.public.fox.programmer.exchange)
  • Re: 32 bit ODBC in Win XP x64?
    ... Please note that by default the build configuration is compiled for "Any ... CPU", which means when the assembly runs on x64, the assembly will be JIT ... I only verified this using the sql server odbc driver and it proves above ...
    (microsoft.public.data.odbc)
  • Re: I cant add a odbc
    ... > databases server or odbc. ... > The setup routines fot the SQL Server ODBC driver ... > could not be loaded due to system error 126 ...
    (microsoft.public.sqlserver.odbc)
  • SQL Server ODBC Driver Ignores Authentication Setting
    ... set their ODBC connections with SQL Server Authentication, ... Microsoft Data Access Components 2.6 RTM, ... authentication to log into the database. ...
    (microsoft.public.sqlserver.security)
  • Re: Linking tables access - sql server 2005
    ... Another advantage of this method is that you don't need an ODBC setting on the local computer, ... Create a linked table to SQL Server without using a DSN ... Name of the table that you are linking to on the SQL Server database ... Function AttachDSNLessTable(stLocalTableName As String, stRemoteTableName As String, stServer As String, stDatabase As String, Optional stUsername As ...
    (microsoft.public.access.adp.sqlserver)