|
Hi ALL,
I need to access the Windows CE SQL server using OLEDB API's.
Is there any OLEDB c++ warapper class for communicating to the Windows CE SQL server 2.x ?
Suggestions are most welcome.
Regards,
AKS
|
|
|
|
|
|
Hi,
Thanks for your reply. Also, i have seen samples which is coming along with the SQL server 2.0 which does not uses OLE DB Consumer templates. Is there any other way to implement an interface without using ATL OLE DB Consumer Template like a simple C++ class for pocket pc 2003?
Also, how to move record sets,execute sql queries and open tables using OLEDB API's?
Slease explain in detail. Suggestions are most welcome.
Regards,
AKS
|
|
|
|
|
|
Hi,
I went through the code. In ADOCE, the following interface is available.
pIADOCERecordset->MoveFirst();
pIADOCERecordset->MovePrevious();
pIADOCERecordset->MoveLast();
I am not able to understand how to move the recordset in OLEDB. Please explain how to move recordset Last,Previous,First and Next like in ADOCE using OLEDB API's.
Is the same interface available in OLEDB?
Please suggest me.
Regards,
AKS
|
|
|
|
|
These methods are available from the IRowset::GetNextRows method. Its use is not necessarily direct, that's why I use the Consumer Templates.
Regards,
João Paulo Figueira
Embedded MVP
|
|
|
|
|
hi,
Basically, I am new to SQL Server CE, can you please do let me know what are all the steps I need to follow when I want to open a SQL statement or TABLE with some sort of constraints like cursortype and lock type.
pleas do let me know what are all the steps I have to follow to solve this problem.
suggestions are most welcome.
regards,
AKS
|
|
|
|
|
I don't have much experience in using raw OLE DB, only through the consumer templates. These can be used with MFC, WTL or with straight API. Please check my article for the info you want (start of thread).
Regards,
João Paulo Figueira
Embedded MVP
|
|
|
|
|
Hi,
To pass cursor type and lock type , which interface I supposed to use and how in OLEDB. I am not able to find proper document for this problem.
please do let me know if you have any idea in this regards.
-AKS
|
|
|
|
|
You can get the OLEDB basics from :
http://home.worldonline.dk/viksoe/dbwrappers.htm[^]
Your Db Admin create code is :
CComPtr<idbdatasourceadmin> dbAdmin;
HRESULT rc = dbAdmin.CoCreateInstance(CLSID_SQLSERVERCE_2_0, NULL, CLSCTX_INPROC_SERVER);
...cmk
Save the whales - collect the whole set
|
|
|
|
|
Hello,
Great! Thanks ! I am going through the code. please tell me, what are all the dependency files which i have to include for running the test client ?
Just wanted to know, Will the same code works under pocket pc 2003?
Shall certainly revert back to you if any need arises.
Regards,
AKS
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
...whether it is possible to deal with Wi-Fi through PocketPC Emulator, if yes, how?
Thanks
pozdrav
|
|
|
|
|
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
|
|
|
|
|
Try this:
sTemp = sTemp.Right(sTemp.GetLength()-1);
Regards,
João Paulo Figueira
Embedded MVP
|
|
|
|
|
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()
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
