Posted on 2011-10-03
I need to roll out a 64-bit SQL Server 2008 R2 box in the next couple of months. And I have some questions that are really, really basic.
1. I have ASP.NET apps (VS.NET 2008) that run on a (32-bit) Windows Server 2003 machine. What changes will have to be made to these ASP.NET apps to allow them to write to my new box?
2. I have third-party applications on (32-bit) Windows Server 2003 boxes that employ ODBC DSNs to write to SQL. What will I need to do in order to make this work with a new DSN that points to my 64-bit SQL box?
I ask these goofy questions because, to me, nothing *should* have to be done. For instance, I get that if my app is 64-bit, it would need to use a DSN in the 64-bit ODBC admin. But it's only the target database that's going 64-bit. But I'm sure I'm totally wrong.
Thanks for your help.