Installation problems

Topics: Mobile Client Software Factory
Jul 20, 2006 at 10:29 PM
originally posted by: LokiDBA

Hi All,

When I install the Mobile Client Software Factory I get a SQL error message -

Error -2147217900: failed to execute SQL string, error detail: Line 31: Incorrect syntax near '('., SQL Key: CreateTablesAndUser SQL String: IF NOT EXISTS (SELECT * FROM sys.objects WHERE objectid = OBJECTID(N'dbo.Product') AND type in (N'U')) BEGINCREATE TABLE dbo.[Prod...

Could be there is no space between the BEGIN and CREATE.

I'm installing it against Microsoft SQL Server 2000 sp4.

Thanks in Advance

Andy Hough
IEG4
Jul 20, 2006 at 10:31 PM
originally posted by: LokiDBA

Oppps just notice the 2005 requirement. I'll get it sorted/
Jul 25, 2006 at 11:25 AM
originally posted by: ccunningham

I have SQL Server 2005 installed and get the same error.

However, it installed after I removed installation of the AdventureWorksMobileStaging DB and AdventureWorksToGo OrderTest Web Service.