Stack Overflow
Stack Overflow

Questions tagged [sql-server-mobile]

10 questions
4
votes
6 answers

Database engines Comparison - Windows Mobile

What are the different database options on Windows Mobile available? I have used CEDB and EDB for linear dataset needs. I have heard of SQL server 2005 Mobile edition. But what are the advantages over others (if there is any)
prakash
  • 58,901
  • 25
  • 93
  • 115
3
votes
3 answers

How to use the same parameter more than once in a query

I want to run a query similar to this one on a SqlCE database: SELECT t.Field1, t.Field2 FROM MyTable t WHERE t.Field1 = @Param UNION ALL SELECT t2.Field1, t2.Field2 FROM MyOtherTable t2 WHERE t2.Field1 = @Param However, running this results in the…
Daan
  • 6,952
  • 4
  • 29
  • 36
2
votes
1 answer

Accessing an SDF SQLServer Mobile file from Java

Here at work we want to access the data inside a .sdf file generated in a PDA with SQLServer Mobile Edition. We use the SqlJDBC4 packet for JDBC but can't get into the server. We know it's running because we can telnet into it, but from the Java…
Saiyine
  • 1,579
  • 3
  • 15
  • 27
2
votes
3 answers

How to read remote XML file the most efficiently way?

I am developing a little app that retrieves an XML file, located on a remote server (http://example.com/myfile.xml) This file is relatively big, and it contains a big list of geolocations with other information that I need to use for my app. So I…
guigui42
  • 2,441
  • 8
  • 35
  • 48
1
vote
0 answers

Mobile reports custom url in SSRS

I am trying to pass a drillthrough custom url in SSRS Mobile Reports using values from my database, the problem is that my value contains special characters like "/" which look to be converting to %2F causing the hyperlink to break. Is there any way…
GVal
  • 87
  • 2
  • 7
1
vote
1 answer

Is it safe to open the same .sdf database file from two WinMo different applications?

I have two Windows Mobile 6.1 applications that use the same MS SQL Server Mobile database. They might select and update data in the database at the same time. The database is kept in one .sdf file. I don't know how the MS SQL mobile version works.…
Greg Dan
  • 6,198
  • 3
  • 33
  • 53
1
vote
1 answer

The best way to update a table on Windows CE device from Server

I need to modify an existing Windows CE app which gets it data from SQL Compact database (sdf) to update the database table (only 1 table) with latest records from a SQL Server Express when ever it is docked to the machine. I came across Microsoft…
fujiFX
  • 413
  • 9
  • 18
0
votes
0 answers

Is SQL Server Mobile Report Publisher is compatible with connecting to SQL data warehouse?

Is it possible to for SQL Server Mobile Report Publisher to connect with SQL data warehouse?
Pooja
  • 71
  • 1
  • 9
0
votes
1 answer

Mobile Report Publisher. "Time chart" and "Number with delta" gauge

I have some questions about SSRS 2016 Mobile Report Publisher. Is there any possibility to change the appearance of lines (style, color, thickness) in Time chart gauge? It seems that there is no standard way to do that. Screenshot - Time chart line…
Natalie
  • 1
  • 2
0
votes
1 answer

SQL Server 2016 Mobile Report Datasets Expire about 30 Days

We are in the process of creating a suite of SQL server 2016 Reporting Services Mobile Reports for our company’s Cloud offering to customers, however, we keep running into a situation where the all datasets expire after a certain time. We have found…
surGe
  • 135
  • 2
  • 11