Problems with Access, transact SQL & Win 2003 SP1?

[LucyP]

I have a script which uses transact sql with an access database. The script has stopped working online, and the host says the only change they have made is to upgrade to Windows 2003 SP1.

It is definately the transact SQL which is causing the problem: I have just uploaded a test script which just has a line of test code and the declaration:
<%@ TRANSACTION=Required LANGUAGE="VBScript" %>

Not only does the script fail, but it doesn't even give me a proper error message.

Is this a bug in sp1 or is there something I can do about it?

 

[jrbarnett]

What was the host running before it was upgraded?

John

 

[LucyP]

Windows 2003 - they just service-packed it.

NB all I really need to know is if there's an inherent bug with transact SQL and SP1, or if the host has messed up. If anyone would care to put the above lang declaration in any asp page on a win 2003 SP1 machine and let me know if it works or not I would be most grateful.