Data connection problem with numeric DB name
Attempting to add a new data connection in VS2005 ... I can add the connection, and expand the tables node in the server explorer without a problem ... but when I attempt to expand stored procs or the other two nodes, I get the following error:
Failed to retrieve data for this request.
An exception occurred while executing a Transact-SQL statement or batch.
Line 9: Incorrect syntax near '1'.
The DB name happens to be [dbname]1. When connecting to a DB without a numeral in the name, I have no difficulties whatsoever, so I'm working based on the assumption that the numeral in the DB name is causing the problem. I don't have the option of renaming my data source ... is there another way of fixing this?
thanks ...

