Imar,

I purchased your book for several reasons one being; I love the Bugbase program found in Chapter 12. My problem is establishing the Bugbase database on a SQL 2005 Server. I have a website where the website is on one server and I have a data area on a SQL Server. Trying to install the database has been a total nightmare. I have SQL Server 2005 express edition, I also have Aqua data studio database query tool. My database is setup as a customer number such as 666594_default on the SQL Server, I am only allowed one database, I can’t establish another Bugbase database. Ok, no problem I will just copy everything from the Bugbase.mdf to 666594_database. I used Aqua data studio to create a SQL program that would replicate the tables and so forth. I then executed the SQL program on the 66654_default database, which produced all the tables and everything else. So, here’s where I got into some problems, I am trying to import data into the tables. On must tables I was able to use SQL Server 2005 express to copy the records from a local SQL mount of Bugbase database and using the edit copy command and then going over to the same table on the 66594_default database and pasting the records. Sometimes it would work others times it does not. Not sure why not. I have successfully copied all the data from the tables except for 4. It’s these 4 databases that are giving me a problem. I tried to get my ISP to install the database but they refuse to. I wish I had SQL Server 2005 so I could do this with a few commands, but I don’t. Can you give me any words of wisdom on how I can establish or even restore the BugBase.MDF to 666594_Default?

Tony...

Hi Tony,

Really glad to hear you like the BugBase application. Hopefully, you can sort things out ASAP.

Words of wisdom..... I don't know. I do have a pointer to a great tool that will do exactly what you need, instead, if that's OK? ;)

http://weblogs.asp.net/scottgu/archi...nt-part-1.aspx

http://www.codeplex.com/sqlhost/Wiki...shing%20Wizard

Once you install the tool, follow the article by Scott Guthrie. You'll end up with a .sql file that you *should* be able to run at your ISP. If it doesn't because they don't allow it, you can always try to execute it through an ASPX page.

Please let me know if this works for you.

Cheers,

Imar

Your solution worked like a champ, thanks again.

I had one other problem I solved but thought I should mention here for the sake of people who might be having the same problems. I used only the default code of the book and found out it works only with ASP.NET 1.1. Most ISP servers are setup for ASP.NET 2.0 as the default. It took a while before I solved this one, but a simple download from this website updated the code and the web.config so that it works with ASP.NET 2.0 fixed the problem.

Tony...

It works only with 1.1????? That's impossible.

There's loads of Generics in this Chapter (and in the entire book) which didn't exist pre .NET 2.

It's a 2.0 book, requires IIS to run under ASP.NET 2.0 and none of the examples will run under 1.x, AFAIK.

What "simple download from this website updated the code and the web.config so that it works with ASP.NET 2.0" are you referring to? Do you mean the updated scripts and databases from the errata section and other forum posts?

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

Hi Tony,

Would you mind commenting on this? How did you end up running the site?

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004