SQL Server 7.0 to SQL Server 2000greenspun.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
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