Re: Questions about 32- and 64-bit ODBC

My guesses are inline below.

"Serdar Yegulalp" <thegline@xxxxxxxxxxxxx> wrote in message
news:1169746334.753243.249130@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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?

No. 64 bit applications must use 64 bit drivers.


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)?

This shouldn't be a problem. Our 32 bit apps talk to 64 bit AIX boxes all
the time.


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?

This sounds the same as 2.


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 don't see why not for TCP/IP. I don't know about 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.

- Arnie


.

Relevant Pages

  • Re: OSQL Question
    ... Running osql loads in, among others, the following modules: ... sqlsrv32.dll - SQL Server ODBC driver ...
    (microsoft.public.sqlserver.programming)
  • truncated data after INSERT with undef in DBI - bug?
    ... But if the first execute has a undef, ... Is it a problem with DBI, ... the DBD::ODBC driver or the SQL Server ODBC driver or SQL Server itself? ...
    (comp.lang.perl.misc)
  • Re: Line 1: Incorrect syntax near=
    ... > then the ODBC Button, I select my SQL SErver ODBC that I have setup, using ... > the SA login to login. ... > follwoing error although saves the information in the SQL Server database? ...
    (microsoft.public.project)
  • Re: Where did SQLSRV32.DLL 2000.81.9042.00 come from?
    ... > Information Microsoft SQL Server ODBC Driver ...
    (microsoft.public.sqlserver.odbc)
  • Re: SQL Server does not exist or access denied
    ... SQL Server, the edition of SQL Server, DSNs, registry ... settings, firewall settings, TCP/IP issues, etc. ... Microsoft SQL Server ODBC Driver Version 03.86.1830 ... Data Source Description: test ...
    (microsoft.public.sqlserver.odbc)