I followed the article here http://www.kirupa.com/net/sql_asp_introduction.htm

everything compiles ok but when it get to opening the database I get error message
An attempt to attach an auto-named database for file C:\Path\Games.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share

I do not have any other databases with the same name and it is on the C drive so leads me to believe for some reason it can not open the database.

could someone please help me with this.