I need help with my SQL Statement
Mon, 21 Jan 2008 14:08:16 -0800 (PST)
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) GRO ...
|
Help With MS SQL Error: The value's length for key 'data source'
exceeds it's limit of '128'.
Mon, 21 Jan 2008 04:12:29 -0800 (PST)
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 'da ...
|
General Network Error
Mon, 21 Jan 2008 09:48:17 -0000
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 ...
|
Integration with Visual Studio 2005 Tools for Office
Sun, 20 Jan 2008 21:38:00 -0800
I have installed VSTO 2005 and have discovered that the designer tools for
SQL Compact Edition do not function. They appear to function fine in VS 2005
Professional but not in VSTO.
Does anyone know how to get the tools to work in VSTO or do I have to now
purchase VS Professional
I apologise if this is ...
|
Forever
Sun, 20 Jan 2008 12:49:49 -0800
...
|
Unable to connect to Sql Server Compact Edition Database
Sat, 19 Jan 2008 19:47:18 -0800 (PST)
I'm using VS 2005 and ActiveSync 4.5.
Using the Server Explorer in VS 2005, I get the following error when I
try to add a connection to a sql server compact edition database that
resides on a CE device:
"Unable to connect or authenticate Sql Server Compact Edition
connection through Microsoft Activesync. Ma ...
|
Problems synchronizing PDA to laptop that uses SQL server
Fri, 18 Jan 2008 21:45:02 GMT
I am trying to synchronize my PDA with a program on my laptop that uses a SQL server. Every time I try to synchronize I get the following three error messages:
1.Replication error in synching 29045 Microsoft SQL Server 2000 Windows CE edition
2. Merge process 20084. The process could not connect to the distrib ...
|
|
|
Change schema for existing SDF
Tue, 15 Jan 2008 09:59:02 -0600
Created a SDF in VS2008. Saved it to VSS and saw that a field was
misspelled. Welp used Server Explorer in VS2008 to connect to it but could
not modify the schema field names at all.
Then went into SQL 2005 and tried to connect to it and it said if it was CE
3 or later i'd need to run compact/repair on it t ...
|
Monitoring Windows mobile & MS SQL Server 2005 ME
Mon, 14 Jan 2008 21:28:00 -0800
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. ...
|
Struggling with Mobile Development
Mon, 14 Jan 2008 13:52:04 -0800 (PST)
Hi,
I am to begin developing CE database applications that are going to
need direct connectivity to a full SQL Sever database or at least
*seem* like they are directly connected. I am thinking that SQLServer/
CE is the logical way to proceed, but how do I get the data from
the .sdf file into the SQL Sever? ...
|
