Brothers have recently been trapped by this problem, and finally finally solved!
1. When you connect the database, you may have an error. Check if the ConnectString this sentence, write correct, or put him into connectString = "file name = The path of the DNS you save". Note that in the ODBC source to select DNS files Oh!
2. Is your SQL statement written correctly, check the method to put your statement in the query analyzer in SQL Server to run, see if there is any problem! If you have any questions, change it!