SQL MOBILE Connection Problem!!!

Jul 2, 2007

Hi all!!



As I said in a previous post, I am replicating information from SQL Server 2000 to SQL Mobile in my iPaq.



The test scenario was that I connect my iPaq to my laptop with Active Sync and to the server via LAN. This is working just fine.



My problem is that I need to replicate information from home to the server, but with a modem connection. I have my user and password, and if I access the mobile agent URL from the laptop via modem, it works fine (http://server/SqlMobile/sqlcesa30.dll), but I can't access from my iPaq.



Is there any additional config to the server or the iPaq that needs to be done so I can see the Mobile Agent?



Thanks in advance!

Jerry

View 1 Replies


ADVERTISEMENT

SQL SERVER Mobile Connection

May 19, 2007

How I can conect to SQL server mobile database using visual fox pro 9.0.

Is there ODBC driver for SQL server mobile?

View 3 Replies View Related

Remote Connection From Mobile Device...?

Jun 5, 2006

Hello,



I try to connect the SQL Server from the mobile device.

my connection string is:

string conn_str = "Server= 10.0.0.11;Database=theDB005;uid=bahadir;pwd=abcd;Trusted_Connection=false;";

when i try to open the connection I get SqlException,altough the 10.0.0.11 machine is reachable.. is not allowed to access a remote sql server with ip?



Thanks in advance.

View 1 Replies View Related

Connection From Windows Application To Mobile Device(*.sdf)

Jan 21, 2008



Hi,
I'm writing a windows application using VB.NET 2005 that must connect to Pocket PC via ActiveSync to read data from SQL Server CE. This is my code:


Dim cnn As New SqlCeConnection


cnn.ConnectionString = "Data Source =Mobile DeviceStorage CardProgram FilesMyAppMobileDB1.sdf"


cnn.Open()

But I get the following error:

The path is not valid. Check the directory for the database. [ Path = Mobile DeviceStorage CardProgram FilesMyAppMobileDB1.sdf ]

Any help would be greatly appreciated!
Leila

View 5 Replies View Related

Sql Server 2005 Mobile/RDA Connection Problem

Apr 14, 2006

I have a working Pocket PC 2003 app that uses RDA to exchange data with SQL Server 2000.  I'm attempting to port it to a Windows CE 5.0 device.   (I'll be porting to Mobile 5 in the near future, but the gadget I have at the moment is CE). 

I installed SQL Server 2005 Mobile Edition on the computer running IIS according to package directions, and used the wizard to set up a virtual directory with sscesa30.dll.

The directory I was previously using with sscesa20.dll is still there, and still works.

I set up the virtual directory to use basic authentication without SSL.  (I know that's not advisable).  I have confirmed that I can reach the URL using the username and password I supplied to the wizard.

When I try to pull data I get the following:

------------------- SQL CE Exception
Error Code: 80004005
Message   : An error has occurred on the computer running IIS. Try restarting the IIS server.
Minor Err.: 28022
Source    : Microsoft SQL Server 2005 Mobile Edition


I have tried restarting IIS without effect.  Any clues?

 

View 14 Replies View Related

SQL Mobile In Pocketpc 2003 Se Desktop Connection

Aug 2, 2006

Hi

I'm developing a pocketpc 2003 application with visual studio 2005. It has a sql server mobile sdf file call datos.sdf.

I need to create a Windows Desktop application and i need to connect it when pocketpc is connected to desktop with activesync.

Any ideas or links with some code samples?

I have installed sql sever everywhere but i don't understand how i can do that connection.

Thanks

View 3 Replies View Related

Connection String Encryption For SQL Server Mobile

Sep 28, 2006

I'm seeking suggestions on how to go about encrypting a database connection string in the compact framework. It's something that I thought would be relatively straight forward as I've accomplished it without much difficulty in the full framework, but I'm stuggling to find a solution.

I've been trying to implement a solution using public/private key asymmetric encryption using the RSA provider. I've essentially been trying to encrypt the connection string once on my development machine so that I can include both the encrypted connection string value and public key in either code or an external file. I'd then keep the private key out of harms reach. The problem I've encountered in doing this is that that RSA provider seemingly only allows new "in session" keys to be generated and I can't figure out a way of importing a public key from a file or other similar means.

I found the following code which is meant to allow a key to be retrieved from a signed assembly or an SNK file, which I've converted to VB but haven't been able to get working:

http://www.topxml.com/-NET-XML-System-XML/re-2963_Get-RSA-Public-key-from-Assembly-or-SNK-File.aspx

After the code seems to successfully prepare the CspParameters from an SNK files, I get an unspecified error when executing ImportParameters on the RSA provider.

I'd imagine this to be a common requirement, but haven't been able to find much information specific to the compact framework on the web. Any guidance would be much appreciated.

Thanks,
Steve

View 17 Replies View Related

SQL Server 2005 Mobile: Problem With Connection To Database

Aug 3, 2006

Hi, everyone! I have a small problem.

It consists in:

1. I'm trying to connect to database on my Pocket PC within Visual Studio 2005 (C#)

Connection string looks like this:

SqlCeConnection1.ConnectionString = "data source = '\storage card\mobiluser.sdf'";

But when i'm deploying it to Pocket PC the error "An error message cannot be displayed because an optional resource assembly containing it cannot be found" appears.

2. When I'm doing te same on Pocket PC Emulator everything is normal.

Off course, I have the .sdf file on Pocket PC which is placed to Storage Card into root directory.

If anyone knows where I get a mistake, help me please!



Thanks for your help!

View 1 Replies View Related

SqlCeConnection Failing To Open A Connection To The SQL Server 2005 Mobile Edition

Apr 15, 2008

Good day,

I am writing an application using VB.Net 2005 for the Windows CE 5.0 device and it is connecting to a SQL Server 2005 Mobile Edition Database.
The trouble I'm having is establishing a connection to a SQL Server Mobile database on the device.

Here is the code I am using:




Code Snippet
Public gConnectionString As String = "Data Source=Program FilesMobAppMobDB.sdf;Persist Security Info=False;"




Code Snippet

Imports System.Data.SqlServerCe

Public Class DBManager

Public Shared gSQLCEConnection As SqlCeConnection


Public Shared Function OpenDB() As Boolean

If gSQLCEConnection IsNot Nothing Then

Throw New InvalidOperationException("Connection already open.")
End If
gSQLCEConnection = New SqlCeConnection(gConnectionString)
Try

gSQLCEConnection.Open() 'Error occurs here
Return True
Catch ex As SqlCeException

MsgBox(ex.Message & vbCrLf & ex.HResult & vbCrLf & ex.NativeError & vbCrLf & ex.Source)
Return False
End Try
End Function


In the immediate window I recieve the following messages:


A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll

A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll

A first chance exception of type 'System.UnauthorizedAccessException' occurred in mscorlib.dll

A first chance exception of type 'System.UnauthorizedAccessException' occurred in mscorlib.dll

A first chance exception of type 'System.UnauthorizedAccessException' occurred in mscorlib.dll

A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll

A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll

A first chance exception of type 'System.UnauthorizedAccessException' occurred in mscorlib.dll

A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll


I believe that the first few lines are caused by the icons/pictures that I have included with my app, but the SqlCeException line occurs when the connection to the .SDF file is trying to be established.

Here is the exception output:

Message: "" (Blank)
HResult: -2147024882
NativeError: 0
Source: SQL Server 2005 Mobile Edition ADO.NET Data Provider

Programs under Remove Programs on the PDA are:
Microsoft .NET CF 2.0 ENU-String R...
Microsoft .NET Compact Framework...
Microsoft SQL Client
Microsoft SQL Mobile 2005
Microsoft SQL Mobile 2005 [EN]
Microsoft SQL Server 2005 Compact...
Microsoft SQL Server 2005 Compact...
Microsoft SQL Server 2005 Compact...
Microsoft SQLCE 2.0
Microsoft SQLCE 2.0 Dev

Any ideas on what could be stopping this connection from being established? It was working before but all of a sudden just stopped. I have warm booted, cold booted, and rebuilt with no luck and also checked that SQL Query Analyzer is not running on the PDA and that the connection string is valid.
The call to OpenDB occurs in the form_load of the startup object.

Thanks in advance,

Leon

View 8 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

SQL Mobile 2005 Replication - SQL Mobile DLL Could Not Be Loaded - Error 28559

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

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

Access SQL2005 MOBILE Database In A VS2003 Mobile App

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

Error #25123 A Sql Mobile DLL Could Not Be Loaded. Reinstall SQL Mobile.

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

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

VS 2005/SQL Server2005 - Direct Connection From Win Mobile Emulator To Desktop SQL Server 2000 Or 2005

Aug 10, 2007

Hello Everyone,

I'm trying to connect to Desktop SQL Server 2000 from Windows mobile PC Emulator (VS 2005). I need a direct connection using connection string to SQL Server 2000 through local wireless network without IIS.

Bellow is the code that I use. After executing this code I get an error on line Conn.Open(). Error says SQL Server does not exist or access denied.
SQL is un and running, and I can log in using SA username from the desktop. Even if I chance IP for another SQL server in my connection string I still get the same error. There is no firewall of any kind running.


Dim connectionSTR As String = "Persist Security Info=False;Integrated Security=False;Server=192.168.0.202,1433;initial catalog=MyDB;user id=sa;password=;"

Dim Conn As SqlConnection

Conn = New SqlConnection(connectionSTR)

Conn.Open()


If Conn.State = ConnectionState.Open Then
MessageBox.Show("Open")
End If


About my environment: SQL Server 2000 is running on Desktop PC with Windows XP SP2. Application which I need to connect to SQL Server is in Visual Studio 2005. I execute the application in Windows Mobile PC Emulator and try to connect to SQL Server from emulator.

Your advice and help is very appreciated

Thank you

Ika


View 3 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 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 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

Cannot Set Connection Property Of Backup Database Task If Connection String Is Customized In Connection Object

Aug 23, 2006

I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.

Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.

Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.

Is this an intrinsic issue?

View 2 Replies View Related

Failed OLEDB Connection: Cannot Aquire Connection From Connection Manager

Feb 6, 2008

I have a package that uses a for loop to iterate through an unknown amount of excel files and pull their data into a table. However, there will be cases when the file is corrupted or has some sort of problem so that either the transformation will fail or the excel data source will fail with an oledb connection error.
Could anyone suggest a clean way to trap these errors? Specifically, the "Cannot Aquire Connection from Connection Manager", which is the excel connection.

Thanks,

John T

View 3 Replies View Related

I Am Not Sure Whether I Can Use Sql Mobile.

Apr 12, 2006

Hi,

There are many text records need to be storeaged in my application.

I am new guy to Sql Mobile.

If I choose sql mobile to save my data. Will my app be more complex to deploy ?

Before I use Sql Mobile on device(wm5), need I install it first?

any other advice??

Best regards

PWang





View 1 Replies View Related

My Mobile DB.

Apr 11, 2006

Dear MSDN Support,

It is pleasurable being in contact with you and getting the desired support, for that i am feeling free inquiring about some aspects related to my graduation project.

Well here i am facing a problem with my database. I had created a full Pocket Pc project i added references, datasources and data connection for the SQL Mobile Database i am using. While i do an query like insert,update, delete, select it works on the pocket pc emulator and i check with the emulator query analyzer. What i am asking about that i am not able to see those updates in the mobile database in the sql server 2005 mobile edition, everything is done only in the emulator but after i exit the application and check my mobile server the database is still empty !!

I appreciate your hard working, and i do believe that there is someone here who is going to provide me with the support i need.

I am looking forward to getting your reply soonly.

Thank you for your attention.

Kindly Regards;

View 1 Replies View Related

SQL Mobile CAB

Apr 1, 2008



Hi,

I'm trying to install SQL Server 2005 Mobile on a Trimble GeoExplorer (GeoXT). It is running Microsoft Pocket PC v4.20. I've installed on a WM5 device without any problems, but can't seem to get it to work with this device. Regardless of what CAB I use, it says "Unsupported System Version" and will not install. I've tried using both:

sqlce30.wce5.armv4i.CAB
sqlce30.ppc.wce5.armv4i.CAB

, without any success. Any ideas??

View 6 Replies View Related

Asp.Net Mobile Web Application

Jan 22, 2008

I am geeting following error while trying to acquire db connection. I use sql server ce2.0 with vs2005
Failed to find or load the registered .Net Framework Data Provider

View 3 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

Mobile Notifications.

Apr 28, 2008

Hi

How to setup mobile notifications on jobs using SQL Server 2000. Aim is when a job fails I should receive SMS notification on my mobile phone.

Please show me web sites on this topic.

Please help.

Thanks & Regards


Raj.

View 1 Replies View Related

SQL 2005 Mobile Vs .NET CF 2.0 SP1?

Sep 22, 2006

Hi. I'd like to try a hand at SQL 2005 Mobile.

I've installed sqlce30.ppc.wce5.armv4i.CAB on an HP iPaq 1950 Pocket PC, provided by the Microsoft SQL Server 2005 Mobile Edition Device SDK, http://www.microsoft.com/downloads/details.aspx?FamilyId=5BD8ABAA-5813-4DB3-B23A-24551DE2ECC1&displaylang=en

When I tried to interact with it, I got an error message that the .NET Compact Framework 2.0 was missing on the pocket PC.

So I installed the .NET CF v2.0 SP1 found at http://www.microsoft.com/downloads/details.aspx?familyid=0c1b0a88-59e2-4eba-a70e-4cd851c5fcc4&displaylang=en and it updated both the local machine and the Pocket PC.

However, now when I use my local SSMS to talk to the SQL Server Mobile Engine, I keep getting the error:

Microsoft SQL Server 2005 Mobile Edition and/or .NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding. (SQL Server Mobile Edition ADO.NET Data Provider)

(Now I know I can communicate with the Pocket PC because I browse out to it first)

Am I missing something more fundamental, or does this not work with a non-RTM framework?

View 1 Replies View Related

SQL Mobile Support For CE 4.2

Aug 8, 2006

An update was supposed to be released for SQL Server Mobile which enabled support for CE 4.2. This was supposed to be released around the time of CF 2.0 sp1. SP1 came out over a month ago and there is still no sign of the SQL Mobile update. Does anyone have any information on a release date ?

View 6 Replies View Related

Mobile Replication

Aug 11, 2006

I have the following setup



Server 1: Windows 2003 inc IIS. Also on this server is SQL Server Web sync web service and it has an external IP address for internet connectivity

Server 2: Windows 2003 inc SQL Server 2005. This server has a database setup with replication so the a Window Mobile 5 device can do a merge replication.



My problem is that the replication fails when trying to send the snap shot from Server 2 to the mobile device. The device seems to get through to the replication agent, as entries in the Replication monitor are logged (see below).

I have checked all the permissions on the relevant shares required for replication (basically set "Everyone" with full access).

My initial question would be.... When the snapshot is been sent to the mobile device, does the SQL Server try to send it directly to the internet or does it go through "SQL Server Mobile Server Agent 3.0".

Please can someone help, as this is causing me some REAL problems.

Error messages:
The schema script '\ukrt1-sql902SQLRepluncUKRT1-SQL902_EXEL_DAMAGECODESEXEL20060810142533DamageAction_2.sch'
could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147023570)
Get help: http://help/MSSQL_REPL-2147023570

The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization,
the merge process may have been unable to create or write to the message file. When troubleshooting,
restart the synchronization with verbose history logging and specify an output file to which to write.
(Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001


View 1 Replies View Related

SQL CE 2.0 And SQL Mobile 2005

May 10, 2006

Hi,

I would like to know if we can install both versions of mobile SQL (SQL CE 2.0 and SQL Mobile 2005) on the same PDA. I know that two versions of CF .Net can be installed.

Indeed, I have an old CF .Net 1.3 application connecting to a SQL CE 2.0 database and a new one using CF 2.0 and SQL Mobile 2005. The first one will be migrated but in the future ... Meanwhile, the customer wants to run the two applications without any code modification.

Is it technically possible ? Is it recomended ?

Thanks in advance for your answers.

View 1 Replies View Related







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