SQL Server 2005 x64 Not Supported 1

[fuzzyocelot]

Hello!

We're in the process of migrating to SQL Server 2005 x64 Enterprise from SQL Server 2000 x86. None of the applications run on the database server. Everything connects remotely to the databases. We have a vendor that says their application supports SQL Server 2005 but "the 64-bit version of the Microsoft SQL Server is currently not supported." Does this make sense? I can understand if the application runs on the same server as the SQL Server but it doesn't. It's on a separate server. Can anyone please shed some light on why an application would support SQL Server 2005 but not 64-bit if it's on a separate server?

Thanks!

 

[ptheriault]

It's up to the vendor to decide if their application will support 64 bit or not. They could be using CLR or other objects that require interaction with OS dlls. For example We have melissa data here and it won't work on 64 bit.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[SQLDenis]

Yep, some stuff won't work on 64 bit. IIRC then FoxPro won't work because there is no 64 bit driver

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[fuzzyocelot]

Thanks for replying! I forgot about CLR and objects that interact with dlls on the database server. The fact that the application runs on a separate server was the issue that confused me. I guess we'll have to put their database on our stand-by 32-bit server.

Thanks!