Installation problem

Topics: Mobile Client Software Factory
Jul 21, 2006 at 3:34 PM
originally posted by: Yin_Yuzhe

At the end of the installation, it was reported an error : fail to exicute SQL string.
The SQL string is incomplete. SQL key InsertData string: Insert into dbo.vindividualcustomer
(customerID, Title, Firstname...

I use VS2005 TS simplified Chinese version and SQL 2005 Developer edition of simplified Chinese.
Jul 24, 2006 at 3:42 PM
originally posted by: SkullGundam

I hava the same problem.

I use the same edition of visual studio and sql server express edition in Simplified Chinese.
Jul 25, 2006 at 1:21 PM
originally posted by: fkc888

Did you try running the script in SQL Server Management Studio?

Depending on your specific install location, the script is probably here:
C:\Program Files\Microsoft Mobile Client Software Factory\ReferenceImplementations\AdventureWorksToGo\DBScripts

First, delete the following from your SQL Server 2005 instance:
  • AdventureWorksMobileStaging db
  • ADVENTUREWORKS_USER
  • Any Replication Publications related to AdventureWorksMobileStaging db

Run the db scripts in the following order:
1) database.sql
2) CreateTablesAndUser.sql
3) InsertSampleReferenceData.sql
4) CreatePublicationsResult.sql

You may need to edit the CreatePublicationsResult.sql, updating the name of the SQLServer2005SQLAgentUser and SQLServer2005MSSQLUser accounts to match the accounts on your instance of SQL Server.
Jul 25, 2006 at 3:38 PM
originally posted by: SkullGundam

the sql statment in InsertSampleReferenceData.sql has syntax error.

After modified the sql statment, I created data successfully.

Maybe just in Simplified Chinese Edition Sql Server to display the sql statment error.
Jul 28, 2006 at 11:16 AM
originally posted by: fkc888

We have updated the InsertSampleReferenceData.sql script in line 280 to address your problem. Please download the new installer and try again.