SQLMobile
Oct 10, 2006What is merge?when I update the row on SQLMobile(Subscription) is it Publication will updates too?
View 1 Replies
ADVERTISEMENT
SQLMobile And &Ñ
Jun 30, 2007I have a problem with the character Ñ:
Insert Into XXX (Cmp1) Values( 'XXXXÑXXX')
But save: XXXXXXX
without the Ñ
Help ..
I use Compact Net Framework 2 y SQL Mobile
Thanks.
Top Instruction In SQLMOBILE
Feb 24, 2006As I have tested the top instruccion doesn´t exist I sqlmobile isn´t it?????
How I could load in my dataset for example the 20 next registers of the last register I have load in my dataset previusly??????
Thank for your Help.
SQLMobile Install Help
May 20, 2006hi -- I installed SQLServer Mobile SDK several months ago and was able to use the system with VS2005 and a PPC. Somewhat later I installed SQL2005 and shortly after uninstalled SQLMobile SDK. I've had to go back and fix the project I wrote with SQL Mobile and I went to install it again. It installed fine, but the SQL Mobile provider was not available in the dialog for "client choices" when i went to configure the Data Connection.
The lack of a provider then corrupted my xsd file. Is there a way to manually install the SQL Mobile provider (or fix the install?) I've uninstalled and reinstalled the SDK a couple times.
Jim
SQLMobile 2005 IIS 5.1 Problems
Sep 1, 2006Hi,
I've installed SQL Server 2005 mobile server tools. Then using the synchronization wizar, i set up a virtual directory on my iis 5.1 (running windows xp).
To test the installation i´ve opened an IE windows, then http://localhost/sqlceremote/sqlcesa30.dll. I get always the same message: "interal server error".
Then i look into the event log and found an IIS WARNING entry saying (in spanish)
"El servidor no pudo cargar la aplicación '/LM/W3SVC/1/root/sqlceremote'. Error 'Interfaz no compatible
'.
-> incompatible interace
I can´t find the way to make this work. Any help?
It may be important to say that i have installed an SQL 2005 express edition instance that is not a default instance becouse i also have an MSDE on the same machine.
thanks.
Limited Number Of Connections To SQLMobile?
May 5, 2006Using System.Data.SqlClient is there a limit to the number of connections an application can have to a SQLMobile dB?
If
you have a look at the url below, it says "A device can only have a
small number of connections to an instance of SQL Server at any time"
Does this mean 2, or 8 or what?
Should a app try to use only 1 connection throughout, or can we get away with 2-3?
Is this the same on WM5.0/PPP2003?
Any advice in this area much appreciated!
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/htm/_lce_sqlclient_705.asp
p.s. I'm not interested in connection pooling!
SQLMobile Replication To SQL Server 05 64bit
May 2, 2006I am looking at buying a new database server to run SQL Server 2005. I want to get 64 bit server, windows standard 64 and SQL Server 64. I already have an app I created that uses SQLMobile on a Windows Mobile 5.0 device. Will I be able to run this app if I move to the 64 bit or am I better off just staying 32 bit?
View 3 Replies View RelatedSubscription Failing In Wizzard Foe SQLMobile ?
Dec 15, 2006Hi,
Need a little help on this one....
Using SQL Server 2005 and attempting to create the SQL Mobile CE example Publication and Subcripion. I was able to successfully create the publication on the main server engine but when trying to complete the wizzard for the SQL CE Database subscription I receive an error.
The Subscription fails using the wizzard with the following credentials:
Publisher: LAPTOP
PublisherDatabase: SQLMobile
Publication: SQLMobile
Subscriber: SQLMobile
HostName:
InternetUrl: http://localhost/SQLMobile
Web Server Authentication: Anonymous
PublisherSecurityMode: Windows Authentication
I have also created the Snapshot folder that is shared.
Here is the error I get when click Finish in the wizzard to create the Subscription:
- Synchronizing Data (Error)
MessagesAn incorrect or unsupported HTTP function call was made.
HRESULT 0x80004005 (28017)
The operation could not be completed.
PLEASE HELP....I Exausted all my attempts !