Work Around Errors in Database Web Apps

ne of the issues you face when building Web applications is handling the errors you encounter when interacting with a back-end database. I was recently working with someone to create a new Web site with SQL Server™, ActiveX® Data Objects (ADO), and ASP. Lots of little things came up that I thought were worth sharing with MIND readers, so I'll focus this column on what I learned from this experience and the solutions to many of the problems I faced.

Quarter of a Century Competition on P2P

P2P, the programmer's resource centre from Wrox Press, reached a milestone of 25,000 subscribers this week. To celebrate this fact, Wrox are giving away $1000 worth of books and ASPToday subscriptions in a free prize draw. For more details on how to enter, please visit: http://p2p.wrox.com/25k.asp. The draw will be made on July 16th.

Blogs

How to Think Like a Certification Exam at the PASS Professional Development Virtual Group

By

Thanks for the 90+ who joined today's PASS Professional Development Virtual Group webinar on...

Deploy BACPAC to Azure Managed Instance failing from SSMS?

By

Recently I ran into an error when trying to copy a small database bacpac...

Daily Coping–3 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Read the latest Blogs

Forums

Replacing / Removing All Text In Multiple Sets of Characters in SQL

By mnovosel

One of the result fields has multiple html references in it such as in...

steps testing and moving workloads from SQL Server 2014 to SQL Server 2019

By sqlguy80

Hello, SQL Server Gurus, Can any one please suggest  steps regarding performance testing all workloads...

Causes for The query processor could not produce a query plan

By YSLGuru

SQL Server 2016 (13.0.5598.27) The first version of the below query produces results while...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers