How Many Mobile DB's Can Sync With One Server?
Oct 3, 2006
Hi,
I'm in the planning stages of a new application and upper mgmt needs this question answered. I am planning to use SQL Mobile 2005 on the hand held devices and SQL Server 2005 as the server. What kind of hardware/configuration do I need that would allow 500 mobile devices to sync at roughly the same time? Any reccomendations on design issues is also welcome.
The business community is all on the same schedule and past experience shows that that do things in large groups. I need to plan for the worst case. Any input would be appreciated.
Thanks,
View 1 Replies
ADVERTISEMENT
Oct 6, 2006
Hi Everyone,
I have tried the Sync the data from sql server mobile (.SDF) to Sql server 2005 (.mdf).In push command, i am getting the error "Sql Server Everywhere encountered problems when opening the database".
string rdaOleDbConnectString = @"Provider=SQLOLEDB.1;User ID=sa;Initial Catalog=master;Data Source=PRASSANAPRASANNA;Password=master";
qlCeRemoteDataAccess rda = null;
try
{
rda = new SqlCeRemoteDataAccess();
rda.LocalConnectionString = "Data Source=D:/DATABASE/test.sdf";
rda.InternetUrl = http://localhost/Dataset/sqlcesa30.dll;
rda.Push("company", rdaOleDbConnectString, RdaBatchOption.BatchingOn);
MessageBox.Show("Completed");
}
catch (SqlCeException)
{
}
finally
{
rda.Dispose();
}
please guide me any one ours guys to solve this problem .
Thanks
Prasanna.
View 5 Replies
View Related
Oct 6, 2007
Can I synch between a Mobile device using SqlServer Compact and desktop PC running Sql Server Express using Microsoft Synchronization Services?
View 1 Replies
View Related
May 25, 2007
Hi,
If I have 2 mobile databases, 1 on my desktop and the other on a PDA, how do i synchronize both these database? Are there any vb samples where i can refer to?
thanx
View 4 Replies
View Related
Jun 30, 2006
I have just upgraded from a working app for Pocket PC 2003 developed on MS SQL 2000 and VS 2003 to Mobile 5, MS SQL 2005 and VS 2005 and have been nable to get anything working.
I decided to go back to basics and just try to sync a SQL2005 and SQL mobile database by following the MS doc "Creating a mobile application with SQL Server mobile" and "Step by Step: Developing a SQL Mobile App with Visual Studio 2005 and SQL Server 2005". Unfortunately I have n't been able to get either of these 2 examlpes working either. The Database, publications, subscriptions etc are all created OK yet when I come to sync I get the following error:
"A request to send data to the computer running iis has failed"
I'd greatly appreciate it if someone could offer me any clues as how to approach this.
View 6 Replies
View Related
Apr 29, 2008
I have been able to use MS Sync Services to sync an MDF file & an SDF file (Works great! Very easy!).
What I would like to know is if I could sync an SDF file with another SDF file (making an SDF file a desktop DB and the other a Mobile DB)?
Thanks,
V
VS 2008
SQL 2005 Express
View 3 Replies
View Related
Feb 8, 2007
Hello Everyone,
I have a publication on a Sql 2000 (SP4) server. This publication has dynamic filtering enabled. What I want to do is create an interface which will generate a new dynamic snapshot based on filtering input from users. So far I can create the dynamic snapshot easy enough and I can see the filtered results on a Sql 2000 subscriber. However, there seems to be no way to configure a mobile database to point to the dynamic snapshot. This is easy to configure in a Sql 2000 subscription - the options are right there are on the properties page. Yet, it seems like the mobile database only points to the required unfiltered snapshot through the IIS proxy.
Is there any way to force the mobile database to use the dynamic snapshot instead?
Thanks,
Mike
View 6 Replies
View Related
Aug 5, 2007
Hiya,
I have a project that requires that I filter certain data going to the mobile device via the publication based on user selected value on the mobile device. (Filter by location based on the selection of the location on the mobile prior to syncronization).
Now, our current authentication model is Windows Authentication, and changing that to Username based authentication is not feasable, and using the users account to pass that value to the database is the only way I can think of to do this... (Then filter based on username)
But then I thought that there has to be another way - such as passing a variable or parameter to the sync request during or before syncronization... Is this possible? If I could query the data being sent back up to the server, for instance, I could do so to retrieve the value I need.... Any ideas?
Any help appreciated!!
Dave Borneman
anyWare Mobile Solutions
View 1 Replies
View Related
Sep 9, 2007
I use my Pocket PC XDA O2 mini for 2 years already and I don't have any problems when I sync it with my previous laptop which has Window XP operation system.
A few months ago, I bought a new laptop with Window Vista operation system, I could not sync my O2 mini with my PC. Then, I download Windows Mobile Device Center but my computer still could not recognize my O2 mini. My O2 mini has window mobile 2003 Second Edition Version 4.21.1088 operation system. Please let me know if you have any advices.
Thanks.
View 1 Replies
View Related
May 10, 2007
Hi,
i am working with windows mobile Cf 2.0 and desktop. i got problem when i were trying to synd mobile database and ms-access database.
my requirement is online i want to transfar data records from mobile to desktop vice versa.
but how? i dont knwo any body would like to guide me.
i am ready to accepting yours valuable views.
waiting
bye
Rajat.
View 9 Replies
View Related
Aug 8, 2006
Dear ppl,
I am writing an application for a device (MDA Pro T-Mobile) having Windows Mobile 5.0 using
-MS .NET Compact Framework 2.0 SP-1
-SQL Mobile 2005.
-VS 2005 .NET
The application uses Merge Replication. The error occurs in the Synchronise() Method of the SqlCeReplication object.
"SQL Server Mobile encountered problems when opening the database."
repl.AddSubscription(AddOption.CreateDatabase);
repl.Synchronize();
I don't understand why I am having this error. It does create the database on AddSubscription() method but it is failing opening the database on Synchronise(). I have also tried uninstalling and then reinstalling all the SQL Mobile components in the following order.
-sqlce30.wce5.armv4i.cab
-sqlce30.repl.wce5.armv4i.cab
-sqlce30.dev.ENU.wce5.armv4i.cab
However, when i run this application on a device(Dell X50 AXIM) with Pocket PC 2003, it runs fine creating the database and sysnchronising it.
The target platform for the project is Windows Mobile 5.0 Pocket PC SDK.
Does any one have any clue what could be the problem ?
Regards
Nabeel
View 6 Replies
View Related
Mar 23, 2006
Hello,
I am developping a non-managed C++ application for PocketPC using a SQL Server mobile database.
The application is compiled for PocketPC 2003 and uses SQL Server Mobile v2. I use Visual Studio 2005. But I need to compile the application for Windows Mobile 5.0 devices. So I installed the WM5 SDK and had the WM5 into my project configuration.
The "ssceoledb.h" which I include incluses the "transact.h" file. But my problem is that this file is only provided with the PocketPC 2003 SDK and not in the WM5 SDK.
So I cannot use the WM5 configuration project with SQL Server. I also tried with the last SQL Server Mobile 2005 (ie v3.0) and the "ssceoledb30.h" also includes "transact.h".
Did I miss something to install ?
Do you know how I can resolve the problem ?
By advance, thank you for any answer.
--
Gregoire
View 9 Replies
View Related
May 18, 2006
Using MS VS 2005 (incl SQL Server Mobile)
MS Pocket PC 2005 SDK
I am working on a project that builds for Pocket PC on both Mobile 2003 and Mobile 5. The project uses/will use SQL Server Mobile to store local data.
Project created from new with support for both platforms. I include required header files ssceerr30.h and ssceoledb30.h.
Project builds fine in WM2003 configuration, release and debug.
When I build for WM5 the compiler cannot find the header file transact.h. This is included from within ssceoledb30.h. Same as under WM2003.
In WM2003 configuration if I highlight the ssceoledb30.h include in Visual Studio and open the header, it takes me to <Visual Studio dir>SmartDevicesSDKSQL ServerMobilev3.0. I then locate the include for transact.h and do the same, which takes me <Visual Studio dir>SDKPocketPC2003include. The file exists.
If I repeat the above 'browsing' under the WM5 configuration, ssceoledb30.h takes me to a different copy in the WM5 SDK directory. There is no diff between the file here and the other copy used by WM2003. If I attempt to open transact.h - file does not exist.
Fix (which I'm not too sure about, i.e. is it OK?) - If I copy transact.h to the WM5 SDK directory, the project builds.
Why has transact.h disappeared from WM5 SDK?
I can find no ref's to this problem anywhere. Is my installation of the WM5 SDK corrupt? What else could I be missing?
Is there a sample for SQL Server mobile (like the NorthwindOLEDB sample) that comes configured to build for WM5?
View 1 Replies
View Related
Apr 24, 2006
Hi folks, I'm new to Windows Mobile progamming, and new to this forum. Apologies in advance if I'm asking a boneheaded question, but I've done searches and can't find anything directly applicable to my problem.
I'm currently walking through the published MS tutorial in setting up an SQL Server 2005 Mobile application that subscribes to a publication on SQL Server 2005 to exchange information.
I've gotten almost all the way through... successfully set up the server components, creating the publication, etc. On the mobile side, I've been able run the cab files to install the SQL Mobile components and to create the project, add the reference to the dll, and instantiate an engine object. It compiles.
The step in the tutorial after that, though, where you specify the data source from the "data" menu, I've got a problem. When I try to use the "new connection" dialog from choosing the data connection, "MS SQL Server Mobile Edition" doesn't show up as a choice. I've tried choosing any of the other combinations, and in teh subsequent "Connection properties" section my database, SQLMobile (as in their sample) is available, but I get an error when I choose it and click OK. Clicking on "Test Connection" gives me a connection successful message.
My guess is that something about the Mobile server side components is not installed correctly on my development machine, but honestly I have no idea how to begin to fix it. Has anyone seen this problem before and know how to resolve it?
Your time and any knowledge sharing is greatly appreciated.
Thank you,
-Dana
View 8 Replies
View Related
Sep 16, 2007
Hi:
When I try and connecto to SQL CE I always get an invalid operation exception. I"m afraid that I did not follow the proper install for Orcas Beta 2. I can't remember if I was supposed to uninstall SQL Mobile 2005 first or not.
All I know is when I try and use my SQL CE I can't connecto to a DB / sdf file ?
Any help would be appreciated I"m just starting to use SQL CE.
thanks
mark
View 2 Replies
View Related
Jul 21, 2006
This is a great tutorial and it's a shame one of the more important steps was missed.
In the €œCreate the snapshot user€? section you you find the steps to create the snapshot_agent account. Then in the €œCreate the snapshot folder€? section you find the share and folder permissions. However, at no point do the instructions advise you about adding the snapshot_agent to the SQL Server Logins. The result is that agent cannot perform the initial snapshot but you won't find this out until 50 steps later after Step 10 in the section €œCreate a new subscription".
To get back on track, openthe Object Explorer's Security section and add the snapshot_agent to your logins. Then using the "User Mappings", set an appropriate level for the SQLMobile database role. Once completed you then need to run the agent.
Right-click the SQLMobile publication you created and select "View Snapshot Agent status". From that dialog you can select "Start" to run the agent. When it completes, you can return to the tutorial section "Create a new subscription" and continue with the tutorial.
View 4 Replies
View Related
Nov 3, 2007
I am studying the tutorial in SQL Server 2005 Mobile Edition Books Online, and the topic is Creating a Mobile Application with SQL Server Mobile. I have got a problem when creating a new subscription after created a new SQL Server Mobile database. And the problem is shown below:
New Subscription Wizard
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
* Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
* 無法完æˆ?作æ¥ã€‚
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
Before I have met this problem, I have finished all the task. And I can browse the localhost web site by using anonymous account even I use internet explorer or browse the directly in IIS.
Does anyone can solve it?? Thank you very much~~~
View 3 Replies
View Related
Jun 15, 2006
I am migrating a pocket PC application from VS 2003 to VS 2005 and a few weeks ago I hit the following problem when replicating
A SQL Mobile DLL could not be loaded. Reinstall SQL Mobile. [ DLL Name=sqlceca30.dll]
Scanning forums for help I saw that other people had had this problem and one
http://www.eggheadcafe.com/aspnet_answers/NETFrameworkCompactFramework/Feb2006/post25814466.asp
suggested that this problem could be circumvented by getting the replication object early and then continuously using the same object for subsequent replications.
I did this and it works a lot better now but ever so often I get another error which is
Native Error 28559 SQL Mobile encountered problems when opening the database
My only option at this point is to stop and start the application which cures the problem.
View 4 Replies
View Related
Aug 17, 2007
Hello
We recently started to use SQL server 2005. Now I need someway to sync some tables between the SQL server and our existing MySql db. Any recommendations on tools who will allow me to do this?
View 1 Replies
View Related
Sep 25, 2006
Hi all.
I want to do the following:
I have a (quite big) sql server 2000 database. I'd like to replicate the whole DB onto a 2k5 server. Then disconnect that connection, to have an independent copy on the 2k5 machine. After I made some modifications on the data on that machine, I'd like to sync those databases to have the data on the sql server 2000 as well.
Is this possible in any way (tool or API available) or must I hand code it? At the moment I do this thing by exporting to *.sql files, and then importing, but the replication/sync method would be quite nice.
Yours, Dave
View 1 Replies
View Related
Jun 5, 2007
how can one ce database sync to two different server?
for example, i sync ce to server A, also i would like to sync to server B.
And the other case how can i re-sync ce data to same server if server has some data lost??
View 1 Replies
View Related
Jun 4, 2008
After reading alot of articles over the past few days, some things have become more clear, while others haven't.
I'm using Visual Studio 2005 .NET, SQL Server Express 2005 SP2, and SQL CE 2005 3.1.. The PC I'm developing on runs Vista, so I enabled IIS in the Control Panel.
I'm developing an application for the desktop PC, which connects to a local instance of SQL Express.. I also have developed basically a small data-capture app for the Pocket PC 2003 .. I have 3 very small tables I would like to keep synced, between the PC and the handheld, when the user docks the handheld into the docking cradle... is this possible with SQL Express? And if so, is IIS absolutely required to exchange data between the database on the PC, and the database on the handheld?
PS.
To explain the table interaction a bit further... say Tables A & B have information that is added/edited using the desktop application.. any time the handheld is cradled, I'd like the user to be able to update the tables A & B on the handheld with any data that has changed...
Meanwhile, the user captures data with the handheld, and these records are stored in table C.. when the handheld is cradled, any new records in the handheld in table C, I would like to have added to table C in the PC as well
View 1 Replies
View Related
Jul 7, 2015
we are using ASMCD to sync our cubes from a Cubebuild Server to a Reporting Server. We migrated some days ago from 2012 to 2014. We are also using rel. Engine with StoredProcs for calling and executing xp_cmdshell for the Ascmd.Actually all works fine for our smaller cubes. For the bigger one we got the following issue. The cube is being synced but the proc delivers error.In the log we found this entry:
(7/7/2015 11:26:22 AM) Message: The directory '?D:SSAS_DATAGPMR Local CNTR.510.dbLocal Controlling Cube.0.cub' could not be deleted. Please check the directory for permissions.
(Source: ?D:SSAS_LOGmsmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210020)
(7/7/2015 11:26:34 AM) Message: The directory '?D:SSAS_DATAGPMR Local CNTR.510.db' could not be deleted. Please check the directory for permissions.
[code]...
View 2 Replies
View Related
Mar 6, 2006
It is possible to access a Sql Server 2005 Mobile database in a VS2003 application (compact framework) ?
Thanks
Robson
View 4 Replies
View Related
Sep 8, 2007
I receive error 25123 on my PPC (audiovox 6600) in a reproducable way (usually) with .net 2.0 application that is using SQL CE that I wrote:
Open the application
Connect to the database
Close the applicaton
Re-Open the application
Connect to the database <-- Error occurs
I will also receive the error if my application isn't the first application launched (or very close to the first to launch).
I don't believe it's a memory issue as according to the memory manager I have plenty of memory:
At boot up only start screen items loaded: 18.46 Used 49.89 Free
Launch Resco File Explorer to click EXE: 19.18 Used 49.18 Free
Launch my application (no DB connection): 23.64 Used 44.71 Free
Connect to the DB and do select count(*) from a table with 0 rows: 26.27 Used 42.08 Free
Close the application (this.Close() on the form: 19.38 Used 48.97 Free
Relaunch App and connect to DB receive error: around 38 Used around 30 free
I was unable to reproduce the issue right now while typing this message, the last sets of numbers are from memory, and include other applications that are currently running.
The only way I have to get SQL CE to load again is to soft reset the PPC. If the application is able to connect to SQL CE at least once it is fine up till I close it and re-open the application. So it either connects and runs great, or it can't connect at all.
Any help in resolving this issue would be greatly appreciated.
Wayne
View 1 Replies
View Related
Mar 15, 2006
Hi all,
I have a module in power builder with Sybase database as its backend. The other modules related to the same application are running on Delphi with SQL server as backend.
My requirement is to sync between the Sybase database and SQL server (2000) in order to update the SQL server with all the transactions ( online ) done in the Sybase database.
Thanks in advance ,
Hari Haran Arulmozhi
View 2 Replies
View Related
Aug 17, 2007
Hi,
Im fairly new to this so apologies if Ive put this in the wrong place.
I have just rented out server for a new asp.net site. Ive been developing the site on my local machine and the database in Sql Enterprise. Ive recently put a copy of the site on the live server and got everything configured.
However everytime I make a change to my local database, or add values into my look up tables I have to go do the same on the live server and its proving a bit of a pain in the ass, so Im guessing there has got to be a much smarter way of doing this. I dont want (if possible) to open up the live sql server to allow remote connections, but if thats what neccesary so be it.
So my question is basically what are my options for keeping my live server up to date with my development server. As I add new features on my local server, should i be saving sql scripts of all the changes I make?
All opinions much appreciated.
C
View 4 Replies
View Related
Apr 15, 2008
Hello,
I have SQL Server 2000 and 2005 running on the same server. My current system is in SQL Server 2000 and the new system is in SQL Server 2005. My users will be using SQL Server 2000 for the most part, But for the part the processes that have been migrated to 2005, they will be using SQL Server 2005 as well. The database schema is different on both servers eventhough the data will be similar in most respects.
Is there is a way through which any data that is inserted/updated in SQL Server 2000 via content Management System/ manually/ via a batch job, the data is automatically populated in SQL Server 2005 tables or vice versa?
Please advice at the earliest.
Thanks.
View 1 Replies
View Related
Oct 27, 2006
I have set up log shipping between two servers with a third serving as a monitoring server. Recently the monitoring for the eight databases that I am log shipping began to indicate that everything was failing. Upon further inventigation of the log_shipping_monitor_history_detail tables on the prinary and secondary everthing appears to working properly but I have been unable to resyncronize the monitoring. I have attempted to use the stored procedure sp_refresh_log_shipping_monitor to no avail, it does not appear to do anything with respect to the data in the dbo.log_shipping_primary_databases and log_shipping_monitor_primary tables on the primary server or the log_shipping_monitor_secondary and dbo.log_shipping_secondary_databases tables on the secondary. I have also manually updated the records in these tables in an attempt to syncronize but after the next sucessful backup, copy and restore this monitoring data is not updating. Does anyone have any ideas as to what I am doing wrong or how I might rectify this situation.
View 3 Replies
View Related
Jul 23, 2012
Here's the scenario. We tried to create a full text indexing on a view, unfortunately the view was created based on Left outer join. Hence we were pushed to do the following.
We planned to create a table based on the data that is rendered in this view(this view is formed by combining 14 tables.) . Finally we were able to create a full text indexing on this new table. For simplicity let us called this new table as tableA.
Now the problem is how can we update (if any data is changed on one of the concrete tables of the view) or insert (when new data is inserted in one of the underlying tables of the view) the respective data into this new table - tableA which was created based on this view.
In other words, there should be a sync between the view and tableA. Is it possible to achieve this ???
View is formed based on different tables (not based on tableA)?
View 2 Replies
View Related
Oct 6, 2015
deploying a 2 node SQL AAG, with one VM each DC, in sync mode, in an active-active DC layout, with 1ms RTT and 1Gbps? Similar to a SAN based geo-cluster. HA and DR in a single tin.I'm trying to minimise license costs. Having the 2 node in DC1, with async to site 2 is double the license cost!!
View 5 Replies
View Related
Dec 13, 2007
Hi to every one.
For two years i am syncing sucessfully sql server 2.0 datas to sql server 2000 now i want to upgrade to sql server 2005.
I am using Visual Studio 2005 for developing.
Can any one tell the best method available to sync the data from mobile device to sql server 2005.
Also i have os win2003 standard in which i have installed sql server 2005
Does win2003 support mobile device connections with sql ?
Kindly help
View 4 Replies
View Related
