SQL Server 7.0 to SQL Server 2000

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hi, I have eight ASP applications running in IIS Server and each of them has SQL Server 7.0 as their database. I want to upgrade from SQL Server 7.0 to SQL Server 2000. In that case what would be the necessary changes that I should make in existing asp applications ??? It would be a great help in any one can kindly answer this issue. Regards, Indranil

-- Anonymous, October 11, 2004

Answers

Indranil,

Regarding DSNLess connections and connections in general, unless you are developing against a "named instance" of SQL 2000, your connection strings should be no different.

Some users have reported that the date formats could get changed because of the upgrade. Double check the regional settings on the server to see what date formats are being used on it.

Hope this helps,

Eric

-- Anonymous, October 11, 2004


Moderation questions? read the FAQ