Native Error 28560
problem I'm getting at the moment is a bit puzzling.I have 15 Tables containg 47 Indexes in total that I would like toreplicate. When I attempt to perform an initial sync the ReplicationMonitor reports success, but I get the following exceptions on thehandheld:1. "Run" Native Error: 285572. "The OLE DB Execute method failed. The SQL statement is not valid.[,,,SQL statement,,]" Native Error: 285603. "The specified index already exists" Native Error: 0I've tried to cut down number of tables, but it seems that sometimesit works and sometimes it doesn't. For example, if I add Table A,Table B, and Table C ... no problem. Add Table D ... problem. Now try,just Table D no problem, etc.Is there a limit on the number of indexes, or any known issue that maybecausing this ?Thanks for the help. mgarner1980 2004-08-05 22:36:53 UTC PermalinkRaw Message 28557 The SQL Server CE database cannot be used for replication.Delete and then re-create the database. P3: Connection stringSSCE_M_UNUSABLEDATABASE28560 The OLE DB Execute method failed. The SQL statement is notvalid. P3: SQL statement SSCE_M_EXECUTEFAILEDThe above are from the books online. The first error mkaes me wonder ifjust deleting the database and recreating it would do the trick.As for the second error,I had a similair type problem one time. It turnedout that I had some fields that were being converted during replication. Forinstance I had a indexed char(900) field (I know that 's crazy, but it's acustomers legacy db!!!) that sqlserverce converted to ntext. A table cannotbe indexed on a ntext type field. Perhaps something like that is happening?Just guessing.Post by CiaranHi all,I've implemented several solutions using Replication in the past,but the problem I'm getting at the moment is a bit puzzling.I have 15 Tables containg 47 Indexes in total that I would like toreplicate. When I attempt to perform an initial sync the ReplicationMonitor reports success, but
get an unexpected error, that is the code : ' * * * drop data base if already exists Dim oFilSystem As FILECTL.FileSystem Set oFilSystem = CreateObject("Filectl.fileSystem") If oFilSystem.Dir("mydb.sdf") <> "" Then oFilSystem.Kill ("mydb.sdf") End If ' Declare the Replication Object. Dim oCERepl As SSCE.Replication Set oCERepl = CreateObject("SSCE.Replication.1.0") ' Set Internet properties oCERepl.InternetURL = "http://myIIS/ssce/sscesa10.dll" oCERepl.InternetLogin = "" oCERepl.InternetPassword = "" ' Set Publisher properties oCERepl.Publisher = "myserver" oCERepl.PublisherDatabase = "^mypubdb" oCERepl.Publication = "mypub" oCERepl.PublisherSecurityMode = DB_AUTHENTICATION oCERepl.PublisherLogin = "sa" oCERepl.PublisherPassword = "" ' Set Subscriber properties http://microsoft.public.sqlserver.ce.narkive.com/gAOfvg3W/error-the-specified-index-does-not-exist oCERepl.SubscriberConnectionString = "Provider=Microsoft.SQLSERVER.OLEDB.CE.1.0;data source=mydb.sdf" oCERepl.Subscriber = "subs 1" ' Create the new anonymous subscription oCERepl.AddSubscription CREATE_DATABASE ' Perform the first synchronization to download the initial snapshot by ' calling the Initialize, Run Terminate methods On Error Resume Next oCERepl.Initialize If oCERepl.ErrorRecords.Count > 0 Then Call ShowSSCEErrors(oCERepl.ErrorRecords) Else ' no error until here http://www.verycomputer.com/17_afa8a9aca46f687d_1.htm On Error Resume Next oCERepl.Run If oCERepl.ErrorRecords.Count > 0 Then ' I get 3 errors Call ShowSSCEErrors(oCERepl.ErrorRecords) End If oCERepl.Terminate End If Set oCERepl = Nothing Those are the errors : Source: Microsoft SQL Server 2000 Windows CE Edition Number: 80004005 NativeError: 28557 The database is in an unusable state. Delete it and recreate it. Description: Run Param = 0 Param = 0 Param = 0 Param = Param = Param = Source: Microsoft SQL Server 2000 Windows CE Edition Number: 80040E14 NativeError: 28560 OLE DB Execute Method failed; bad or invalid SQL statement Description: Run Param = 0 Param = 0 Param = 0 Param = Param = Param = Source: Microsoft SQL Server 2000 Windows CE Edition Number: 80040E14 NativeError: 25501 Error parsing query Description: The command contained one or more errors Param = 1 Param = 1 Param = 0 Param = SET Param = Param = Please help me !!!!! Top Error in SSCE Merge Replication Object by M Hecto » Thu, 30 Nov 2000 04:00:00 I've been able to do replication successfully. You may need to specify an explicit path for the data source (sdf file). Also, you may want to use object.AddSubscription EXISTING_DATABASE. Hope this helps. I'll check back! Mike H. I am trying to create a data base
GoogleВойтиСкрытые поляПоиск групп или сообщений