Transfering SQL2005 DB To Hoster

Hi,

I've a problem that I haven't experienced before and need some help.  I've developed an app that works fine locally and have uploaded via FTP to my host provider - .NET 2 and SQL2005 Express.

I'm now getting problems accessing the site.  In the application load event I load a couple of application state items from the database.  When it hits the default aspx page, it throws an Object reference not set to an instance of an object. error because the application state items haven't been loaded.  The host then tried to load the database using SQL Management Express to ensure there wasn't a problem with the database and this is where I get confused.....

When they try to attach it, the message column n the "Attach Databases" screen says the file cannot be found.  In the "Current File Path" column, it points to the path of my local machine, i.e. H:SourceClubApp_Dataclub.mdf.  This leads me to believe that somewhere in the database the original file path is noted and used.  I can't find this and wondered if anyone has come accross this issue before??  The log file has been deleted.

Any help and advice appreciated.

Terry.