Z
Zac Maclean
I am building a custom application that uses Project to build a timetable
and fill resources for tasks. When I save a project to my SQL server it
works fine, and I have built my queries and they also work fine. When I
try to use merge replication to synchronize w/ a SQL CE device, it is giving
me the following errors (from SQLCE Books online) when trying to fill a
newly created file:
28557 The SQL Server CE database cannot be used for replication.
Delete and then re-create the database. P3: Connection string
SSCE_M_UNUSABLEDATABASE
28560 The OLE DB Execute method failed. The SQL statement is not
valid. P3: SQL statement SSCE_M_EXECUTEFAILED
25082 Unique indexes and constraints cannot be created on columns
that allow null values. Not applicable SSCE_M_UNIQUENULLCONFLICT
The resulting file is slightly larger than one just built using the create
routine. Then if I try to sync w/ the file made previously I get:
28572 Row data cannot be set. Not applicable SSCE_M_ERRORSETTINGDATA
then error 0 (Invailid row handle)
I have the Project Data Schema, and have looked at every field in the
database that I am bringing over to the CE device, there are no errors that
I can find. All the projects that I have saved to this database work fine
in Project, and allow changes. I have gotten a database to update and merge
info back to SQL. Just not w/ this version of it. If any one can just
give me a new place to look.. Deadlines loom..![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
tia
Zac
and fill resources for tasks. When I save a project to my SQL server it
works fine, and I have built my queries and they also work fine. When I
try to use merge replication to synchronize w/ a SQL CE device, it is giving
me the following errors (from SQLCE Books online) when trying to fill a
newly created file:
28557 The SQL Server CE database cannot be used for replication.
Delete and then re-create the database. P3: Connection string
SSCE_M_UNUSABLEDATABASE
28560 The OLE DB Execute method failed. The SQL statement is not
valid. P3: SQL statement SSCE_M_EXECUTEFAILED
25082 Unique indexes and constraints cannot be created on columns
that allow null values. Not applicable SSCE_M_UNIQUENULLCONFLICT
The resulting file is slightly larger than one just built using the create
routine. Then if I try to sync w/ the file made previously I get:
28572 Row data cannot be set. Not applicable SSCE_M_ERRORSETTINGDATA
then error 0 (Invailid row handle)
I have the Project Data Schema, and have looked at every field in the
database that I am bringing over to the CE device, there are no errors that
I can find. All the projects that I have saved to this database work fine
in Project, and allow changes. I have gotten a database to update and merge
info back to SQL. Just not w/ this version of it. If any one can just
give me a new place to look.. Deadlines loom..
tia
Zac