[Ask]Getting Files From Pocket Pc Emulator To Desktop Pc

Jun 8, 2006

hi...!
I'm creating a small device application using visual studio.NET 2003. Is it possible to get a sql server ce database file (.sdf) that i created at the pocket pc emulator to my desktop pc ?
If that's possible, then can you tell me how to do that ??

thanx b4

View 5 Replies


ADVERTISEMENT

RDA - Vb 2005 App - Desktop && Pocket Pc Emulator - Error: 80072F76 Native Error: 28035

Oct 12, 2006

RDA - vb 2005 app - desktop & pocket pc emulator - error: 80072F76 native error: 28035

PDA info:
.NET CF 1.0 env-string...
MS SQL client
MS SQLCE 2.0 dev
MS SQLCE 2.0

DESKTOP info:
Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

copied an app from http://www.codeproject.com/netcf/PocketPCwithSQLCE/PocketPCwithSQLCE_Src.zip
modified its CONFIG.XML to...
<?xml version="1.0" encoding="utf-8" ?>
<Configuration>
<DatabaseServer>192.168.1.89</DatabaseServer>
<DatabaseName>D1Temp</DatabaseName>
<DatabaseLogin>sa</DatabaseLogin>
<DatabasePassword></DatabasePassword>
<SQLCEURL>http://192.168.1.89/SqlMobile/sqlcesa30.dll</SQLCEURL>
<LocalDBConnect>Provider=Microsoft.SQLServer.OLEDB.CE.2.0; Data Source=My DocumentsMyFav.sdf;</LocalDBConnect>

<LocalDBLocation>My Documents</LocalDBLocation>
<LocalDBName>MyFav.sdf</LocalDBName>
<IISLogin>192.168.1.89/Jason</IISLogin>
<IISPassword>batman2005</IISPassword>
</Configuration>

error is "Header information is either corrupted or missing. [,,, header name,,]"

have spent weeks google-ing trying to get this to work, to no avail.
Has ANYONE got RDA PULL to work with above setups?

View 1 Replies View Related

Can't Open .sdf DB On Emulator (Pocket PC)

Mar 28, 2008

Hi,

I'm a developer of VB.NET mobile applications at work. We have used Access in the past, and manually pushed flat files to and from the scanner. We are now exploring SQL CE.

Trouble is, I am having a difficult time figuring out how to open SQL CE databases on the Pocket PC emulator. I've worked more on the middleware programs in the past - and have just dealt with ADO.NET connection strings - not the actual development on the scanner itself.

I am try to figure out how to actually connect to SQL Server CE on the Pocket PC 2003 SE emulator.

When I deploy the application on the emulator, it installs SQL Server CE onto the emulator. However, I'm not sure how to install the sample database (starting off with Northwind.sdf for testing purposes) onto the emulator. I'm also not positive the connection string is correct - as it seems to be different than typical ADO.NET.

Here's my code (for connecting to the database) so far.





Code Snippet

Public Class SampleInventorySystem

Private _conn As SqlCeConnection
Public Sub New()

' This call is required by the Windows Form Designer.
InitializeComponent()


_conn = New SqlCeConnection("Data Source = .Northwind.sdf") 'This is one of 'many connection strings I've tried



End Sub
Private Sub SampleInventorySystem_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load


Dim cmd As New SqlCeCommand()


cmd.Connection = _conn
cmd.CommandText = "SELECT [Employee ID], [Last Name], [First Name], Photo FROM Employees"




Try


_conn.Open()
Catch ex As Exception
MessageBox.Show("Error opening database", "Error")
End Try

End Sub

End Class
When I deploy the application, the Try Catch block catches the error "Error Opening Database". I've also tried putting the full path for the connection string. Is there a folder which I should directly put the .sdf file into the emulator - similar to the folder directory of the scanner? (i.e. Storage Card/...)

Thanks for your help!

View 4 Replies View Related

Connecting To Sql Server 2005 From Pocket Pc 2003 Emulator

Nov 12, 2007

Hi. I have a problem. I'm working at the moment on application witch should write and read data from sql server. The application should work on windows mobile devices. I'm linking this code to event on a button:





Code Block private void menuItem1_Click(object sender, EventArgs e)
{

SqlConnection sqlCon;
sqlCon = new SqlConnection(String.Format(@"Data Source={0};Initial Catalog={1};User ID={2};Password={3}",
@"192.168.54.149sqlexpress", "MojDom", "kuba", "abuk"));
sqlCon.Open();

string insertString = @"insert into {0} values ('{1}', {2})";
SqlCommand cmd;

cmd = new SqlCommand(string.Format(insertString, "MojDom", "Kuba", 15), sqlCon);
cmd.ExecuteNonQuery();


if (sqlCon.State == ConnectionState.Open)
sqlCon.Close();

}



and on line sqlCon.Open() i get exception:




Code Block

System.Data.SqlClient.SqlException was unhandled
Message="SqlException"
Class=20
LineNumber=0
Number=6
Procedure="ConnectionOpen (Connect())."
Server="192.168.54.149\SQLEXPRESS"
Source=".Net SqlClient Data Provider"
State=0
StackTrace:
at System.Data.SqlClient.SqlConnection.OnError()
at System.Data.SqlClient.SqlInternalConnection.OnError()
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Connect()
at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin()
at System.Data.SqlClient.SqlInternalConnection..ctor()
at System.Data.SqlClient.SqlConnection.Open()
at AIHouse.FormMain.menuItemSettings_Click()
at System.Windows.Forms.MenuItem.OnClick()
at System.Windows.Forms.Menu.ProcessMnuProc()
at System.Windows.Forms.Form.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
at AIHouse.Program.Main()
And when im using exactly the same code in windows console application everytihng works fine when i run it on pc with sql server and emulator, or other pc connect to network. I'm working on emulator of Pocket PC 2003, I've "put" it in cardle and the emulated device has connection to my pc and internet, the firewall is off.

I really dont have any idea why it's not working.

sorry for my english, but its not my foreign language.

thx for sugestions and reply.

regards Kuba

View 3 Replies View Related

Cannot P/Invoke SQLCEME30.DLL When Debugging Pocket PC 2003 SE Emulator

Sep 22, 2006

I'm trying to debug an assembly with System.Data.SqlServerCe - and when I deploy to a IPAQ 2210 - I get no errors! Alas, when I try to debug using the Pocket PC 2003 SE Emulator - I get the "cannot P/Invoke SQLCEME30.DLL" exception.

Can anyone offer directions?

best regards,
Walther

View 9 Replies View Related

HELP: SqlCeConnection Path Error In .NET Compact Framework (Pocket PC Emulator)

Apr 4, 2007



Hi all,



I am trying to access my SQL Server database through SqlCeConnection:



cecon = new SqlCeConnection("Data Source=D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf");

cecon.Open();



I am getting the following error:



System.Data.SqlServerCe.SqlCeException was unhandled
Message="The path is not valid. Check the directory for the database. [ Path = D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf ]"
HResult=-2147467259
NativeError=25009
Source="SQL Server 2005 Mobile Edition ADO.NET Data Provider"
StackTrace:
at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at nddbpda.frmCeMain.frmCeMain_Load()
at System.Windows.Forms.Form.OnLoad()
at System.Windows.Forms.Form._SetVisibleNotify()
at System.Windows.Forms.Control.set_Visible()
at System.Windows.Forms.Application.Run()
at nddbpda.Program.Main()





When I tried to get the path from which the database file is being accepted, I got a different path:



string path;

path = System.IO.Path.GetDirectoryName(

System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);

MessageBox.Show(path);



This code gives me this path:



Program Filesddbpda





Then I changed the path in my connection string to this:



cecon = new SqlCeConnection("Data Source=\Program Files\nddbpda\nddbpdadatabase.sdf");

cecon.Open();



When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).





What should I do now to correct this?



Thanks in advance.

Saswata.



View 3 Replies View Related

HELP: SqlCeConnection Path Error In .NET Compact Framework (Pocket PC Emulator)

Apr 4, 2007



Hi all,



I am trying to access my SQL Server database through SqlCeConnection:



cecon = new SqlCeConnection("Data Source=D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf");
cecon.Open();




I am getting the following error:



System.Data.SqlServerCe.SqlCeException was unhandled
Message="The path is not valid. Check the directory for the database. [ Path = D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf ]"
HResult=-2147467259
NativeError=25009
Source="SQL Server 2005 Mobile Edition ADO.NET Data Provider"
StackTrace:
at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at nddbpda.frmCeMain.frmCeMain_Load()
at System.Windows.Forms.Form.OnLoad()
at System.Windows.Forms.Form._SetVisibleNotify()
at System.Windows.Forms.Control.set_Visible()
at System.Windows.Forms.Application.Run()
at nddbpda.Program.Main()






When I tried to get the path from which the database file is being accepted, I got a different path:



string path;
path = System.IO.Path.GetDirectoryName(
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
MessageBox.Show(path);






This code gives me this path:



Program Filesddbpda






Then I changed the path in my connection string to this:



cecon = new SqlCeConnection("Data Source=\Program Files\nddbpda\nddbpdadatabase.sdf");
cecon.Open();






When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).





What should I do now to correct this?



Thanks in advance.



Saswata.

View 5 Replies View Related

¿Data Transfer Pocket PC &&<--&&> Desktop PC?

Apr 12, 2006

Hi,everyone!

I'm new to this forum and also new to Visual Studio 2005 .NET.

I'm going to develop a pocket pc(windows mobile 2005) application which needs to save some data introduced by the user.Later that data should be syncronized with MS SQL Server database.

The application is going to be developed using Visual Studio 2005 with c#.

So I'm doubting wich is the best way of syncronising the data between Pocket Pc and a Desktop PC.Should i use MS SQL Server Mobile(RDA,Merge Replication) or XML(Xml Web Services) would help me better?Or is there any other better way of data syncronization/storage?

Could anyone help me,or post some links + code samples,please?

Thanks!

View 1 Replies View Related

Can Not Connect To Desktop Sql Database From Mobile Device (Pocket PC)

Apr 4, 2006

Hi,

I am developing an application for a Pocket PC (PPC). I am using Visual studio 2005, and the Operating system on this PPC is Window Mobile 2003 SE. The followings are my codes to connect PPC with the database on my PC with sql server 2005. But when I cick the button1, the error with "SQL Server does not exist or access denied." Any ideas? Thanks a lot.



Imports System.IO

Imports System.Data

Imports System.Data.SqlClient

Imports System.Math

Imports System.Drawing

Imports System



Public Class Form1

Dim strConnection As String = "Server=localhost;Integrated Security=SSPI;database=AdventureWorks"

Dim strQuery As String

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Label1.Text = "Hello, Clicking after."



ReadOrderData()

End Sub



Private Sub ReadOrderData()

Dim queryString As String = "select * from Person.Address where AddressID < '10'"

Using connection As New SqlConnection(strConnection)

Dim command As New SqlCommand(queryString, connection)

connection.Open()

Dim reader As SqlDataReader = command.ExecuteReader()

While reader.Read()

MsgBox(String.Format("{0}, {1}", _

reader(0), reader(1)))

End While

reader.Close()

End Using

End Sub

End Class

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

Referencing To System.Data.SqlServerCe Causes Large Files To Deploy To Emulator

Dec 8, 2006

Hello everyone,

This is my first time posting here, I hope this questions has not been asked before. I tried to search for it but I came not with nothing.

Recreating the error :

I am using VS2005. I created a Pocket PC 2003 project.
I have downloaded the SQL Server Compact Edition and installed it. I get the System.Data.SqlServerCe.dll file from the installation directory.
I reference to that DLL using Add Reference in VS2005.

Build it. In the Bin folder, a long list of files suddenly appears.

System.data.dll
System.data.oracleClient.dll
system.web.dll
system.enterpriseservices.dll
system.enterpriseservices.wrapper.dll
system.transactions.dll
and the rest of your original files in Bin

The worst of it all, all of these files are deployed into the Emulator! Causing it to run out of memory and unable to deploy.



Something is not right here, I just cannot figure it out! If this happens, each mobile devices can hold one applications. Thats not the way it should be, right?

If you have solved this before, do help. I am at my wits end at the moment.

Thanking you in advance.

Sincerely,
Lasker

View 1 Replies View Related

Need To Edit .sdf Files From Local Desktop

Mar 10, 2006

I am needing to know if there is a way to edit .sdf files from my local desktop ( I need to copy the .sdf file to my local machine and edit the information if necessary)

Our mobile devices use SQL CE 2.0.

Thanks for your help

View 4 Replies View Related

What Is Necessary To Create SDF-Files On Desktop Legally?

Nov 7, 2005

I want to write a PC application that prepares a SQL Server Mobile Files (.SDF) and sends it to a PocketPC.
I get this error message:

View 47 Replies View Related

Synchronize 2 Sdf Files On 2 Pdas With/without Desktop Application

Jun 10, 2007

Hi All,

I am interested in synchronising 2 sdf files which are sitting on 2 different PDAs and I want to synchronise both of them with or without desktop application. C# applications are used to talk to the applications.

Is it possible or not and if possible how can i do that. Any code snippets or any links to similar forum posts or anything will be of great help. I am a C# programmer but not SQL Developer.

Regards
Trushar

View 1 Replies View Related

Appears To Load 3.0 In Emulator Instead Of 3.1

Feb 12, 2007

Here's what I did to a VS2005 Smart Device application.


Removed the reference to System.Data.SqlServerCe.dll.
Set a reference to C:Program FilesMicrosoft SQL Server Compact Editionv3.1SDKinwce500 System.Data.SqlServerCe.dll.
While it€™s loading in the emulator I notice that it appears to still be loading SQLCE3.0 instead of 3.1.
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0wce500ARMV4isqlce30.ppc.wce5.armv4i.CAB'
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0wce500ARMV4isqlce30.repl.ppc.wce5.armv4i.CAB'
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0wce500ARMV4isqlce30.dev.enu.ppc.wce5.armv4i.CAB'

Do I need to set something else?

View 1 Replies View Related

INSERT Not Working Via Emulator SmartPhone WM 5.0

Apr 8, 2006

It would be great to get some feedback on this, I've wasted nearly the whole day trying to figure it out.

I've created a simple test database called test.sdf. It contains a few tables but no data. My plan is to populate the database programatically; however, the INSERT command does not seem to be working correctly. I can see that the data actually gets added to the database when I add it and iterate over it programatically (using SqlCeCommands), but after the program completes and I look at the Table in "Server Explorer" via VS 2005, the data is no longer there!

Now note that the location of the sdf is in the Emulator's "shared folder." I have read from other posts (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=173589&SiteID=1) that you cannot create a database on emulated "storage card" with PPC 2005 emulators but I've read nothing about modifying a database which exists there. Unfortunately I do not currently have access to a "real" device so I can't test this in any other way.

Here's the test function:

public void Test()

{

SqlCeConnection conn = null;

try

{

conn = new SqlCeConnection();

conn.ConnectionString = @"Data Source = Storage Card est.sdf";

conn.Open();

SqlCeCommand cmd1 = conn.CreateCommand();

cmd1.CommandText = "INSERT INTO Customers VALUES ('Joe Schmoe')";

int n = cmd1.ExecuteNonQuery();

cmd1.CommandText = "INSERT INTO Customers VALUES ('Alice Wonderland')";

n = cmd1.ExecuteNonQuery();

SqlCeCommand cmd2 = conn.CreateCommand();

cmd2.CommandText = "SELECT * FROM Customers";

SqlCeDataReader rdr = cmd2.ExecuteReader();

//this correctly prints out Joe Schmoe and Alice Wonderland

while (rdr.Read())

{

String str = rdr.GetString(0);

Console.WriteLine(str);

}

rdr.Close();

}

finally

{

conn.Close();

}

}

After running this test function, I open the Customers table in VS2005 and no Customer rows exist despite the fact that the SqlCeDataReader correctly iterated through the previously added 2 customers.

View 6 Replies View Related

Why I Can't Connect Sql Server 2000 With Wm5 Or Emulator ?

Feb 26, 2006



Why I can't connect sql server 2000 with wm5 or emulator ?

I used windows server 2003, sql server 2000 Enterprie SP4, visual studio 2005.

My this code can connect to sql server with win application (.net framework 2.0) but can't connect to sql server with device application (.net compact framework).

Dim strcon As New SqlConnection("Data Source=192.168.0.3;Initial Catalog=nortwind;User ID=sa")

Try

strcon.Open()

Dim sqlcom As New SqlCommand("select * from products", strcon)

Dim s As String = sqlcom.ExecuteScalar.ToString

Catch ex As Exception

MessageBox.Show(ex.Message.ToString, "")

Finally

strcon.Close()

End Try

Question

1. How to tip for setup and config windows server 2003 and sql server 2000 can connect with device?

2. What's IP of device in running ?

View 23 Replies View Related

Emulator Error To Replicate Data On SQL Server

Aug 18, 2005

Hi Guys,

View 7 Replies View Related

Create Device In Emulator From Management Studio

Nov 22, 2006

Hi,

i know i have the chance to access my mobile device (physical or emulator) from Management Studio.
I went to Connect Object Explorer, server type Sql Server Mobile but i can´t connect to my emulator and i can´t see any way to connect to a physical device either. How can i do this?

The only thing i can do is create a sql server mobile database (.sdf).

Thanks
SP

View 3 Replies View Related

Wrong Version Of SQL Server Mobile Deployed To Emulator?

Feb 2, 2006

I am developing a mobile application with Visual Studio 2005 RTM. I created a .SDF database from scratch within the Server Explorer window. Based on the properties of the database, this is a version 3.0 DB. I then deploy the application to the Pocket PC 2003 SE Emulator and I receive an error when trying to open the database from my app. It's a very generic error:

System.SData.SqlServerCE.SqlCEException

I trap the error in my code, but there is no message in the exception object.

If I try to open it with Query Analyzer on the device, I get an error stating "The file is not a valid database file". It appears that SQL CE 2.0 was deployed to the emulator.

I noticed that when I add a reference in my project to the System.Data.SQLServerCE namespace, it defaults to this DLL:

C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev2.0System.Data.SqlServerCe.dll

I tried removing that and manually adding a reference by browsing to this 3.0 DLL:

C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0System.Data.SqlServerCe.dll

I then receive the following build error:

Unable to load referenced library 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0System.Data.SqlServerCe.dll': Version 2.0 is not a compatible version.

If I build the database in my application from scratch from within my code, everything works fine, which I believe is because it is a 2.0 database that is generated.

To make a long story short:

How do I get my project to reference the 3.0 SQL Server CE namespace and deploy it to the emulator?

View 1 Replies View Related

Reference To Data.System.SqlServerCe In VS2005 Does Not Install CE 2.0 To Emulator/PDA

Feb 3, 2006

We have a Compact Framework 1.1 application that uses Sql Server CE 2.0. In VS2003, a reference to System.Data.SqlServerCe causes the Sql Server CE dlls and Query Analyzer to install to the Emulator or PDA.

I am currently converting the application to Compact Framework 2.0, but we are not upgrading to Sql Server Mobile (yet). However, the reference to System.Data.SqlServerCe, in VS 2005, no longer causes Sql Server CE to install to the PDA/Emulator.

There is a difference in the build outputs between VS2003 & VS2005. In 2003, System_SR_enu.cab, sqlce.wce4.x86.cab & sqlce.dev.wce4.x86.cab are copied & lanuched. In 2005, only System_SR_enu.cab is copied... no launch.

Any ideas? Reinstall VS2005?

View 3 Replies View Related

Printing From Pocket PC

Mar 1, 2004

Hi,

I am developing an applicaiton through which, i want to print from pocket pc emulator 2003. I am using PrinterCE.NETCF SDK to do this task. I am able to print from my applicaiton like we do in ASP (Printing one line at a time). In PrinterCE, there is an option of printing the output to a file. But, I am not able to find how we do it.

So, I want to know how we can print the output through PrinterCe into a file. Can anybody help me??

thanx and regards
ramesh chandra

View 1 Replies View Related

Pocket PC And SQL Server CE.

Jul 20, 2005

Hi,How to replicate data from SQL Server CE (Pocket PC) to MSDE using C#(data size = from 2 to 10 MB)?--*Best regards,*Klaudiusz Bryja

View 1 Replies View Related

MSSQServer 2000 For Pocket Pc

Jan 12, 2004

Hi to all.
I have a windows ce mssqlserver 2000 version.
I have writted a java application and i needed a database connection.
I wish a driver for execute the connection to mssql server 2000 into pocket pc.

The connection string that i use is

connessione = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=A&MMobile", "sa", "sa");

Ok?

Which are the driver that i needed?

Thanx,

Simona

View 8 Replies View Related

Syncronize Pocket Pc, VB.net And Ms Access

Aug 27, 2007

I have developed an application using visual studio 2005 and I am trying to figure out how to store the data on the pda and sync it with a dadabase on the pc. we have a database server but it is only have sql server 2000. i have only been able to find instruction for sqlserver 2005. can anyone help.

thank you
Tony

View 1 Replies View Related

Urgent: Drop Database On Pocket PC

Apr 10, 2004

Hi,

Any body please give me any reference to the C# code, how to drop a database on SQL SERVER CE.

thanx and regards
ramesh chandra

View 1 Replies View Related

Unable To Call SQL View From Pocket Pc

Apr 13, 2007



When I try to do a pull using a view I'm getting the following error message:



€œThe query cannot be tracked. There might not be a primary key, or the query might involve multiple tables. [ Query string = SELECT * FROM DATABASE_NAME.viewname ]€?



but when I do a select col1 from view I get my data. The view has some inner joins included in it, could that be the issue?



NOTE: this is from my handheld device, its not SQL Server related. I posted this earlier in this forum but it was moved to SQL Server.

I get the error on my handheld device and handheld device only

View 4 Replies View Related

Pocket PC Application Cannot Push Data

Mar 17, 2008

I have a Pocket PC application (VS2005, SQLCE 2005, Windows Moblile 5.0, SQL Server 2000) that can pull data with no problem but produces an error when an RDA push is attempted. The error message is: Error Code: 80072EE4 Minor Err: 28037. The information in TechNet has description of : A request to send data to the computer running IIS has failed. For more information, see HRESULT. It does produce a log in the folder for SQLCE 3.0 and has the following message: Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1. Not sure if this means anything because I can't find much information on it. Anyone have any ideas on what this could be? Do I display the HRESULT the message mentions in Visual Studio debug? We have this working on our development server so I am not sure what is different here.

View 5 Replies View Related

Problem On Running Replication On Pocket Pc

Mar 14, 2006

hi i tried to view a replication on a pocket pc app that i created. and i used the following code

private void Sync()
{
public string AppPath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
SqlCeReplication repl = new SqlCeReplication();

repl.InternetUrl = @"http://naomi/sqlmobile/sqlcesa30.dll";
repl.Publisher = @"Naomi";
repl.PublisherDatabase = @"SQLMobile";
repl.PublisherSecurityMode = SecurityType.DBAuthentication;
repl.PublisherLogin = @"sa";
repl.PublisherPassword = @"<...>";
repl.Publication = @"SQLMobile";
repl.Subscriber = @"SQLMobile";
repl.SubscriberConnectionString = @"Data Source=""" + AppPath + @"SqlMobile.sdf"";Max Database Size=128;Default Lock Escalation =100;";
try
{
repl.AddSubscription(AddOption.ExistingDatabase);
repl.Synchronize();
}
catch (SqlCeException e)
{
MessageBox.Show(e.ToString());
}

when i run it i keep on getting the error:
The SQL Mobile Subscription already exists. Publisher, PublisherDatabase, and Publication for this subscription should be different from any existing subscription.

However, i can still view the contents of the datagrid that refers to the database subscription.

1. What should i do in order to stop getting the error above?
2. If i edit the contents of the datagrid in the pocket pc app how will i update the replication in the sql server? thanks

View 1 Replies View Related

Synching SQL Server Data On A Pocket PC And Windows?

Jan 30, 2008

I asked this question on another forum, and it was suggested that using SQL Server might be the way to go.

What I would like to do is create a database that can store detailed employee payroll information for workshop production. Included in this db would be employee info, job details, hours worked, pay rate, and so on and so forth. That will probably be the relatively easy part.

I would like to allow supervisors (job coaches) to enter this data on a Pocket PC (windows mobile) device, and then be able to synchronize the pocket pc to a workstation, allowing their data to be uploaded to the main database at the end of the day.

Can that be done using SQL Server as both the main networked database as well as having it (or a lite version of some sort) installed on a Pocket PC for synchronization purposes as described above?

Thanks for any input.

View 1 Replies View Related

How To Develop Today Screen Plug In For WM5 Pocket PC

Apr 17, 2007

Hi, anybody help me how to develop Today Screen plug in for WM5 pocket pc.

View 1 Replies View Related

Porting Database Functions From WM 5 Pocket PC To WIN32

Apr 21, 2008

Hi all,

I'm working on porting a solution running under WM 5 Pocket PC to Win32 but I got some problems with type definitions like CEOID, CEGUID... I saw that these types are defined in windbase.h (EDB definition added to preprocessors) ) which includes types and definitions usefull for database managment. Anyway this header file is not present in C:Program FilesMicrosoft Platform SDK for Windows Server 2003 R2Include, so I was wondering which is the header file I can use instead of it. Thanks

View 5 Replies View Related

How To Start Develop Database Applicaton On Pocket Pc ?

Jul 27, 2006

i have install vs2005 and wm5 sdk on my pc. i want to develop database application on my pocket pc (database = sqlserver 2005 express)

- i need to install another software on my pc or pocket pc ?
- how to start develop database application on my pocket pc?

thank you

View 1 Replies View Related







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