Hi guys,
Correct me if I'm wrong. That's wat I was doing.. Try to perform a merge replication between the 2.
But the following errors are wat I've got during the syncronization:
Error Code: 80004005
Message : Run
Minor Err.: 28557
Source : Microsoft SQL Server 2000 Windows CE Edition
Err. Par. : ssce:database;password=mypassword;data source=Program Files\helloWorld\database.sdf;
Error Code: 80040E14
Message : The OLE DB Execute method failed. The SQL statement is not
valid. [,,,SQL statement,,]
Minor Err.: 28560
Source : Microsoft SQL Server 2000 Windows CE Edition
Error Code: 80040E14
Message : There was an error parsing the query. [Token line number, Token
line offset,,Token in error,,]
Minor Err.: 25501
Source : Microsoft SQL Server 2000 Windows CE Edition
Num. Par. : 1
Num. Par. : 1
Err. Par. : SET
Can anyone kindly advise wat went wrong Am I missing something Should I do some code changes in the application, cos this same set of codes were used for the merge replication between SqlServer2000 and SqlCe, and proven to be working fine.
Thanks.
Cheers,
Kevin
---------
SqlServer2005 can support merge replication with SqlCe2.0??
Babacar
Also, I would recommend you try out this on a test machine before trying it out on a production server.
Thanks,
Laxmi NRO, MSFT, SQL Mobile
jturn99
Do you have Publisher, Distributor, Subscriber in SQL Server 2005 on the same machine
SQL Server CE 2.0 MUST be on a separate machine than on a machine where SQL Server 2005 exists.
The expected infra structure is:
SQL Server 2005 Box <==> IIS Box (with SQL Server CE 2.0 Server Tools) <==> SQL Server CE 2.0 Developer Tools or Visual Studio 2003
However, IIS Box and Development machine (VS 2003) can be on the same box.
You can still use VS 2003 and SQL CE 2.0 on the Client Side.
Hope this helps!
Thanks,
Laxmi NRO, MSFT, SQL Mobile
Robby Aube
Glad that things are working from your side.
Is the previous issue with Visusal Studio 2005 solved
Thanks,
Laxmi NRO, MSFT, SQL Mobile
Vince15
Of course, Yes
Infact SQL Mobile Desktop/WIN32 Version comes free with SQL Server 2005. However, you can use SQL Mobile Desktop version on a machine where either SQL Server 2005 or Visual Studio 2005 is there.
Open SQL Server Management Studio (SSMS). In the CONNECT Dialogue, there is an option to connec to SQL Server Mobile :). The beauty with this here is:
1) Create publication on desktop
2) Configure Virtual Directory for this publication using "Configure Web Sync" wizard. This automatically installs SQL Mobile Server Tools if you try to configure virual directory for SQL Mobile.
3) Create subscription also on the desktop through (SSMS). So this makes the initial subscription easy even if the initial download data is 5 MB or more.
Please have a look at SQL Server 2005 Mobile Edition Books Online for more details.
4) Then Copy the subscription database to multiple devices (not desktops)
5) All devices can have the same copy of the subscribed database and start working with it for further subsequent syncs. SQL Mobile sync has the functionality to detect and automatically update the sync params like subscription id.
Let me know if you need any further information.
Hope this helps!
Thanks,
Laxmi NRO, MSFT, SQL Mobile
cheeso
Wat I meant was that I created the publication, distribution on SqlServer 2005. SqlCe is installed on the subscriber, ie. the PDA. However, SqlServer2005, IIS and SqlServerCe 2.0 Server Tools, and VS 2003 are installed on the same machine.
Is there a problem wif this infra
Cheers,
Kevin
------------
JPlenert
Thanks for all yor help..
Cheers,
Kevin
-----------
PiotrP
Hi Laxmi,
Thanks for yor reply.
Below is a section of the program where it failed:
replEperform.InternetUrl = config.getInternetUrl();
replEperform.InternetLogin = "";
replEperform.InternetPassword = "";
replEperform.Publisher = config.getPublisher();
replEperform.PublisherDatabase = config.getPublisherDatabase();
replEperform.Publication = config.getPublication();
replEperform.PublisherSecurityMode = SecurityType.DBAuthentication;
replEperform.PublisherLogin = "sa";
replEperform.PublisherPassword = "mypassword";
replEperform.SubscriberConnectionString = @"Data Source= " + config.getLocalRAMDatabase()
+ ";Password = " + config.getDatabasePassword();
replEperform.Subscriber = "SQLCEMobile1";
Cursor.Current = Cursors.WaitCursor;
if (!File.Exists(config.getLocalRAMDatabase()))
{
replEperform.AddSubscription(AddOption.CreateDatabase);
}
else
{
replEperform.ReinitializeSubscription(true);
}
replEperform.Synchronize();
I have setup the publisher, distributer and subscriber in SqlServer2005. The reason why I moved from SqlServer2000 to 2005 is to make use of the new Oracle publication function, which have proved to be working. I am still using Visual Studio 2003 to build and deploy my application. I suppose this should not be the issue rite
Thanks.
Cheers,
Kevin
-------------
sqllady
>I was told dat VS2005 do not support Windows CE 3.0 and below devices, hence >the deployment in VS2005 will not work for my Compaq iPaq. Since I do not have >other mobile devices for my expense, I will have to drop the trial wif VS2005.
Yes, you are right. VS2005 supports only Win CE 4.x and above. And, so is SQL Mobile 3.0.
>So now, my only alt solution is to deploy the SqlServer 2005 and IIS with >SqlServerCE Server Tools 2.0 on serparate machines and to link them up via a >cross-over cable. Still in the midst of testing it out though. Do u think it will >work
Surely Yes, it would definitely work. We would be very happy to solve any problems you may face. And I think that you may not face any big issue.
Thanks,
Laxmi NRO, MSFT, SQL Mobile
Nick (Rensoft)
Considering yor suggestion in setting up Sql Server 2005 and IIS with Sql Server Ce 2.0 on separate machines and linking the 2 machines in a LAN solve the problem ie. Connecting them via a cross-over cable.
Thanks,
Kevin
--------
Helena5
I was told dat VS2005 do not support Windows CE 3.0 and below devices, hence the deployment in VS2005 will not work for my Compaq iPaq. Since I do not have other mobile devices for my expense, I will have to drop the trial wif VS2005.
So now, my only alt solution is to deploy the SqlServer 2005 and IIS with SqlServerCE Server Tools 2.0 on serparate machines and to link them up via a cross-over cable. Still in the midst of testing it out though. Do u think it will work
Thanks,
Kevin
--------------
Mattias Svensson
I've juz migrated my app to VS2005 and Sql Mobile.
Previously when using VS2003 and was able to deploy my applcations to my Pocket PC running on Windows CE3.0, by setting the Target Device to 'Pocket PC Device'.
However, when I've migrated to VS2005, this option is no longer available. When I tried using 'Pocket PC 2003 Device', it prompted a 'Connection failed' error. Since VS2005 allows upgrade of CF1.0 applications to CF2.0, I suppose I should also be allowed to deploy my applications to PPC2002 too.
Btw, I've tried installing embedded Visual Tools 3.0 2002, but it doesn't seems to help too..
Can u pls advise wat I am missing tis time
Thanks.
Cheers,
Kevin
-------------
NimrodPSI
So that we can repro it here locally and figure out what is missing or why is not working
It is our mainline scenario that there should not be any problems while migrating just SQL Server 2000 to SQL Server 2005 (that is with out migrating the Clients).
Thanks,
Laxmi NRO MSFT, SQL Mobile
EnergyCrush
Thanks.
Cheers,
Kevin
--------------
Andrew P
Hi Laxmi,
Here's an update on my effort in separating the SqlServer2005 and IIS with SqlServerCE2.0 on diff machines:
Although the mobile device is able to access the shared files and folders on both machine by entering the web address, I am getting the following errors when trying to do the merge replication syncronization -
1. Error Code: 80045901
Message: Initializing SQL Server Reconciler has failed. [,,,,,]
Minor Err.: 29045
Source: Microsoft SQL Server 2000 Windows CE Edition
2. Error Code: 80045901
Message: The merge process could not initialize the Publisher 'XBOX\MOBILETEST:mobileTest'.
Minor Err.: 0
Source: Merge Replication Provider
3. Error Code: 4E74
Message: The process could not connect to Publisher 'XBOX\MOBILETEST'.
Minor Err.: 0
Source: Merge Process
4. Error Code: 0
Message: The merge process timed out while making a connection. Reconfigure the LoginTimeout parameter and retry the operation.
Minor Err.: 0
Source: XBOX\MOBILETEST
These errors are random though. Sometimes it happens for the Distributor; or it will prompt 'SSL Security Error'.
==================================
Below is an extract of the program where it failed:
replEperform.InternetUrl = config.getInternetUrl();
replEperform.InternetLogin = "";
replEperform.InternetPassword = "";
replEperform.Publisher = config.getPublisher();
replEperform.PublisherDatabase = config.getPublisherDatabase();
replEperform.Publication = config.getPublication();
replEperform.PublisherSecurityMode = SecurityType.DBAuthentication;
replEperform.PublisherLogin = "sa";
replEperform.PublisherPassword = "mypassword";
replEperform.SubscriberConnectionString = @"Data Source= " + config.getLocalRAMDatabase()
+ ";Password = " + config.getDatabasePassword();
replEperform.Subscriber = "SQLCEMobile1";
Cursor.Current = Cursors.WaitCursor;
if (!File.Exists(config.getLocalRAMDatabase()))
{
replEperform.AddSubscription(AddOption.CreateDatabase);
}
else
{
replEperform.ReinitializeSubscription(true);
}
replEperform.Synchronize();
==========================================
I suspect this might have to do with some authentication issue. However, the same codes and config used on SqlServer2000 were applied.. So rightfully, it shld work too rite
I have logged on to SqlServer2005 with Sql Server Authentication - 'sa', 'mypassword'. Is there anything wrong with this
Please help,
Kevin
--------------