32-bit app connectivity to 64-bit SQL2K5

Question

Is there any reason why an application running on a 32-bit O/S that works with a SQL Server 2K database would not work with a SQL Server 2K5 64-bit database running on a 64-bit O/S?

 

It is my understanding that the connection layer (be it ODBC, OLEDB, ADODB, etc) would obfuscate any details regarding the underlying architecture... I wouldn't think the instructions sent would need to be any different, unless there is some deprecated call that is no longer supported.

 

Thanks in advance for any assistance!

Answer 1

 

have you run the profiler to see what happens when it connects?

Answer 2

This is a hypothetical question... I have no logs, errors, etc.

Answer 3

Check out this thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3188766&SiteID=1

 

Let us know if your question was answered.

 

Answer 4

Yes - that answers the concerns of our DBAs. =)