Last post Dec 10, 2007 07:53 PM by MaineOne
Dec 10, 2007 07:16 PM|breaker77|LINK
Alright I have everything uploaded to my webhost and it almost works right. The problem I am having is with the users. I uploaded the personal.mdf to my hosts mssql database, but what do i need to do to get the aspnetdb.mdf with it? Since they are seperate
files on my local computer do they need to be seperate files on the host as well? If so I guess I'm out of luck as I can only have 1 mssql database.
If it matters, the webhost is godaddy.com which promotes the use of these start kits and even provides a detailed help page for uploading the time tracker kit.
Dec 10, 2007 07:48 PM|crf250guy|LINK
Your best bet is to upload the aspnetdb, then use the add-personal.sql script (in the kit) to add your "personal" database to the aspnetdb database.
Here is an aspx file you can run on your website (hosted version) to accomplish this: (Just fill in the missing pieces at connection string and file location and save as an aspx file)
cmd.CommandText = sb.ToString();
cmd.CommandTimeout = timeout;
Dec 10, 2007 07:53 PM|MaineOne|LINK
With GoDaddy you will need to combine the databases.
If you run aspnet_regsql, usually located C:\WINNT\Microsoft.NET\Framework\v2.0.50727, on your local personal.mdf it will put all the aspnetdb tables and Sp's ect. in it for you. you will then need to recreate your users and roles and reupload it to your