Sunday, March 25, 2012

32bit SQL Server on Win2003 64bit server?

Does this work? Without an ODBC connector (MSDASQL) for the 64 bit version
I'm stuck downgrading to be able to access data from some appliances the use
MySQL. If I can get away with only moving to a 32bit version of SQL Server
that will save me quite a bit of time...
Regards.
If I understand your question properly then yes you can run the 32 bit
version of SQL Server on an X64 bit OS. If you are talking about true 64bit
(Itanium) then no you cant.
Andrew J. Kelly SQL MVP
"kstjohn" <kstjohn@.discussions.microsoft.com> wrote in message
news:9799848E-BFB2-4084-A196-C01FFAF4A83D@.microsoft.com...
> Does this work? Without an ODBC connector (MSDASQL) for the 64 bit version
> I'm stuck downgrading to be able to access data from some appliances the
> use
> MySQL. If I can get away with only moving to a 32bit version of SQL Server
> that will save me quite a bit of time...
> Regards.
|||Hi
"kstjohn" wrote:

> Does this work? Without an ODBC connector (MSDASQL) for the 64 bit version
> I'm stuck downgrading to be able to access data from some appliances the use
> MySQL. If I can get away with only moving to a 32bit version of SQL Server
> that will save me quite a bit of time...
> Regards.
A 32 bit ODBC driver will connect to a 64 bit version of SQL 2005 but it is
not clear which machines you are connecting from! On 64 bit windows you may
find the 32 bit ODBC administrator at c:\windows\syswow64\odbcad32.exe
John
sql

No comments:

Post a Comment