testing123
02-12-2004, 06:04 AM
Dear friends,
I am desperately in need of help.I shall proceed to give you a clue on the nature of my work.I am continuing and maintaing code designed by my predecessor.It contains a number of class modules , form modules and 2 standard modules.So much for the superficiality , I will tell you what it is supposed to do .It was taking the contents of an Access database and putting it (it=records from a particular table) into a (central) SQL Server.
Now it has to take it from local SQL Servers and put it(it=records from a particular table) into the Central SQL Server.
MY error is
Cannot create new transaction because capacity was exceeded.,0,Microsoft OLE DB Provider for SQL Server,-2147168227
Not able to connect to the Server.
Please forget the 'Not able to connect to the Server.' , what I am worried about is :
Cannot create new transaction because capacity was exceeded.,0,Microsoft OLE DB Provider for SQL Server,-2147168227
I found one reply on http://dbforums.com/t551665.html
where primarily the reply is :
1. Try setting the Cursor Location to adUseClient.
2. try to lessen the number of recordsets using the same connection.
3. try to close and then set to nothing all of ur open recordset before u unload form
2 and 3 are from same person.
But I can tell you as far as I saw from my code , 2 is irrelevant.
I also thought up a a reply of my own :
4. Connection objects unclosed or recursively opened. : This is trickier than closing the recordsets as you all can imagine , because where I close one Private connection object , it might show up as an error from another code snippet that calls this class and depends on the object being open ! But this one is obvious.
Also the code that throws the error I mentioned is similar to the one pasted in the URL I have pasted here.Still none of theor solutions worked.
Please help.
Regards,
SK
I am desperately in need of help.I shall proceed to give you a clue on the nature of my work.I am continuing and maintaing code designed by my predecessor.It contains a number of class modules , form modules and 2 standard modules.So much for the superficiality , I will tell you what it is supposed to do .It was taking the contents of an Access database and putting it (it=records from a particular table) into a (central) SQL Server.
Now it has to take it from local SQL Servers and put it(it=records from a particular table) into the Central SQL Server.
MY error is
Cannot create new transaction because capacity was exceeded.,0,Microsoft OLE DB Provider for SQL Server,-2147168227
Not able to connect to the Server.
Please forget the 'Not able to connect to the Server.' , what I am worried about is :
Cannot create new transaction because capacity was exceeded.,0,Microsoft OLE DB Provider for SQL Server,-2147168227
I found one reply on http://dbforums.com/t551665.html
where primarily the reply is :
1. Try setting the Cursor Location to adUseClient.
2. try to lessen the number of recordsets using the same connection.
3. try to close and then set to nothing all of ur open recordset before u unload form
2 and 3 are from same person.
But I can tell you as far as I saw from my code , 2 is irrelevant.
I also thought up a a reply of my own :
4. Connection objects unclosed or recursively opened. : This is trickier than closing the recordsets as you all can imagine , because where I close one Private connection object , it might show up as an error from another code snippet that calls this class and depends on the object being open ! But this one is obvious.
Also the code that throws the error I mentioned is similar to the one pasted in the URL I have pasted here.Still none of theor solutions worked.
Please help.
Regards,
SK