I have installed the starter kit and understand that it uses SQL Server Express 2005, but my web provider uses SQL Server 2000. I have created the database manually with the web provider, but am having issues running the site. I had to cut out alot of the
code in the SetupDatabase.sql file so maybe that is the problem. Has anyone had any success doing this? I read about some people using the DTS tool to export the data, but I don't have the full version of SQL Server 2005. I also can use MySql with my webhost
so if someone can point me in the right direction that way would work too.
You can downlod the Evaluation version of MS SQL 2000(http://www.microsoft.com/downloads/details.aspx?FamilyID=D20BA6E1-F44C-4781-A6BB-F60E02DC1335&displaylang=en) .You can the Enterpise manager along which doesnt expire.Doesnt; your web provider have any
kind of an interface to attach the mdf directly?Well,we do provide our customers with a SQL Tool Suite,which makes things pretty simple.
Creating the schema manually might cause issues because you may have missed something out .You can always go with the xmlprovider .
GoDaddy is my provider and I haven't found a way to attach the mdf. I guess I can call their tech support and see. I really want to use the database portion so I can create an admin interface to it.
I know its been a year since this was posted but in searching for a solution, there are only two hits I could find and this was one. Maybe someone else could use this...
I ran into the same issue with my provider using SQL 2000. However, I have SQL 2005 locally so I ran the script there and then re-scripted out the database using SQL 2000 settings.
Here is the updated script for SQL 2000.
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Item]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Item](
[id] [nvarchar](32) NOT NULL,
[visible] [bit] NOT NULL,
[title] [nvarchar](256) NOT NULL,
[description] [nvarchar](2048) NULL,
[price] [float] NULL,
[inStock] [bit] NULL,
[imageUrl] [nvarchar](256) NULL,
[imageAltText] [nvarchar](256) NULL,
[displayOrder] [int] NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Testimonials]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Testimonials](
[id] [nvarchar](32) NOT NULL,
[visible] [bit] NOT NULL,
[title] [nvarchar](256) NOT NULL,
[date] [datetime] NOT NULL,
[content] [nvarchar](1024) NULL,
[testifier] [nvarchar](256) NULL,
[testifierTitle] [nvarchar](256) NULL,
[testifierCompany] [nvarchar](256) NULL,
[imageUrl] [nvarchar](256) NULL,
[imageAltText] [nvarchar](256) NULL,
[displayOrder] [int] NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[News]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [News](
[id] [nvarchar](32) NOT NULL,
[visible] [bit] NOT NULL,
[title] [nvarchar](256) NOT NULL,
[date] [datetime] NOT NULL,
[content] [nvarchar](4000) NULL,
[imageUrl] [nvarchar](256) NULL,
[imageAltText] [nvarchar](256) NULL,
[displayOrder] [int] NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[People]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [People](
[id] [nvarchar](32) NOT NULL,
[visible] [bit] NOT NULL,
[firstName] [nvarchar](64) NOT NULL,
[middleName] [nvarchar](64) NULL,
[lastName] [nvarchar](64) NOT NULL,
[title] [nvarchar](128) NULL,
[description] [nvarchar](2048) NULL,
[email] [nvarchar](256) NULL,
[phone] [nvarchar](64) NULL,
[fax] [nvarchar](64) NULL,
[streetAddress] [nvarchar](128) NULL,
[city] [nvarchar](128) NULL,
[state] [nvarchar](64) NULL,
[postalCode] [nvarchar](64) NULL,
[country] [nvarchar](64) NULL,
[imageUrl] [nvarchar](256) NULL,
[imageAltText] [nvarchar](256) NULL,
[displayOrder] [int] NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Category]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Category](
[id] [nvarchar](32) NOT NULL,
[visible] [bit] NOT NULL,
[title] [nvarchar](256) NULL,
[description] [nvarchar](2048) NULL,
[imageUrl] [nvarchar](256) NULL,
[imageAltText] [nvarchar](256) NULL,
[parentCategoryId] [nvarchar](32) NULL,
[displayOrder] [int] NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Categorization]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Categorization](
[itemId] [nvarchar](32) NOT NULL,
[parentCategoryId] [nvarchar](32) NOT NULL,
PRIMARY KEY CLUSTERED
(
[itemId] ASC,
[parentCategoryId] ASC
) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[GetChildItems]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [GetChildItems] @categoryId nvarchar(32) AS SELECT Item.id, Item.visible, Item.title, Item.description, Item.price, Item.inStock, Item.imageUrl, Item.imageAltText FROM Item INNER JOIN Categorization ON Item.id = Categorization.itemId WHERE (Categorization.parentCategoryId = @categoryId)'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[GetItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [GetItem] @itemId nvarchar(32) AS SELECT Item.id, Item.visible, Item.title, Item.description, Item.price, Item.inStock, Item.imageUrl, Item.imageAltText FROM Item WHERE (Item.id = @itemId)'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[GetTestimonials]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [GetTestimonials] AS SELECT id, visible, title, date, [content], testifier, testifierTitle, testifierCompany, imageUrl, imageAltText FROM Testimonials ORDER BY displayOrder'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[GetNewsItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [GetNewsItem] @id nvarchar(32) AS SELECT id, visible, title, date, [content], imageUrl, imageAltText FROM News WHERE (id = @id)'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[GetNews]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [GetNews] AS SELECT id, visible, title, date, [content], imageUrl, imageAltText FROM News ORDER BY date DESC'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[GetPeople]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [GetPeople] AS SELECT id, visible, firstName, middleName, lastName, title, description, email, phone, fax, streetAddress, city, state, postalCode, country, imageUrl, imageAltText FROM People ORDER BY displayOrder'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[GetRootCategories]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [GetRootCategories] AS SELECT id, visible, title, description, imageUrl, imageAltText, parentCategoryId FROM Category WHERE (parentCategoryId IS NULL)'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[GetNonRootCategories]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [GetNonRootCategories] @categoryId nvarchar(32) AS SELECT id, visible, title, description, imageUrl, imageAltText, parentCategoryId FROM Category WHERE (parentCategoryId = @categoryId)'
END
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[FK__Categoriz__itemI__0F975522]') AND type = 'F')
ALTER TABLE [Categorization] WITH CHECK ADD FOREIGN KEY([itemId])
REFERENCES [Item] ([id])
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[FK__Categoriz__paren__108B795B]') AND type = 'F')
ALTER TABLE [Categorization] WITH CHECK ADD FOREIGN KEY([parentCategoryId])
REFERENCES [Category] ([id])
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[FK__Category__parent__0EA330E9]') AND type = 'F')
ALTER TABLE [Category] WITH CHECK ADD FOREIGN KEY([parentCategoryId])
REFERENCES [Category] ([id])
GO
HI Char27, I was reading your post and was wondering if it would solve the problem I'm experiencing now with the starter kit. I'm new to all this so bare with me. I have installed 2008 and have sql 2005 on my local machine. Everything works fine. I have
only made little html changes just to get a feel for it. I made use of the 'copy site' to upload the site to my test server. I now need to make changes so that the site connect to the webserver sql 2005, but am not sure where to do this or how to. I have ran
the script to create the table and made sure I have a user in the security to log in, but how do I code a sql 2005 connection?
THX
Blessed are the cracked - for it is they who let in the light...
ll02
Member
4 Points
9 Posts
Small Biz Starter Kit and SQL 2000
Feb 26, 2007 11:07 PM|LINK
vvsharma
Member
596 Points
132 Posts
Re: Small Biz Starter Kit and SQL 2000
Mar 01, 2007 01:46 AM|LINK
You can downlod the Evaluation version of MS SQL 2000(http://www.microsoft.com/downloads/details.aspx?FamilyID=D20BA6E1-F44C-4781-A6BB-F60E02DC1335&displaylang=en) .You can the Enterpise manager along which doesnt expire.Doesnt; your web provider have any kind of an interface to attach the mdf directly?Well,we do provide our customers with a SQL Tool Suite,which makes things pretty simple.
Creating the schema manually might cause issues because you may have missed something out .You can always go with the xmlprovider .
Hope this helps!
DiscountASP.NET
Innovative ASP.NET Hosting & SQL Hosting
ll02
Member
4 Points
9 Posts
Re: Small Biz Starter Kit and SQL 2000
Mar 03, 2007 03:44 AM|LINK
Char27
Member
2 Points
1 Post
Re: Small Biz Starter Kit and SQL 2000
Mar 14, 2008 12:55 AM|LINK
I know its been a year since this was posted but in searching for a solution, there are only two hits I could find and this was one. Maybe someone else could use this...
I ran into the same issue with my provider using SQL 2000. However, I have SQL 2005 locally so I ran the script there and then re-scripted out the database using SQL 2000 settings.
Here is the updated script for SQL 2000.
JackoW
Member
2 Points
6 Posts
Re: Small Biz Starter Kit and SQL 2000
Apr 15, 2008 02:14 PM|LINK
HI Char27, I was reading your post and was wondering if it would solve the problem I'm experiencing now with the starter kit. I'm new to all this so bare with me. I have installed 2008 and have sql 2005 on my local machine. Everything works fine. I have only made little html changes just to get a feel for it. I made use of the 'copy site' to upload the site to my test server. I now need to make changes so that the site connect to the webserver sql 2005, but am not sure where to do this or how to. I have ran the script to create the table and made sure I have a user in the security to log in, but how do I code a sql 2005 connection?
THX