SQL SERVER Driver Error
-
When users attempt to connect to a web application with a SQL-Server back end,they are receiving the following error message:
[Microsoft OLE DB Provider for ODBC Drivers error '800004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Maximum number of databases that may be accessed by a transaction is 8. This number has been executed by this query.
Can someone assist me with why this error is occurring and what can be done to resolve it?
Thank you,
kaspr238
Denise Moffett
-
If you are running SQL 6.x then take a look at http://support.microsoft.com/default.aspx?scid=kb;EN-US;q225490
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
-
Antares686,
Thank you so much for responding! Question.
Will adding indexes help this situation at all? The DBA has asked for the exact worktable query that was used as well. Is this even necessary? The users are still unable to access the attached web application because of this problem. Can you pass on any tips for the DBA to use to expedite access to the web application?
Thanks!
Kaspr238
Denise Moffett
-
Indexes will not help if this is your situation. However I would let the DBA look over the query as he may be able to help find a simple solution. My personal belief if to move to SQL 7 or 2000 as they are so much more imporved than 6.x, but beyond that is find out how to optimize you query so that it doesn't reach this treshold.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply