Firehose mode error
Database
1
Posts
1
Posters
2
Views
1
Watching
-
I have an ASP page in which I am trying to start a transaction
var Conn = Server.CreateObject("ADODB.Connection"); Conn.Open("MyDB"); Conn.BeginTrans(); Conn.Execute("sp_InsertNew " + name);The stored proc, sp_InsertNew, as you would imagine just inserts a record into a table When I try this I get the error, "Transaction cannot start while in firehose mode." MSDN says this is a bug with SQL Server 2000 and the Enterprise Manager. The problem is I am trying this with an ASP page and ADO connection. Can anyone shed some light on this?