January 7, 2002 at 3:36 am
Every couple of weeks we get the following error and was wondering anyone knew how we can eliminate it.
Microsoft OLE DB Provider for SQL Server error '80004005'
Cannot create new connection because in manual or distributed transaction mode.
January 7, 2002 at 10:10 am
Is this in the SQL log or on the client? Also, what OS, Service Pack, MDAC versions?
Haven't seen it.
Steve Jones
January 8, 2002 at 2:19 am
Sorry for not providing that information.
1. On the client not the log
2. 2.6
3. NT IIS4.0 All Patched
January 8, 2002 at 5:06 am
Try this, it suggests that the ado connection might still be busy when you're trying to access it:
If you dim your connection using withevents you can probably see whats going on better to prove/disprove this idea.
Andy
January 8, 2002 at 5:49 am
Andy
I'm sorry, I am a novice dealing with all of this. How do I dim the connection using withevents.
David
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply