microsoft.public.sqlserver.ce
  Home FAQ Contact Sign in
microsoft.public.sqlserver.ce only
 
Advanced search
January 2008
motuwethfrsasuw
 123456 1
78910111213 2
14151617181920 3
21222324252627 4
28293031    5
2008
 Jan   Feb   Mar   Apr 
 May   Jun   Jul   Aug 
 Sep   Oct   Nov   Dec 
2008 2007 2006  
total
microsoft.public.sqlserver.ce Profile…
RELATED GROUPS

POPULAR GROUPS

more...

 Up
  how to read and write a xml file into a PDA phone thru desktop vb.net application         


Author: justinnpravin
Date: Jan 31, 2008 04:58

hi all,
First thing is that , when a PDA is plugged in it shouuld detect the
connection and the desktop appln should start sync.. with the PDA to
get the config file.
based on config file the xml file should be copied to or read from
the specified path in PDA.

plz help me.
no comments
  Stop baby eating in CHINA         


Author: LPC
Date: Jan 29, 2008 07:44

no comments
  Boycott China Olympic- Comeon!         


Author: Imagiam
Date: Jan 28, 2008 17:50

So many dogs and cats being killed and ate in China, why you still support olympic?
no comments
  Boycott China Olympic- Comeon!         


Author: Imagiam
Date: Jan 28, 2008 17:50

So many dogs and cats being killed and ate in China, why you still support olympic?
no comments
  Need help with report writing         


Author: The Mad Ape
Date: Jan 28, 2008 12:45

Hello

I am using VB.Net 2005 CF and SQL Compact 2005 on my desktop. I have
sdf databases and I need to generate reports from them. I spent all
weekend trying to find software, tutorials, anything that would help
me generate paper reports from this type of database. I can not find
anything.

I would appreciate links to tutorials and good 3rd party tools because
everything I find is out of date or simply does not apply.

If anyone has an example to post that would be nice too. None of my
data is bound to any form. They are all created programatically and I
am constantly opening and closing different ones from within the same
application.

You help is appreciated.

Regards

The Mad Ape
www.tatumba.com
3 Comments
  I need help with my SQL Statement         


Author: The Mad Ape
Date: Jan 21, 2008 14:08

Hi I am using sqlce on my desktop and trying to write a query that
sums two fields. I am an Access guy and built this query there. When I
tried to use it in my application it crashes

Dim sqlStands As New SqlCeCommand("SELECT si_stand, Sum(si_size) AS
TotSz, Sum(si_samplelength) AS TotLen FROM(tblStandInfo) GROUP BY
si_stand ORDER BY si_stand", MyConn)

Error reads as follows:

SQLCe Exception was unhandled

There was an error parsing the query. [ Token line number = 1,Token
line offset = 89,Token in error = ) ]

I do not see the error. Please help.

Thanks

The Mad Ape
www.tatumba.com
6 Comments
  Re: Monitoring Windows mobile & MS SQL Server 2005 ME         


Author: Erik Ejlskov
Date: Jan 21, 2008 08:18

Maybe this can help you:
http://www.microsoft.com/windowsmobile/mobiledevicemanager/default.mspx ?

--
Erik Ejlskov Jensen
- see my SQL Compact blog at
http://erikej.blogspot.com

"Kalenik A." discussions.microsoft.com> wrote in message
news:11B65E25-4131-4389-87E0-8AC0055653E9@microsoft.com...
>I need to provide monitoring mobile devices using Windows mobile 6.0 and MS
> SQL Server 2005 ME. It have to be some counters for monitoring the mobile
> devices or Management Pack for MOM, or both, or somewhat else.
> Please, if who else have solved such task share info.
1 Comment
  Help With MS SQL Error: The value's length for key 'data source' exceeds it's limit of '128'.         


Author: Loogie
Date: Jan 21, 2008 04:12

have an .sdf database (MS SQL 2005 Compact) that was created on a
pocket pc. It now resides on the desktop. I wanted to open it and edit
it on the desktop. I am developing with Vb.2005.

I use the same connection string syntax that I use on the Pocket PC
but I get the error:

'The value's length for key 'data source' exceeds it's limit of
'128'.' from the code:

DESKTOP CODE: - Does not work
Dim saveconn As New SqlConnection("Data Source =" &
Application.StartupPath & "\Projects\" &
lvProj.Items(lvProj.SelectedIndices(0)).Text & "\Tally\" &
lvProj.Items(lvProj.SelectedIndices(0)).Text & ".sdf")
saveconn.Open()

PocketPC CODE: - Does work
Dim saveconn As New SqlCEConnection("Data Source = My Documents
\Projects\" & lvProj.Items(lvProj.SelectedIndices(0)).Text & "\Tally\"
& lvProj.Items(lvProj.SelectedIndices(0)).Text & ".sdf")
saveconn.Open()
Show full article (1.29Kb)
15 Comments
  Re: Unable to connect to Sql Server Compact Edition Database         


Author: Bill.NewsGroup
Date: Jan 21, 2008 03:25

On Jan 20, 5:01 pm, "Ginny Caughey [MVP]"
wasteworks.com> wrote:
> It sounds to me like the connection may be timing out across the Activesync
> link, but I don't  believe you could change the default connect timeout in
> VS 2005. Is there anything at all unusual about the database?
>
> --
> Ginny Caughey
> Device Application Development MVPwww.wasteworks.com
> Software for Solid Waste Management
>
> gmail.com> wrote in message
>
> news:1e132518-3be6-45b2-860a-a3ad4e3bf0ed@e10g2000prf.googlegroups.com...
> On Jan 20, 7:13 am, "Ginny Caughey [MVP]"
>
>
>
>
> ...
Show full article (2.08Kb)
no comments
  General Network Error         


Author: Andy Baker
Date: Jan 21, 2008 01:48

I have an VB.NET 2005 / CE.NET 5 application that has uses SqlClient to
connect to an SQL Server 2005 database to transfer data. I am getting
intermittent problems, occassionally the error message 'General Network
Error - Please check your network documentation' appears. It only happens on
transferring data from the device (SQL Mobile) to the main SQL Server
database, not the other way around. It has been suggested that this is to do
with timeouts, and I have tried adjusting the command timeout value but this
hasn't helped. The only think that I can think is that when I am
transferring data from the device, I am using transactions both on the SQL
Mobile database and the SQL Server 2005 database to ensure that either all
data is transferred and marked as transferred, or none of it...
Show full article (1.13Kb)
no comments
1 2 3