CODEWITHSUNDEEP
sql-serverasp-classic
David Smithers
David Smithers

Reputation: 2364

Queries work very slow with classic asp but fine with asp.net

I have a strange situation. We have a legacy classic asp application that uses sql server 2008 R2 in the background and asp.net application that uses the same database as previous one.

All queries from classic asp are painfully slow while queries from asp.net are working just fine. Same database, same user, same type of queries but classic asp is just very, very slow.

Any ideas what could cause this? Our server is Win 2008 R2, SQL Server 2008 R2, IIS 7.5. IIS and SQL Server are on the same machine.

Upvotes: 0

Views: 1293

Answers (1)

George Ober
George Ober

Reputation: 961

Try changing how you reference your instance. If you are referencing it as computer_name\instance or (local)\instance try updating server to 127.0.0.1.

You would also need to update your sql server networking settings in sql server configuration manager to enable sql server to work on this address.

Upvotes: 1

Related Questions