tags:

views:

47

answers:

2
+1  Q: 

32bit ODBC and 64bit SQL Server

I have a 64bit server running Windows Server 2008 and MSSQL 2008, both in 64bit. I also have an application which queries a second system but can only work in windows server 2003 32bit. I want to connect both systems via a service that would run on the 32bit system and connecting to MSSQL via ODBC.

What are the pitfalls? Has anyone tried something similar?

A: 

It does not matter if the server is running in 64 bit.

Fosco  2010-08-19 14:16:11
A: 

Network communication is not changed because the server has a diff CPU. As far as yhour client is concerned, it doesnt even know what the server is running on.

Neil N  2010-08-19 14:18:03
This is obvious :-)The question is are there any potential clashes in the data when connecting through a 32bit ODBC driver to a 64Bit server?
bugmeister  2010-08-19 14:31:05
@bugmeister: The datatypes are fixed, an int is an int, a bit is a bit, a varchar is a varchar, the precisions(number of bytes used) are set when you establish your column definitions. They are unaffected by the bit width of the CPU
Neil N  2010-08-19 14:57:18
@bugmeister: I thought it was obvious too but you still asked :) There is no difference, clashes, etc that are possible... It's seamless regardless of the 32/64Bit combinations.
Fosco  2010-08-19 17:23:45

related questions

C++ SQLBindParameter
What Oracle driver should I install in my MS SQL server to be able to use DTS to copy data from the Oracle server to the MS SQL server?
Tool: ETL from an ODBC to SQL 05?
What is the simplest, most maintainable way to create a SQL Server ODBC Data Source?
How do I create a Jet ODBC link to a SQL Server view with periods in the field names?
Microsoft.ApplicationBlocks.Data.ODBCHelper ?
What are the access restrictions on accessing a DSN
.NET ODBC Connection Pooling
ODBC Connection Pool
what is the difference between OLE DB and ODBC data sources?
Reading a COBOL DAT file
Reverse Engineering for Database Diagramming in Visio with SQL Server 2008
How to programmatically configure an ODBC Datasource using C#
Best way to debug an ODBC driver on Windows
What is a Privileged instruction?
Control which columns become primary keys with Microsoft Access ODBC link to Oracle
How do you deal with NULL values in columns of type boolean in MS Access?
Using Rails 2.x with MS SQL Server 2005
C# ODBC Dialog
How do I get ms-access to connect to ms-sql as a different user?
How can I lock down my MS-SQL DB from my users and yet still access it through ODBC?
Using MySQL on Visual Studio 2008
Using MS Access & ODBC to connect to a remote PostgreSQL
Using Parameters in MS Reporting Services (SQL 2008) against an ODBC data source
Connect PHP to an AS/400