Mobile Discussion Boards

Re: Any samples for OLEDB API's for accessing Windows CE SQL Server

cmk4-Jun-04 10:03

4-Jun-04 10:03

It's not my code. I don't think it will compile as is under EVC. It is one of the few simple examples out there on how to use OLEDB. You will have to read, understand, and likely rewrite a little to get it to compile for PPC 2002. The same goes for getting it to work for PPC 2003.

I did a project for a client (so can't give out code) where i used the following to get OLEDB to work with EVC3 and PPC2002.

my stdafx.h file starts with :

#define VC_EXTRALEAN
#include <windows.h>

#define OLEDBVER 0x210
#define DBINITCONSTANTS
#define INITGUID

// OLEDB Files:
#include <oledb.h>
#include <oledberr.h>
#include <msdasc.h> // OLE DB Service Component header
#include <msdaguid.h> // OLE DB Root Enumerator

#include <coguid.h>

#include <ssceoledb.h> // SSCE

#include <afxwin.h> // MFC core and standard components
#include <afxext.h> // MFC extensions
#include <atlbase.h>

#include <afxtempl.h>

#include <afxdtctl.h> // MFC support for Internet Explorer 4 Common Controls
#include <afxdisp.h> // MFC OLE automation classes
#include <afxcmn.h> // MFC support for Windows Common Controls

#include <afxsock.h> // MFC socket extensions
#include <wcesock.h>

and, stdafx.cpp contains :
#pragma comment(lib, "oledb.lib")

and, my list of include directories has :
c:\...\SQLCE\INC

and, my list of lib directories has :
c:\...\SQLCE\LIB\ARM\SA1100

(replace ... with path to SQLCE install directory on desktop computer)

...cmk

Save the whales - collect the whole set

Re: Any samples for OLEDB API's for accessing Windows CE SQL Server

AKSIVAKUMAR4-Jun-04 22:44

AKSIVAKUMAR

4-Jun-04 22:44

CMK,

Thanks for your reply. Yes that code will not work under PPC 2003.The implementation will not be applicable for SQL Server CE.

Plz,tell me what are all the stpes that i need to follow when i want to create a recordset,open sql and open table. If you have any code sample for these problem, please send it to me via mail. It would be of an immense help for me to understand the flow becuase I am not able to find a good document for oledb on windows ce. For example Windows SQL Server CE supports only three types of cursor types in general and I am not able to find what are all the lock type sql server ce supports and etc., in detail.

Looking for your reply.

Regards,
AKS

Re: Any samples for OLEDB API's for accessing Windows CE SQL Server

cmk5-Jun-04 11:50

cmk

5-Jun-04 11:50

All the info about locks and cursors is in the SQLCE doc's.
All the info you need to create/open/exec a cmd against a table is in the code i originally provided a link to :
http://home.worldonline.dk/viksoe/dbwrappers.htm[^]

You will have to read, understand, and port the code to WinCE. With the header and path info i provided this should take a couple hours.

I don't have the time to do all this for you.
Nor can/will i release code developed for a client - sorry.

Good luck,

...cmk

Save the whales - collect the whole set

Any tools for unit testing

kotasuresh197630-May-04 19:19

kotasuresh1976

30-May-04 19:19

Hi,

I need to do unit test. Any testing tools available when i write function/program using evc++ ?

If so please do let me know in detail.

Suggestions are most welcome.

regards,
AKS

Re: Any tools for unit testing

João Paulo Figueira30-May-04 22:09

João Paulo Figueira

30-May-04 22:09

Check this one:
http://www.spbsoftwarehouse.com/products/testsuite/?en

Regards,
João Paulo Figueira
Embedded MVP

Wi-Fi and PocketPC Emulator

D.J.Deky27-May-04 1:10

D.J.Deky

27-May-04 1:10

...whether it is possible to deal with Wi-Fi through PocketPC Emulator, if yes, how?
Thanks

pozdrav

Unicode file reading...

GDavy26-May-04 22:45

GDavy

26-May-04 22:45

Hello there,
I got a problem when reading a unicode file on my pocket pc...
The problem is that a Unicode file starts with WCHAR 0xfffe.
I read strings from the file using the ReadString method of CArchive.
And offcourse the first string has that leading 0xfffe character.
I tried to do a TrimLeft(0xfffe) on that string, but to no avail, the character remains there.
Is there any way to just skip that character without having to write any special if else
statements?

CArchive inStream(&unicodeFile, CArchive::load);
if( inStream.ReadString( sTemp ) )
{
sTemp.TrimLeft();
if( !sTemp.IsEmpty() )
{
sTemp.TrimLeft(0xfffe); //doesn^t help

//here I compare the sTemp with a string I try to find
//in the file, however if that string is on the first
//line the compare fails due to that 0xfffe
.
.
.

If anyone can help I`ld be gratefull..

Davy

Re: Unicode file reading...

João Paulo Figueira27-May-04 1:14

João Paulo Figueira

27-May-04 1:14

Try this:

sTemp = sTemp.Right(sTemp.GetLength()-1);

Regards,
João Paulo Figueira
Embedded MVP

SQLCE Exception during .AddSubscription

fume25-May-04 23:27

fume

25-May-04 23:27

during the call to SqlCeReplication's Addsubscription, an error occurs that says:

An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll

Additional information: SqlCeException

here's my code snippet:

.InternetUrl = "http://" & txtDBServer.Text & "/" & txtDBName.Text & "/sscesa10.DLL"
.InternetLogin = ""
.InternetPassword = ""
.PublisherNetwork = NetworkType.DefaultNetwork
.Publisher = txtDBServer.Text
.PublisherDatabase = txtDBName.Text
.PublisherLogin = txtUsername.Text
.PublisherPassword = txtPassword.Text
.Publication = txtDBName.Text
.PublisherSecurityMode = SecurityType.DBAuthentication
.SubscriberConnectionString = "data source=C:\" & txtDBName.Text & ".sdf"
.Subscriber = txtDBName.Text

.AddSubscription(AddOption.CreateDatabase)

.Synchronize()

User Controls

Nick Seng24-May-04 17:02

Nick Seng

24-May-04 17:02

Is there any to get a Windows user control to work in the compact framework?

"if you vote me down, I shall become more powerful than you can possibly imagine" - Michael P. Butler.

custom control eVC++

Member 109698024-May-04 7:25

Member 1096980

24-May-04 7:25

I run application "Creating Custom Controls
By Chris Maunder" published in "All Topics, MFC / C++ >> Miscellaneous Controls >> Beginners" section. Emulator does not shows anything escept start page, no control?
What have I done worng?
This is result of building the application:

Deleting intermediate files and output files for project 'CustomControl - Win32 (WCE emulator) Debug'.
--------------------Configuration: CustomControl - Win32 (WCE emulator) Debug--------------------
Compiling resources...
Compiling...
StdAfx.cpp
Compiling...
BitmapViewer.cpp
CustomControl.cpp
CustomControlDlg.cpp
Generating Code...
Linking...

CustomControl.exe - 0 error(s), 0 warning(s)
Downloading files
Downloading file c:\myprojects\customcontrol\emulatordbg\customcontrol.exe.
Downloading file c:\windows ce tools\wce300\...\lib\x86\mfcce300d.dll.
Finished downloading.

EVC++ to Flash Comunication....

Deepa Gopal23-May-04 21:39

Deepa Gopal

23-May-04 21:39

Hello All,

I have an EVC++ program and a Flash program running concurrently in a Pocket PC wherein the EVC++ program passes some data to the Flash application via an XML socket.I am facing a problem of low animation speed when the data transfer takes place.Is there a way in the flash program to receive the data in a seperate thread so as not to disturb the animation speed?I would be grateful for your kind responses.

Thanking you,
Deepa Gopal.

Restarting DHCP Client from Driver

gomathy_p_iyer20-May-04 21:36

gomathy_p_iyer

20-May-04 21:36

Hi all
I am developing an NDIS Miniport Driver.I want to trigger the DHCP client to send out a DHCP discover packet.
The only way, I beleive I can do this is by restarting the DHCP client service.

I know that we can restart windows services from Application Layer.
But I am not sure if the same can be done from driver level.Can we?Or is there any better way to do the same?

.net Compact framework

ppp00120-May-04 8:58

ppp001

20-May-04 8:58

Hi all,

1. when will the .net compact framework 2.0 be available,
and is the most update version 1.1 ?

2. for the most update version of .net cf, will the Pocket PC 2003 OS
support it without adding any sp ?

3. Does the PocketPC 2002 OS support .net CF application if some
update to the OS on the Pocket PC device ?

Thanks

Re: .net Compact framework

dormi33331-May-04 20:38

dormi333

31-May-04 20:38

Hi!

I don't find compact framework .net v1.1 in anywhere, do you find it?
It's really exist, can somebody give me the link? please...

Thanks!

ahh, PPC 2002 support any app with .net.

Visual Inheritance in Smart Devices Project

rmcw17-May-04 11:05

rmcw

17-May-04 11:05

Hello guys:
I´m starting a new mobile project with VS 2003. I usually use inherited forms in my UI projects and custom components. I have a little doubt: Exists Visual Inheritance in Smart Devices Projects as in the Winforms projects?

Thanks

Roberto Castro Vexler
(rmcw@latindot.com)
(rmcw@casvex.com)

compactflash in .net compact framework?

3hrguy16-May-04 20:27

3hrguy

16-May-04 20:27

hey guys, do you have any idea how to make a program using vb.net (to be deployed in pocket pc) so that i could access my cf device? if it's not possible in .net, would it work using embedded sdk?

.NET CF SDK

monn13-May-04 19:40

monn

13-May-04 19:40

will there be a separate SDK for the .net compact framework

Pocket PC rebooting every few minutes..

KellyR13-May-04 4:06

KellyR

13-May-04 4:06

Hi,

After using InstallShield to copy over a number of exe files in the Windows folder of my pocket pc, now the thing soft reboots about once every 8 minutes.. I'm not sure which of the programs is a problem, the ones I copied over are:

addrbook.exe
AssetViewer.exe
beam.exe
BlueToothManager.exe
BTBusinessCard.exe
BTConnManagerCE.exe
BTFileExplorer.exe
BTPanManagerCE.exe
BTTrayCE.exe
connmgr.exe
GuideBook.exe
iexplore.exe
Jawbreaker.exe
MsReader.exe
mstsc.exe
PIMAgent.exe
pimg.exe
poutlook.exe
pword.exe
pxl.exe
solitaire.exe
tasks.exe
wirelesscenter.exe
wmplayer.exe

Does anyone have any idea which of these programs, when overwritten, aka "removed," could cause my PDA to soft reboot constantly?

Thanks!

Kelly Ryan

how should I marshall this function?

Paolo Ponzano12-May-04 22:09

Paolo Ponzano

12-May-04 22:09

Hello, I was trying to marshall this function (c#) in order to use with .NET Compact Framework

Here's the one from MSDN

<br />
BOOL WINAPI Toolhelp32ReadProcessMemory( <br />
  DWORD th32ProcessID,<br />
  LPCVOID lpBaseAddress, <br />
  LPVOID lpBuffer, <br />
  DWORD cbRead, <br />
  LPDWORD lpNumberOfBytesRead <br />
);<br />

I tryed using this

<br />
[DllImport("toolhelp.dll")];<br />
private static extern int Toolhelp32ReadProcessMemory( <br />
											  IntPtr th32ProcessID,<br />
											  IntPtr lpBaseAddress, <br />
											  IntPtr lpBuffer, <br />
											  uint cbRead, <br />
											  IntPtr lpNumberOfBytesRead <br />
											  );<br />

but I receive compile error on lpBuffer, that I've declared this as
char[] dest=new char[1024]; in my application.

thanks in advace!
Paolo

application path

GDavy12-May-04 21:59

GDavy

12-May-04 21:59

Does anybode know how to retrieve the path where the program itself is stored....
I tried AfxGetAppName() but that just gives me the name of the exe...
any help is appreciated...

Regards,
Davy

Re: application path

João Paulo Figueira12-May-04 22:40

João Paulo Figueira

12-May-04 22:40

Read the answer here:

QA: How can I know what is a full path to my program that is running?[^]

Regards,
João Paulo Figueira
Embedded MVP

Re: application path

GDavy12-May-04 23:22

GDavy

12-May-04 23:22

Thanks, exactly what I needed...

Application Running in the PocketPC

Gopabandhu12-May-04 19:43

Gopabandhu

12-May-04 19:43

Hi,

I've a small doubt. Suppose I run my application x.exe in the PocketPC.
Though it is runing in the PocketPC again I tapped on the x.exe. Will it again run or it will get x.exe into the mechanism. If I'll run same x.exe then, will it consume extra memory.
Can you please tell me what is the mechanism for this?.

Regards
Patra

Re: Application Running in the PocketPC

João Paulo Figueira12-May-04 22:14

João Paulo Figueira

12-May-04 22:14

Although you don't have to follow them strictly, the Pocket PC design guidelines say that you should have only one instance of your application running. If you develop in C++ using MFC, this feature is built in.

Regards,
João Paulo Figueira
Embedded MVP

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.