Questions About 32- And 64-bit ODBC

p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:'Calibri","sans-serif';}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0in;margin-bottom:.0001pt;font-size:9.0pt;font-family:Consolas;}
span.PlainTextChar
{font-family:Consolas;}
.MsoChpDefault
{;}
@page Section1
{size:8.5in 11.0in;margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}



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.