Trying to use the Visual Studio Data Source Configuration Wizard to connect to a SQL Server 2000 data base I am getting an error at the "Choose Your Database Objects' window that reads: An error occurred while retrieving the information from the database: Failed to retrieve data for this request. An exception occurred while executing a Transact-SQL statement or batch. Line 8: Incorrect syntax near '1'. There was no problem indicated when creating the data connection and the "test connection" button reported a successful connection. The is also a problem on this system, however, with the Visual Studio 2005 SP1 update. It repeatedly fails. Any help resolving these problems would be most appreciated. All the best, will -- William F. Zachmann Canopus Research Inc. http://www.canopusresearch.com
