SQM Server Express / SQL Server Mobile

Oct 9, 2005

Hi,

View 1 Replies


ADVERTISEMENT

Synchronization Between SQL Server Express - SQL Server Mobile

Dec 7, 2006

Hello,

I plan to use :

- SQL Server on server
- SQL Server Express on notebooks
- SQL Mobile on Windows Mobile 5.0 devices.

How can I create a replication between SQL Express and SQL Mobile ? SQL Server express cannot act as a Publisher server.

In this post a Senior Program Manager says It is possible but I don't find how to :
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=55236&SiteID=1

Thanks

JF

View 1 Replies View Related

SQL Server Mobile Merge Replication Walkthrough, Cant Find The .NET Framework Data Provider For SQL Server Mobile Edition.

Sep 9, 2005

Hi,

View 3 Replies View Related

SQL Mobile And SQL Server Express Advanced

May 5, 2006

Stephen Hickey writes "We are creating a pocket pc application that utilises data on a SQL Server 2005 express database.

Is it possible to use the rda.Pull() and the rda.SubmitSql() functions when using SQL Server 2005 Express edition.

It appears to us that it will not work because you only get the replication Subsciber agent in this edition and dont get the Replication Publisher and Distributor agents in SQL Server 2005 Express."

View 1 Replies View Related

How To Transfer Data Between Sql Server Express And Sql Mobile?

Jan 19, 2008

Hi all,
Thanks in advance,
I have to transfer data from sql express 2005 to sql mobile(.sdf).

Actually i have a sql server express 2005 (sqlee) in laptop...
and the .sdf (sqlce) handheld device (ppc) that has been connected by activesync.

Can you please make it clear for my following questions?
1. Is it possible to write a query like " insert into ....sdf select from...sqlexp...." between 2 servers...?
2. Is there any copy command like a BULKCOPY .. to insert all records to .sdf (sqlce) from sql server express?


(or)
3. Is it correct to create a smart device application (CF 2.0) to transfer data between sql express and .sdf by using active sync...?

I would appreciate your comments..

Thanks,
Kumaran A

View 4 Replies View Related

Problem On Collation On SQL Server Express With Windows Mobile 5.0

Mar 9, 2007

I am now writing application to connect SQL Server Express in Windows Mobile 5.0.

While running the code, I got error "PlatformNotSupportedException". I realized that it is a problem on different locale on the PDA and the SQL Server. So I tried to re-install the SQL Server for another collation, which is Latin1_General_CI_AI. I have also set the collation to Latin1_General_CI_AI at database-level.

Unfortunately, in the Visual Studio Debugger, I found that the error message is

mscorlib.dll!System.Globalization.CultureInfo.CultureInfo(int culture = 3076, bool useUserOverride = true) + 0xc8 bytes

where the 3076 means Chinese (Hong Kong SAR, PRC) locale from MSDN.

Seems to me that I cannot really change the collation in this Express Edition.

How can I solve it?

Thanks

View 5 Replies View Related

Mobile Solution With SQL Server 2005 Express Edition And Smartphone

May 7, 2007

Hi,i want to create a solution which shall consist of a sql server 2005 -data base (express edition if the following features are available byexpress edition) and a mobile windows application (running on asmartphone under windows mobile 5.0).The sql server shall be installed on a ordinary laptop using windowsxp (not professionall edition).Which would be the best way to exchange the data between mobile deviceand pc? I learned that there is a SQL Server Compact Edition for themobile device and that rda would be a way to exchange data - but theni would need internet information system and this does not run on xphome edition.Which alternatives would you suggest me?Thanx in advanceWolfgang

View 4 Replies View Related

SQL Server 2005 Express Does Not Load On AMD Turion 64 Mobile Technology CPU Computer

Mar 24, 2008

I have a user who is trying to load SQL server 2005 Express on a new Acer laptop computer. The computer has the following:
Windows Vista Home Premium 32 bits
AMD Turion 64 mobile technology CPU
1790 MB of RAM
When the user tries to load SQL server 2005 Express it does not load. The user after the load is getting an €œUnhandled exception has occurred in your application€? when he tries to run the application.
Does anyone know how to fix this problem?


Thank you,

Photomultiplier

View 5 Replies View Related

SQL Server 2005 Mobile Edition ANd SQL Server CE - SHould I Have Uninstalled Mobile First ?

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

SQL Server Mobile 2005 Merge Replication Problem On Windows Mobile 5.0

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

Problem Using SQL Server Mobile 2005 With Windows Mobile 5 Application

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

Cannot Build SQL Server Mobile Solution For Windows Mobile 5

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

SQL Server Mobile Tutorial And Getting Proper Mobile DB Installation

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

Creating A Mobile Application With SQL Server Mobile - FIX

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

Creating A Mobile Application With SQL Server Mobile

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

SQL Server 2005, SQL Server Mobile, SQL Server Management Studio. Unsupported HTTP Function Call

Sep 5, 2005

Hi All,

View 14 Replies View Related

A Call To SQL Server Reconciler Failed. SQL Server 2005, SQL Server Mobile Merge Replication

Oct 2, 2005

Hi,

View 36 Replies View Related

ReadWriteDeleteMessageFile FAILURE With SQL Server Mobile Server Agent Diagnostics

Jul 31, 2007

Hi all.

Is there a difference with sql replication between sql server 2005 64bit and sql server 2005 32bit?
Both are on a Windows 2003 server. One is 32 bit and the other one is 64 bit.
The first time I set up sql replication (test environment), it was on a 32 bit sql server. This worked fine.
The second time I wanted to set up replication (live environment), it was on a 64 bit sql server. This didn't worked fine.


I can't call the sqlcesa30.dll file on the 64bit server with IIS. So I called the dll via a remote IIS server.
This worked but gave me the following error when calling the following URL:
http://domain/PDASYNC/sqlcesa30.dll?diag

SQL Server Mobile Server Agent Diagnostics
2007/07/31 14:26:55


General Information


Item
Value

Server Name
domain

URL
/PDASYNC/sqlcesa30.dll

Authentication Type
Anonymous

Server Port
80

HTTPS
off

Server Software
Microsoft-IIS/6.0

Replication
Allowed

RDA
Allowed

Logging Level
0


Impersonation and Access Tests


Action
Status
ErrorCode

Impersonate User
SUCCESS
0x0

ReadWriteDeleteMessageFile
FAILURE
80070003


SQL Server Mobile Modules Test


Module
Status
ErrorCode
Version

SQLCERP30.DLL
SUCCESS
0x0
3.0.5207.0

SQLCESA30.DLL
SUCCESS
0x0
Unknown


Reconciler Test


Reconciler
Status
ErrorCode

9.0 Database Reconciler
SUCCESS
0x0

8.0 Database Reconciler
FAILURE
0x8007007E


SQL Server Module Versions


Module
Version

sqloledb.dll
2000.86.1830.0

9.0 replrec.dll
2005.90.2047.0

9.0 replprov.dll
2005.90.2047.0

9.0 msgprox.dll
2005.90.2047.0

8.0 replrec.dll
2000.80.760.0

8.0 replprov.dll
2000.80.760.0

8.0 msgprox.dll
2000.80.760.0


After seeing this I looked up what ReadWriteDeleteMessageFile could mean. It appeared to be some NTFS acces problem. But when I checked the security settings, it all seemed to be ok.

Has anyone any idea what else to check? Or is sure that I must have done something wrong?

Thanks in advance,
Arjan

View 3 Replies View Related

SQL Mobile Server 2005 To SQL Server Developer Edition 2000

Oct 30, 2006

I am looking for a detailed tutorial that explains how to set-up merge replication services for a major project. I have seen all of the claims that SQL Mobile Server 2005 is able to connect to a merge publication with SQL Server 2000. However, where are the tutorials? I must have a proof of concept in a few days to quote this project. Can anybody help with this issue? Thanks!

View 1 Replies View Related

MSDE &&amp; SQL Server 2005 Mobile Server Tools Problem

Jan 24, 2006

After installing MSDE(with SP4) and SQL Server 2000 SP4 Replication Components, the SQL Server 2005 Mobile Server Tools installation fails when running the System Configuration Check with a SQL Server requirement Error.

"You must first install the Replication Components for SQL Server 2000 SP 3a or higher or the SQL Server 2005 Replication Components"

Am I getting this error because I'm using the Desktop Engine version of the SQL Server 2000??

View 7 Replies View Related

SQL Server 2005 Mobile Edition Using Server Tools

Jan 20, 2007

I have installed SQL Server 2005 Mobile edition and also the server tools.

I configured a website to sync with my mobile application. When I go t check the SQL server Mobile agent with this url:

http://localhost/MobileTest/sqlcesa30.dll i get a http 500 internal error

I am using remote desktop to access the machine, when I am directly on the machine there is no error I get the correct message in the browser

"SQL Server Mobile Server Agent 3.0"

Is access to the web site via remote desktop a problem?

jawahar

View 1 Replies View Related

SQL Server Management Studio Can Not Connect To SQL Server Mobile

Jan 19, 2008



My System: SQL Server 2005 Express, Microsoft SQL Server 2005 Compact Edition, Vista 64

---

Hello@all,

my Problem is i can not connect on Server Management Studio with my SQL Server Compact (local).

here is the message in German:


TITLE: Verbindung mit Server herstellen
------------------------------

Es kann keine Verbindung mit '(local)' hergestellt werden.

------------------------------
ADDITIONAL INFORMATION:

Fehler beim Herstellen einer Verbindung mit dem Server. Beim Herstellen einer Verbindung mit SQL Server 2005 kann dieser Fehler dadurch verursacht werden, dass unter den SQL Server-Standardeinstellungen Remoteverbindungen nicht zulässig sind. (provider: Named Pipes-Provider, error: 40 - Verbindung mit SQL Server konnte nicht geöffnet werden) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=...=2&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

in the SQL Server Configutation Manage is all Protokoll Aktive, i habe testet with normal user Account and Admin Account... all not work...

Installet Software:
Microsoft SQL Server 2005
Microsoft SQL Server 2005 Compact Edition [DEU]
Microsoft SQL Server 2005 Compact Edition [DEU] Server Tools
Microsoft SQL Server 2005 Compact Edition Developer Software
Microsoft SQL Server Management Studio Express
Microsoft SQL Server Native Client
Microsoft SQL Server VSS Writer

Services running to SQL
SQL Server (SQLEXPRESS)
SQL Server VSS Writer
SQL Server-Browser

what is the problem here? please help me....

View 3 Replies View Related

Unable To Choose Server Type As 'SQL Mobile Server'

Oct 20, 2006

Hi,


i'm
running Microsoft SQL Server 2005 express edition. I'm trying to create
a new SQL server mobile database for my smartphone. when i launch
Microsoft SQL Server 2005 express edition, i was prompted to connect to
a server. But i can't choose Server Type as 'SQL mobile server'. My
server type is greyed out as 'Database engine'. i've already installed
SQL server mobile SDK and SQL server mobile tools.

i was following this guide :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/road03242004.asp

My
2nd question is how do i go about exporting a desktop version of a
database to my smartphone? I need to convert it to the mobile version
first right?


Any help would be greatly appreciated!!
thanks!!

View 1 Replies View Related

SQL Server Mobile Server Tools On Mutiple Servers ?

Nov 6, 2007

Hello,

I want to load-balance my PDAs accessing my database to make a merge replication.
As I have one server with the SQL Server Mobile Server Tools installed, can I configure some of these PDAs to use another server with SQL Server Mobile Server Tools to point on the same Database server?
Is it going to work or will it generate problems?

Thanks for your help,

Ben.

View 4 Replies View Related

Unable To Choose Server Type As 'SQL Mobile Server'

Oct 19, 2006

Hi,


i'm running Microsoft SQL Server 2005 express edition. I'm trying to create a new SQL server mobile database for my smartphone. when i launch Microsoft SQL Server 2005 express edition, i was prompted to connect to a server. But i can't choose Server Type as 'SQL mobile server'. My server type is greyed out as 'Database engine'. i've already installed SQL server mobile SDK and SQL server mobile tools.

i was following this guide :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/road03242004.asp

My 2nd question is how do i go about exporting a desktop version of a database to my smartphone? I need to convert it to the mobile version first right?


Any help would be greatly appreciated!!
thanks!!

View 3 Replies View Related

Copy SQL Server 2005 DB To SQL Server Mobile - Is It Possible?

Jul 27, 2006

I'm creating a prototype of a PDA app using CF.Net 2.0 and SQL Server Mobile for a prospective client and I've gone through and designed,
built and populated a database using SQL Server 2005... and then
realised where I really need it is on the PDA! Without going through
all the pain of setting up SQL replication or writing all the code is there a way to export a
2005 database to SQL Server Mobile so it results in an .SDF file?

I know I can script each table out and run it via the SS2005 management studio when connected to a local .sdf file then copy that to the PDA but the thing is I really want to keep my test data so I don't have to re-enter it again.

TIA for any help... there must be a way to do this but I'm quite new to SQL Server Mobile and 2005.

Mike

View 9 Replies View Related

SQL Server Mobile Parallel To SQL Server Compact?

Nov 24, 2006

Hi,

I'm a bit confused about the editions. Will SQL Server Compact v3.1 be a successor of SQL Server Mobile v3.0 (but with desktop and mobile targets) or will the two editions coexist with SQL Server Mobile on Smart Devices and SQL Server Compact on desktop PCs?

I'm drawing this conclusion because the CTP & now also the RC1 of SQL Server Compact are only compiled for desktops (and I've also seen that the .NET library is compiled against .NET Framework 2.0 desktop edition). If I'm wrong, why are no smart device CABs provided?

My second question:
Is the file format of SQL Server Mobile & Compact the same? Can I create a SDF file with the Compact Edition on the desktop, move it to the smart device and use it there with the "older" Mobile Edition? I'm asking, because we are starting a project where we need to create a SDF on the desktop, because of performance reasons.

 

Thanks in advance,
Klaus

View 5 Replies View Related

Performance Between SQL Server CE 2.0 And SQL Server Mobile 2005

Oct 3, 2007



We have recently updated an application from SQL Server CE 2.0 to SQL Server Mobile 2005 and we are seeing a huge decrease in performance? Is this normal? Database query that used to take 8 or 9 seconds are now around 20 secs, the database is only about 5 MB and the two tables in this particular query have 20 rows and 14K rows respectively. The query is basically:

select * from table1 join table2 on table1.myint = table2.myint

myint is the Primary Key of table2 and I have even created an index on myint for table1, any ideas?

Thanks - MTW

View 3 Replies View Related

Difference Between The SQL Server Express Bundled With C#/VB VS The Downloadable SQL Server Express SP1 With Advanced Services

Aug 31, 2006

What is the Difference between the SQL Server Express Bundled with C#/VB VS the downloadable SQL Server Express SP1 with advanced Services?

I installed C# with SQL Server Express, however I wanted to add the Full Text Searching and the SQL Server Management Studio Express, so I downloaded and installed the SQL Server 2005 Express Edition with Advanced Services SP1. When I installed it over top of my current installation, it complained of version mismatching, and then C# failed to recognize that I had SQL 2005 Express installed at all.



What I'd like to know is, which version is more current (they have to be different, they had different version numbers, one was 9.xx.xxxx the other was 2005.9.xx.xxxx) The one bundled with C#, or the SP1 downloadable one.

Firstly, I want to be up todate as far as security patches, and Secondly, how do I add the full text searching and SSMSE to the one bundled with C# without breaking it.

View 4 Replies View Related

Does SQL Server 2005 Express Support Web/Internet Replication To Other SQL Server Express Clients?

Jan 22, 2007

HI

Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS?

Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients?

Regards

View 5 Replies View Related

SQL Server 2005 Express Edition With SQL Server Management Studio Express (SSMSE)

Jun 7, 2007

Hi all,

I have installed SQL server 2005 express edition with SQL server Management studio express (SSMSE).

I have installed also SQLce and I would know how I can manage sql compact edition databases (.ldf) with sql SSMSE, if it is possible!

I would be grateful if you could explain it trought a detailed guide (I am a beginner user of sql server tools) or trought a link to useful sites.

I'm Looking forward for your reply and still trying...

Alessandro

View 1 Replies View Related

SQL Server Express Utility: How Can I Install SSEUtil.exe In My PC? How Can I Use It To Interact With SQL Server Express?

Nov 12, 2007

Hi all,

I downloaded the SSEUtilSetup.EXE and extracted the SSEUtil.exe to a folder of C:drive of my PC that is Windows XP Pro. I plan to learn the CLR programming via user-instance of SQL Server Express. I need to have SQL Server Express Utility installed. Please help and tell me how I can install SSEUtil.exe in my PC and how I use it to interact with SQL Server Express.

Thanks,
Scott Chang

View 2 Replies View Related

SQL Server Mobile

Apr 6, 2007

Hi,

I have created an SQL Server Mobile Database, is it possible to ODBC to it by creating a new data source, under admin tools in Windows XP?

Cheers

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved