The attached code worked under Windows 2003, IIS6, but my hosting company has had to upgrade to Windows 2008, IIS7. Now I get this error:
Microsoft OLE DB Provider for SQL Server error '80040e4d'
Invalid authorization specification
/database/add_visit.asp, line 197
Line 197 is where it tries to execute the insert. All my other pages work, but they only perform reads, this page performs an insert. Well, it used to...