|
SQLCE profs please help !!!!
I have a table 'test' with a column 'testdate' as nvarchar(50).
The data this table are datetime values:
10-01-2005
11-01-2005
etc
I want to search records in this table, like they are datetime formats, no
string formats (i known, i had to make the 'testdate' column a 'datetime')
so expressions like: < 1 ...
Fri, 14 Jan 2005 05:45:03 -0800
|
SQL CE sync with MSDE (ie. running on XP Home, with no IIS)
Hi,
I am trying to write an app that will run on XP Home (ie. no IIS), using
MSDE, but which will sync to SQL CE.
Can anyone offer some pointers or code samples (prefer C#), on how to do
this. All the articles I can find seem to suggest using replication, or RDA,
but both appear to use IIS, and SQL 2000 ...
Fri, 14 Jan 2005 12:08:44 GMT
|
Synchronising SQLCE to MSDE
Hi
Can anyone point me to some notes on how to Sync data from SQLCE to MSDE?
I feel that I may need to use a manual piece of coding to push and pull data
from the PDA, rather than using SQL's Merge replication.
Where do I need to place my 'code'?? I presume it would need to plug-in to
ActiveSync (??)
...
Thu, 13 Jan 2005 22:55:06 GMT
|
SQLHelper (Application Blocks) for SQLCE
Hi
Does anyone know if SQLHelper (Application Blocks) for SQLCE is available?
Thanks
...
Thu, 13 Jan 2005 21:10:35 GMT
|
MSDE and SQL CE License
Hi,
Can I use MSDE as publisher and SQL CE as subscriber? Should We buy any
license? We don't use SQL Server at all
Andrea Aiello ...
Thu, 13 Jan 2005 04:13:03 -0800
|
Coding an app to use ActiveSync to sync between SQL CE and SQL 2000 / MSDE
Can anyone provide any pointers or code examples for Coding an app to use
ActiveSync to sync between SQL CE and SQL 2000 / MSDE
I want the app to use ActiveSync and to be a Windows form app on the PC and
with a widest target platform (ie. XP home, so no IIS), therefore using IIS
for Sync is not really an o ...
Wed, 12 Jan 2005 19:49:40 GMT
|
Fixing a database file corrupted
Hi,
I have created databases with an application developed in Embedded Visual
C++ 4. When the application is running and it is connected with the database
created by it I reseted the Pocket PC. Sometimes, after it happened I can't
open the database again, even using the query analyser. In those cases, if I ...
Tue, 11 Jan 2005 10:03:05 -0800
|
SQL CE Relations
Hi.
I am devoloping an application for PPC with Visual Basic .NET and SQL Server
CE. The thing is I use a database that was designed in Access 2000. I
couldn't find an easy way to import the database (from Access to SQLCE) so I
wrote a routine in VB that, through ADO builds the database I need. It
creates ...
Tue, 11 Jan 2005 11:47:07 -0300
|
Merge replication porblems with GPRS
when i try sync my sqlce application with gprs i found this error: a request
to send data to the computer running IIS has Failed. For more information,
see HRESULT [,,,,,]; this error not occur when I connect my pocket with
active sync.
I try connect with gprs, and when I try my url :
\\myServerName\Virt ...
Tue, 11 Jan 2005 03:07:01 -0800
|
Error 80004005 28017 "An incorrect or unsupported HTTP function ca
Hi all,
Can someone tell me what does this error message mean and how can I solve it?
Thanks in advance,
Stavros Makridis. ...
Mon, 10 Jan 2005 04:55:04 -0800
|
Reseting the pocket with an active connection
Hi!
I have reseted my pocket pc when the connection between the database and my
application was enabled yet, but, I am still not sure if I can assume that I
will be able to open the database again after doing it. Please, could anyone
tell me if I
can always open the connection after doing it?
Thanks a ...
Mon, 10 Jan 2005 02:13:01 -0800
|
Import from XML file
I would like to import data from an XML file to a table in SQL CE directly
if possible. I've seen some examples of populating a dataset and then
importing to the table from that dataset, but would like to skip that step
for memory reasons, etc. Is it possible?
...
Fri, 7 Jan 2005 12:19:02 -0600
|
Insertting a row thu cdynamicaccessors
I am developing a OLEDB application where in am able to get the=
value of all types but while inserting also i make it work for=
sting data type. like this instaed of called command.setvalue i=
used the following code:
=09cmd1.TranslateColumnNo(lCol);
void *pDataBuffer=3D(void*)cmd1._GetDataPtr(lCo ...
Fri, 07 Jan 2005 04:09:02 -0800
|
Insert a Row thru OLEDB
I am developing a OLEDB application where in am able to get the=
value of all types but while inserting also i make it work for=
sting data type. like this instaed of called command.setvalue i=
used the following code:
=09cmd1.TranslateColumnNo(lCol);
void *pDataBuffer=3D(void*)cmd1._GetDataPtr(lCo ...
Thu, 06 Jan 2005 21:52:28 -0800
|
Deploy SQL CE 2.0
Sorry everyone, if my question is too lousy.
But I still want to know, how do I deploy SQL CE 2.0 on new device? I don't
know, I installed my Visual Studio .NET 2003 Professional, and few others
toolkits, "magically", I get my SQL CE on that device and working.
Thanks in advance.
Khan Ming
...
Fri, 7 Jan 2005 11:49:49 +0800
|