mike55 Posted October 11, 2004 Posted October 11, 2004 Hi all Am selecting data from multiple Access table and am then inserting that data into a SQL Server 2000 database. The total no. of records is :eek: 207,542 at the current time, but that will grow substantially as time goes on. Now to insert the data into the SQL Server database i am using a do while loop, its working grand till i get to records around the 32-33,000 mark where i get an the following error: "6 overflow" no i am using an int to keep track of what record number i am on, could it be the int is tool small and that i should be using a long??? Mike55. Quote A Client refers to the person who incurs the development cost. A Customer refers to the person that pays to use the product. ------ My software never has bugs. It just develops random features. (Mosabama vbforums.com)
kejpa Posted October 12, 2004 Posted October 12, 2004 Int and overflow at 32767?!? Are you using VB6? With .NET Integers are the old longs and don't get overflow until 4.2 billion. If you're using VB6 then you should be using Long instead of Int HTH /Kejpa Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.