Thread: Approaching THB
View Single Post
 
Old September 25th, 2007, 04:38 AM
jimibt jimibt is offline
Friend of Wrox
 
Join Date: Mar 2007
Location: Creetown, UK
Posts: 488
Thanks: 2
Thanked 11 Times in 10 Posts
Default

Alex,

Just had a look at the default 'attach' method in the site generator and have found that it can encounter a small error when connecting and actually 'approximate' the database that it's trying to attach. anyway, best way to go about this is to go into SQLServer management studio express and attach the database from there. when it's attached, rename the attachment to a 'single' entity name (i.e. you may see it attached as c:\temp\data\mydatabase.mdf, so just rename this to anything you like, i.e. mydatabase). then open the site generator and in the DB Path/Name name box, type mydatabase (or whatever the name was that you decided upon in sqlmgt express) and check the integrated security box. now follow the steps as you had before and 'hopefully' you'll see the correct tables being shown.

i'll look into getting this error resolved as it looks like a pretty simple try/catch block that's gone awry in the attach code.

thanks for bringing it (unwittingly), to my attention.

jimi

http://www.originaltalent.com