You searched for the word(s): userid:618719

More Search Options

RSS Available

• Re: URGENT HELP!

  I published my site on my computer using the localhost before I published my site to a host computer. You must check your host computer to see which sql server they are using sql2000, or sql2005. There are serveral post on how to setup your database using sql2005. I switched to sql2005, setup a new database and then use my localhost to test the new database. After I loaded up my new database with pictures I ftped all the files to the host computer. They copied all tables, stored procedure, etc to

  Posted to Personal Site Starter Kit (Forum) by DesertRacer on 10/18/2006

• Re: Setup on existing SQL Server 2005

  MS had a offer for a free vs2005 if you watched 3 web cast. I saw the offer last month I think

  Posted to Personal Site Starter Kit (Forum) by DesertRacer on 10/10/2006

• Re: Setup on existing SQL Server 2005

  If you are using VS2005 you can use the Server Explorer to add a database. The explorer will figure out the connection string for you.

  Posted to Personal Site Starter Kit (Forum) by DesertRacer on 10/10/2006

• Re: Yet Another: Cannot open user default database. Login failed.

  If your web site works from vs2005 and then when you set it up to use the localhost it fails you have a problem with permissions. vs2005 set the permissions so everything works but vs2005 does not let you see what permission are being set. I am using vs2005, w2k3, and sql2005. My site works from vs2005 but from iis6.0, localhost I got login fail errors for nt authority\network service . I fixed the problem by set permissions for nt authority\network service using SQL Server Management Studio Setting

  Posted to Personal Site Starter Kit (Forum) by DesertRacer on 7/25/2006

• Re: One Database

  any name will do, the default name is aspnetdb.mdf but it is better to use a new name in case you start another web you must have two connection string but they both point to the same data base my server name is ECON and my database is Kendallweb.mdf Your code refers to LocalSqlServer and Personal If you are using VS2005 you can use the server explorer to setup and test your connection strings <connectionStrings> <clear/> <add name="LocalSqlServer" connectionString="Server=ECON;Database

  Posted to Personal Site Starter Kit (Forum) by DesertRacer on 6/12/2006

• Re: One Database

  You must have sql2000 installed on your computer. there are two main steps Use aspnet_regsql.exe to create a database for you, give it a new name, mydatabase.mbf. you will find the database in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data You now must run personal-add.sql on your new database. I used server management studio for this operation you can use server explorer to look at the tables in you new data base. correct your connection strings to point to the new database and run your

  Posted to Personal Site Starter Kit (Forum) by DesertRacer on 6/10/2006

• Re: Personal Web Site Starter Kit - Win2k3 Hosting issue

  On my win2k3 machine I made a virtual directory then link it to my published directory (where you place your web files) instead of http://192.168.0.1/Default.aspx You would used http://192.168.0.1/virtual_directory/Default.aspx For testing I used http://localhost/homesite/ after I got it working on localhost I then uploaded to my host site Not sure if this is your problem but I was easy to get the web working on the localhost

  Posted to Personal Site Starter Kit (Forum) by DesertRacer on 5/19/2006

• Re: @AlbumID is not a parameter for procedure EditAlbum.

  I had trouble finding the original PhotoManager code. I have changed my version to handle random photos quickly. The problem was the name used for the AlbumID needs to be changed from original_AlbumID to AlbumID. original EditAlbum public void EditAlbum( string Caption, bool IsPublic, int original_AlbumID ) { using ( SqlConnection connection = new SqlConnection( ConfigurationManager.ConnectionStrings[ "Personal" ].ConnectionString ) ) { connection.Open(); SqlCommand command = new SqlCommand(); command

  Posted to Personal Site Starter Kit (Forum) by DesertRacer on 5/15/2006

• Re: @AlbumID is not a parameter for procedure EditAlbum.

  the stored procedures look the same as mine. I might have changed the c# code I will check next week. I do not remenber what i did but it was quite simple and only took 10 minutes

  Posted to Personal Site Starter Kit (Forum) by DesertRacer on 5/11/2006

• Re: @AlbumID is not a parameter for procedure EditAlbum.

  I had the same problem. I had to fix my stored procedures. I will have to check the original to see what I changed. Here is a listing of what I am using listing of edit Album ALTER PROCEDURE EditAlbum @Caption nvarchar(50), @IsPublic bit, @AlbumID int AS UPDATE [Albums] SET [Caption] = @Caption, [IsPublic] = @IsPublic WHERE [AlbumID] = @AlbumID RETURN listing of edit photo ALTER PROCEDURE EditPhoto @Caption nvarchar(50), @PhotoID int AS UPDATE [Photos] SET [Caption] = @Caption WHERE [PhotoID] =

  Posted to Personal Site Starter Kit (Forum) by DesertRacer on 5/10/2006