SQL Server 2000 application on SQL Server 2005

[Ian Lochray]

I have an application that uses SQL Server 2000 connecting via ODBC. Does anyone know if this application will run unchanged with SQL Server 2005? Do Microsoft support this kind of thing?

[Igor Karasik]

Ian, you can use ODBC with SQL 2005 server,
but nobody cannot tell you if application will run unchanged with SQL 2005. You must test it. SQL 2005 introduce SQL native client which contains SQL OLE DB provider and SQL ODBC driver in one native DLL.
Read this article as well:
http://support.microsoft.com/?kbid=910016
and
http://support.microsoft.com/?kbid=901039

[Ian Lochray]

I appreciate that I must test my application. I was more concerned with the general priciple of doing this. When I asked Oracle if they would support an application built with Oracle 8 running against Oracle 9 the answer was "no". I wanted to check that this was not the same with SQL Server.