SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-09-2008, 01:37 PM
| ||||
| ||||
 ODBC Recordset limits Hello, Is there a limit to the size of a recordset connected via ODBC? I have a table with 160,000 records which I need to pass one by one (slow upgrade). I opened a recordset using C++ CRecordset class and was able to receive 11000 records before getting an error of ODBC error 100 SQL_NO_DATA. Thanks, Reuven      |
|
03-10-2008, 04:55 PM
| |||
| |||
| RE: ODBC Recordset limits Hi Reuven, From my research, this seems to be a known issue. This issue may occur if you are trying to change a record while the another connection holds the record. I recommend that you first refer to the following old post to see if the issue was same as yours and if the workaround can help you: http://groups.google.com/group/micro.../browse_thread /thread/3aa35029fa4c6f44/55e4d040537f6131?hl=en&lnk=st&q=Exception+error+SQ L _NO_DATA+when+data+on+server+changed#55e4d040537f6 131 If you have any other questions or concerns, please feel free to let me know. Have a nice day! Best regards, Charles Wang Microsoft Online Community Support ================================================== ========= Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: msdnmg@microsoft.com. ================================================== ========= Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ult.aspx#notif ications. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscripti...t/default.aspx. ================================================== ========== This posting is provided "AS IS" with no warranties, and confers no rights. ================================================== ======= |
|
03-17-2008, 06:12 AM
| |||
| |||
| Re: ODBC Recordset limits Hi Reuven, Thanks for your response. Regarding SQL_NO_DATA, This article, http://msdn2.microsoft.com/en-us/lib...13(VS.85).aspx, does not say it very clearly. I also found some description regarding SQL_NO_DATA in getting long data: Getting Long Data http://msdn2.microsoft.com/en-us/lib...26(VS.85).aspx However it is for ODBC API, not for CRecordset. To track the root cause of this issue, we may need to reproduce your issue and perform some debugging. If this issue can be easily reproduced at your side in a separated machine, could you please mail me (changliw_at_microsoft_dot_com) your sample project and your test database for further research? You may just import the specific table to a test database, then backup the database and send it to me. Appreciate your understanding that for such kind of issue, without reproducing your issue and performing some debugging, it is hard for us to perform effective research. If this issue is not easily reproduced, to track the root cause, some advanced troubleshooting technologies would be required and I recommend that you contact Microsoft Customer Support Services (CSS) via telephone so that a dedicated Support Professional can assist you in a more efficient manner. Please be advised that contacting phone support will be a charged call. To obtain the phone numbers for specific technology request please take a look at the web site listed below. http://support.microsoft.com/default...S;PHONENUMBERS If you are outside the US please see http://support.microsoft.com for regional support phone numbers. If you have any other questions or concerns, please feel free to let me know. It is my pleasure to be of assistance. Best regards, Charles Wang Microsoft Online Community Support ================================================== ========= Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: msdnmg@microsoft.com. ================================================== ========= Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ult.aspx#notif ications. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscripti...t/default.aspx. ================================================== ========== This posting is provided "AS IS" with no warranties, and confers no rights. ================================================== ======= |
|
03-17-2008, 06:12 AM
| |||
| |||
| Re: ODBC Recordset limits Hi Charles, Unfortunately, we are talking about a customer database and I can not pass it on. The problem is not easy to produce anyway. I can however, run a debug version of my program and wait for the problem to occur. Maybe you could direct me, what to look for when the problem occurs? Thanks, Reuven |
|
03-17-2008, 06:12 AM
| |||
| |||
| Re: ODBC Recordset limits Hi Charles, Unfortunately, we are talking about a customer database and I can not pass it on. The problem is not easy to produce anyway. I can however, run a debug version of my program and wait for the problem to occur. Maybe you could direct me, what to look for when the problem occurs? Thanks, Reuven |
|
03-17-2008, 06:12 AM
| ||||
| ||||
| Re: ODBC Recordset limits Hi Reuven, I am not sure if you can get enough information by just running your debug version application. To track the root cause of this issue, you may need other debugging methods. I would like to recommend an article for your reference: Application debugging in a production environment http://www.microsoft.com/belux/msdn/...5_applicationd ebugging.mspx Please feel free to let me know if you have any other questions or concerns. Have a nice day! Best regards, Charles Wang Microsoft Online Community Support ================================================== ======= Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: msdnmg@microsoft.com. ================================================== ======= This posting is provided "AS IS" with no warranties, and confers no rights. ================================================== ======= |
Linear Mode
