Multiple ole db operations generate errors. If possible, check the status value of each ole db. No work is completed.
If you see this sentence, are you familiar with it? After you finish the information management system test, you can add all kinds of information. If you are not careful with this sentence, you will be able to run it. I checked a lot of information and found a particularly effective method, that is, to perform a small operation on the tables in our database.
1. Open the Enterprise Manager in SQL Server (MY NAME IS 2000)
2. Select the table with the problem,
3. Right-click and select "design table". In the displayed dialog box, you can modify the entries with errors ,:
4. Modify the data in the table according to our requirements. The above error is generally caused by improper data types and cross-border error, therefore, we have modified the data type and designed a proper length.
The problem is solved. before that, I checked a lot of information and did not find a very common and effective method. The result is that it is OK to easily change the database, so there are many things to learn, if you do not know the sentence, you will be afraid of not knowing it. If you know it, you will not be afraid of not knowing it!