try /casa1

That's what it's set as right now. I've tried every combination of /WebDev and /WebDev/casa1 and /WebDev/casa1/ etc... Not sure what the issue is. Thanks anyway.

try jut / keep trying

Following is the same post I made to "Still having issues"...

I'm currently having the same problem with the web parts not displaying the rss, but only on the remote host.

I WAS having the same problem running the site on IIS. I solved the problem by updating two entries in the second row of table dbo.aspnet_Applications, under the columns ApplicationName and LoweredApplicationName, to be the same as the name of the folder containing my website under C:\Inetpub\wwwroot\jgk. I changed the entries to JGK and jgk respectively, went to "http://localhost/jgk", and now it works great on IIS.

Using the same approach on the remote server hasn't solved the problem. If I figure it out, I'll be back...

I didn't make a change to aspnet_Applications, but I do see a root dir entry there. My original DB from the code download also has that entry.

You can look at my site and see if you can find a problem. I haven't checked all aspects of it, but it seems to work:
http://www.ericengler.com

How did you populate the tables in your remote DB? I wrote a program to do this so it would keep the identity values to preserve referrential integrity. See my last post here:
http://p2p.wrox.com/topic.asp?TOPIC_ID=46088

I couldn't find a way to make SQL Server Management Studio copy the data verbatim because of the bug it has with identity columns. I don't know if they ever fixed the bug.

Eric

Thanks for your reponse!

Yeah, I just followed Marco's algorithm starting on p531, and checked the "Enable identity insert" box for each table.

But you say there's a bug, and I see you've done your homework. I did not verify any identity values to see if there was a one-to-one transfer, but it sounds certain there was not. I'll reset the database, and try the copy once again to verify the identity values for myself. I've gotten to where I can do this pretty fast.

I'm using SSMS 9.00.2047.00, and my host provides me one SQL Server 2005 database. Sounds like the SSMS bug has never been fixed, but I'll looks for patches at Microsoft.

I just read all your posts in "http://p2p.wrox.com/topic.asp?TOPIC_ID=46088" (sorry I missed them earlier), and I'll take a little time digesting them, but it looks like you've created a good workaround to the bug, which I will try tomorrow.

I started a new discussion earlier today at http://p2p.wrox.com/topic.asp?TOPIC_ID=51574, about my Rss web parts still not getting displayed on the homepage, in an attempt to re-energize that discussion, before I read your most recent post. I will try your copy-script first. I suppose when identity values are not getting copied correctly, it's almost certain that something will be broken.

Thanks for the input!

P.S.

The URL where you can see the missing Rss web parts is http://www.jgkarate.ewdtestsite.com/

I'm trying to use your program, at http://www.ericengler.com/downloads/...bleData.cs.txt, running it in Visual C#, but I can't connect to either the local or remote database.

I first emptied the remote database running Marco's DeleteAllData.sql script.

I then built and tried to run the program in Visual Studio, and can't connect to my local DB.

My connection string must be wrong, and I've been struggling with this all day.

Connection strings seem to be science of their own. I have looked alot at the .NET Class Framework library, and other sources online, but I guess I don't understand connection strings yet. Can you suggest any sources for a plain English explanation?

Your target database connection string is:
cnSrc.ConnectionString = @"integrated security=SSPI;data source=.\SQLEXPRESS;initial catalog=TheBeerHouse"

For the part of your connection string "initial catalog=TheBeerHouse", is "TheBeerHouse" what you renamed ASPNETDB.MDF to in SSMS?

I assume "TheBeerHouse" actually represents an absolute path to the database.

How exactly did you do that?

No matter what I set "initial catalog=" equal to, the program can't seem to find the database. Putting the absolute pathname in the string doesn't work.

"TheBeerHouse" is the name of the DB inside Sql Server. ".\SQLEXPRESS" is the named instance of Sql Server Express that installs with VS 2005.

Please read the deployment chapter about how to attach the MDF to your DB. Once this is done you need to create the user account, also discussed in that chapter. Some of this is also in the readme.