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
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.