none
.NET Framework 1.1 can talk to SQL server 2008 ? RRS feed

  • Question

  • We have an existing application (.NET Framework 1.1) talking to SQL 2000. I was trying to determine if we can make it talk to SQL 2008. SQL server 2008 is on windows 2008 operating system.
    • Moved by Bob Beauchemin Tuesday, February 12, 2013 11:43 PM Moved to the forum for SqlClient code for best response
    Tuesday, February 12, 2013 6:33 PM

Answers

  • Microsoft supports .Net 1.1 SP1 on Windows 2008. .Net 1.1 code should work after alter database set compatibility_level, and probably would work before that if you do not hit one of the behavior changes that needs a compatibility_level setting.

    Note support for .Net 1.1 Sp1 ends this year. Upgrading your .Net version should be in your plan now.



    Visual C++ MVP

    Wednesday, February 13, 2013 1:15 AM

All replies

  • Hello,

    Which data access component are you using, is it Ado.Net? If so, then it will work, only new data types like spatial could cause problems; but when you move your database from 2000 to 2008, then you won't have this requirement & issue.


    Olaf Helper

    Blog Xing

    Tuesday, February 12, 2013 6:53 PM
  • Thanks..yes we  are using  ADO.Net by importing System.Data.SqlClient into page.  if database 2008 is hosted on windows 2008 operation system then it will be any problem?
    Tuesday, February 12, 2013 8:48 PM
  • Microsoft supports .Net 1.1 SP1 on Windows 2008. .Net 1.1 code should work after alter database set compatibility_level, and probably would work before that if you do not hit one of the behavior changes that needs a compatibility_level setting.

    Note support for .Net 1.1 Sp1 ends this year. Upgrading your .Net version should be in your plan now.



    Visual C++ MVP

    Wednesday, February 13, 2013 1:15 AM
  • if database 2008 is hosted on windows 2008 operation system then it will be any problem?

    The OS of the server doesn't matter for the clients in any way, that's transparent for them. You only have to check, if the OS is supported for your SQL Server version.

    Olaf Helper

    Blog Xing

    Wednesday, February 13, 2013 5:22 AM