Error -2147217900: failed to execute SQL string

Topics: Mobile Client Software Factory
Aug 20, 2006 at 8:56 AM
originally posted by: wxiao

I get an error message When I tried to install Mobile Client Software Factory:

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

I have already installed all the dependence include 1.The Guidance Automation Extensions
2.The Guidance Automation Toolkit 3. Windows Mobile 5.0 SDK for PocketPC
4..Net Compact Framework 2.0 5.SQL Server 2005 Mobile Edition

I am running SQL 2000 and 2005 developer edition on my PC, Please help.

Thanks
Eddie
Sep 27, 2006 at 3:13 AM
originally posted by: andyt99

Yeah, I got this problem and figured it out. Essentially, when it asks you to type in the name of the SQL machine, you have to put more than just the machine name, despite what it says. So mine was failing when I used

MACHINE

but worked when I put

MACHINE\SQLEXPRESS