|
I've tried getting together a test project to use SSCE but I keep getting the below error when I try declaring an instance of SqlCeConnection. I do have a reference and it is the version specified.
Anyone know of a possible cause or solution?
"The type 'System.Data.Common.DbConnection' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'"
only two letters away from being an asset
|
|
|
|
|
You need to add a reference to System.Data.SqlServerCe.
This statement was never false.
|
|
|
|
|
Give me a little credit here. Already have reference to it.
only two letters away from being an asset
|
|
|
|
|
Well, your sig says it all.
This statement was never false.
|
|
|
|
|
Can anyone tell me the way how can I synchronize my data from Pocket PC to Desktop, and Desktop to Pocket PC.
I Love SQL
|
|
|
|
|
if you have less data (like 500 kb to 1MB)
Using Web Service
if you have more data you can use
1) Remote Data Access
2) Merge Replication
Pavan Pareta
|
|
|
|
|
Hi,
I have created an application for Zooming in Pocket PC using VS 2005
for WM 5.0. It is working fine in the WM5 devices and emultors. The
application worked fine in WM 6 professional emulator also. But When I
deployed it in WM6 device(device still under testing), it did not
work.i.e., it did not zoom. I have used BitBlt and StretchBlt in my
code. Find below the code.
//Create device context
memDc.CreateCompatibleDC(pDC);
//Create bitmap object
bmpScreen.CreateCompatibleBitmap(pDC,iZoomLevel*m_iWidth,iZoomLevel*m_iHeight);
m_hOldBitMap = SelectObject(m_MemDc,m_bmpScreen);
//Stretch the image and paint it on the screen
m_MemDc.BitBlt(0,0,m_iWidth,m_iHeight,pDC,0,0-
m_iCaptionHeight,SRCCOPY);
CPaintDC dc(this);
dc.StretchBlt(0,0,iZoomLevel*m_iWidth,iZoomLevel*m_iHeight, &m_MemDc,
0,0 ,m_iWidth,m_iHeight,SRCCOPY);
Please let me know will there be any difference between emultor and
the device. Also please let me know if StretchBlt is supported in WM
6.
Thanks in advance.
Srini
|
|
|
|
|
Hello all. I have this application written in C++/MFC with Embedded Visual C++ 4. I have this dialog, which is full screen. When I open this window, if I have an application running, say, the calculator, rather than showing this dialog, it displays the calculator, until I click on the dialog. I tried BringWindowToTop and SetWindowPos with &wndTop as first parameter. Does not work.
Any idea will be really appreciated.
Regards,
FG.
|
|
|
|
|
Hi,
I have created a dll project in MFC for smartdevice, by choosing MFC smart device DLL project and i use __declspec( dllexport ) to export the members of a class.
I am not able to get proper debug information while debugging the code.
venkat
|
|
|
|
|
Hi everyone !
Do you know which process and API run when you open a folder in WinCE?
Do you know some API monitor for CE?
Help me !
Thanks !
Nothing Is Impossible !
|
|
|
|
|
I have written a class for operating the SQLCE database with OLE DB, it work perfect on INSERT ,UPTDATE and so on, but when I use 'select' statement to get values from database it doesn’t return values properly even though the GetNextRows method succeeds.
HRESULT hr = NOERROR;
m_pIRowset = NULL;
m_prghRows = &m_rghRows[0];
hr = pICmdText->SetCommandText(DBGUID_SQL, pwszQuery);
if(!FAILED(hr))
{
hr = pICmdText->Execute(NULL, IID_IRowset, NULL, NULL, (IUnknown **)&m_pIRowset);
if (FAILED(hr)){
AfxMessageBox(_T("failed"));
m_pIRowset = NULL;
}
// Get IColumnsInfo interface
hr = m_pIRowset->QueryInterface(IID_IColumnsInfo, (void**)&m_pIColumnsInfo);
if(FAILED(hr)){
AfxMessageBox(_T("failed"));
}
// Get the column metadata m_ulNumCols//m_pDBColumnInfo
hr = m_pIColumnsInfo->GetColumnInfo(&m_ulNumCols, &m_pDBColumnInfo,&m_pStringsBuffer);
if(FAILED(hr) || 0 == m_ulNumCols){
AfxMessageBox(_T("failed"));
}
// Create a DBBINDING array.
m_dwBindingSize = m_ulNumCols;
m_prgBinding = (DBBINDING*)CoTaskMemAlloc(sizeof(DBBINDING)*m_dwBindingSize);
if (NULL == m_prgBinding){
hr = E_OUTOFMEMORY;
AfxMessageBox(_T("Memory allocation failure"));
}
// Set initial offset for binding position
m_dwOffset = 0;
// Prepare structures to create the accessor
UINT lCount;
ULONG dwOrdinal;
for (lCount = 0; lCount< m_ulNumCols; lCount++)
{
dwOrdinal = m_pDBColumnInfo[lCount].iOrdinal;
m_prgBinding[lCount].iOrdinal = dwOrdinal;
m_prgBinding[lCount].dwPart = DBPART_VALUE | DBPART_STATUS | DBPART_LENGTH;
m_prgBinding[lCount].obLength = m_dwOffset;
m_prgBinding[lCount].obStatus = m_prgBinding[lCount].obLength + sizeof(ULONG);
m_prgBinding[lCount].obValue = m_prgBinding[lCount].obStatus + sizeof(DBSTATUS);
m_prgBinding[lCount].wType = m_pDBColumnInfo[lCount].wType;
m_prgBinding[lCount].pTypeInfo = NULL;
m_prgBinding[lCount].pObject = NULL;
m_prgBinding[lCount].pBindExt = NULL;
m_prgBinding[lCount].dwMemOwner = DBMEMOWNER_CLIENTOWNED;
m_prgBinding[lCount].dwFlags = 0;
m_prgBinding[lCount].bPrecision = m_pDBColumnInfo[lCount].bPrecision;
m_prgBinding[lCount].bScale = m_pDBColumnInfo[lCount].bScale;
switch(m_prgBinding[lCount].wType){
case DBTYPE_WSTR:
m_prgBinding[lCount].cbMaxLen = sizeof(WCHAR)*(m_pDBColumnInfo[lCount].ulColumnSize + 1); // Extra buffer for null terminator
break;
default:
m_prgBinding[lCount].cbMaxLen = m_pDBColumnInfo[lCount].ulColumnSize;
break;
}
// Calculate the offset, and properly align it
m_dwOffset = m_prgBinding[lCount].obValue + m_prgBinding[lCount].cbMaxLen;
m_dwOffset = ROUND_UP(m_dwOffset, 8);
}
// Get IAccessor interface
hr = m_pIRowset->QueryInterface(IID_IAccessor, (void**)&m_pIAccessor);
if(FAILED(hr))
{
AfxMessageBox(_T("failed"));
}
// Create the accessor
//
hr = m_pIAccessor->CreateAccessor(DBACCESSOR_ROWDATA, m_dwBindingSize,
m_prgBinding, 0, &m_hAccessor,NULL);
if(FAILED(hr))
{
AfxMessageBox(_T("failed"));
}
// Allocate data buffer.
//
m_pData = (BYTE*)CoTaskMemAlloc(m_dwOffset);
if (NULL == m_pData)
{
hr = E_OUTOFMEMORY;
CString errors;
errors.Format(_T("%d"),m_pDBColumnInfo[2].ulColumnSize);
MessageBox(NULL,errors,NULL,MB_OK);
AfxMessageBox(_T("failed"));
}
// Retrive a row
//
hr = m_pIRowset->GetNextRows(DB_NULL_HCHAPTER, 0, 1, &m_cRowsObtained,&m_prghRows);
if (SUCCEEDED(hr) && hr != DB_S_ENDOFROWSET)
{
// Set data buffer to zero
//
memset(m_pData, 0, m_dwOffset);
// Fetch actual data
hr = m_pIRowset->GetData(m_prghRows[0], m_hAccessor, m_pData);
if (FAILED(hr))
{
m_pIRowset->ReleaseRows(1, m_prghRows, NULL, NULL, NULL);
AfxMessageBox(_T("failed"));
}
}
if (hr == DB_S_ENDOFROWSET)
{
m_bIsEOF = TRUE;
}
}
venkat
|
|
|
|
|
Hi,
I tried to create a SmartDevice MFC application using VS 2005. I have
installed Windows Mobile 6 Professional SDK. I have created an MFC
smartDevice application(Dialog based). When I tried to compile the
application, I am getting an error. #error Must define a target
architecture.
Please let me know how to fix this issue.
Thanks
Sri
|
|
|
|
|
I m jay & I m doin a project for which I required a SMS Gateway. I used NowSMS for sending & recieving SMS through my cell phone connected via USB. But NowSMS cannot read the msgs that I sent to the connected mobile. I hve tried some settings but I m not a Network Specialist, so I dont know some of the settings like SMPP server, POP3, SMSC & other such stuff. Can anybody plz help me in this. Can somebody gve me the general settings for the NowSMS. Plz reply
|
|
|
|
|
Hi
i have developed a Mobile web application in which i have made to display few data in ObjectList control.I have a template column as Link and on clicking,it'll move to a detail page.
And below that control am having another control mobile:Command to navigate to next page...I have made the Format property of Command control to 'Link'...
Am facing two problems when am trying to view this app in a Blackberry Simulator. One is when i try to click the template column's link,its throwing 'Javascript Error'. Another one is,the Command control is always displayed as Button even if the Format is made to 'Link'..But these two works fine if i view this app thro' Internet Explorer..
Can anyone help me in resloving these problems,please?
Thanks
~Vsree
|
|
|
|
|
i am not able to use ::CommandLineToArgvW in EVC while the samething worked in VC . I have included the necessary shellapi.h and shell32.lib ,but am still getting errors like ,
error C2039: 'CommandLineToArgvW' : is not a member of '`global namespace''
error C2065: 'CommandLineToArgvW' : undeclared identifier
error C2440: 'initializing' : cannot convert from 'int' to 'unsigned short ** '
|
|
|
|
|
Not implemented on Windows CE.
When implementing the first version of Windows CE, the developers stripped out everything that wasn't essential. Where there were multiple overlapping implementations of a concept, that could be implemented in terms of each other, they selected one of them. This was done to reduce the footprint of the operating system - early CE devices only had a couple of megs of ROM available. Over time, some have been added back in, but in general it's still a much-reduced feature set.
You'll have to implement it yourself.
|
|
|
|
|
I am unable to run sub-query in my pocket pc application.
Do I have to install any ServicePack or any pathc for SQL Server Comapact Edition or what should I do to be able running my SQL query inside dsf file?
I have tested query in SQ Server 2000 and it works perfectlly but inside sdf file doesn't.
Regards
I Love SQL
|
|
|
|
|
SQL Server CE has an extremely restricted query language compared to SQL Server 2000. If you have MSDN Library for Visual Studio 2005, go to the Contents tab, then in the tree go to Enterprise Servers and Development, SQL Server, SQL Server 2005 Documentation, SQL Server 2005 Mobile Edition Books Online, SQL Server Mobile Programming, SQL Reference for SQL Server Mobile, or look online here[^].
If you run a project referencing SQL Server Mobile/SQL Server CE from Visual Studio, it will deploy a package containing a CE version of Query Analyzer. You can try out queries from here. Best used on the emulator because you can use your real computer keyboard to enter the query.
SQL Server 2005 Management Studio can load SQL Server 2005 Mobile Edition/SQL Server Compact Edition 3.1 .sdf files and query them. At the 'Connect to Server' prompt, select 'SQL Server Mobile' from the Server Type drop-down list.
|
|
|
|
|
Hi everyone.
I am trying to build a file system filter on Windows 5.0 pocket PC Emulator.
I am using sample code of FSDSPY which i got from following path
%_WINCEROOT%\public\common\oak\drivers\fsd\fsdspy\
I have created a MyFilter.dll.
Then I created another application which register, and copy DLL in
/Windows directory.
I put the registry key as
HKEY_LOCAL_MACHINE\System\StorageManager\Filters\MyFilter
Given two value as MyFilter.dll and order value 4.
After executing this application, I had soft reset my emulator,
But my file system filter has not been loaded.
In Remote Process viewer, I can't see my MyFilter.dll used by filesys.exe.
Does fsdmgr.dll exist on Windows 5.0 pocket PC Emulator?
If any one have idea about this then please reply.
Pocket PC Development
|
|
|
|
|
Hello,
I have problems with cabwiz.exe and .inf file.
When my program is installed in Smartphone, it is absent in add/remove
programs list. But in PocketPC it is.
I think there is something with cabwiz.exe and .inf file.
Can anybody help me?
Thanks.
a_sklyar
|
|
|
|
|
Hi,
I have a palm Pc (Looket G8) and I want to install a program in it.But I cannot see the Setup File of the program that I want to install in G8.Because when I open the G8 I see
only "IMAGE VIEWER","NAVIGATION","MUSIC","SETUP" buttons as the
interface.And none of them shows me the setup file.How can I install the program.Someone can help me?
Thanks
ibrahim
|
|
|
|
|
i am Surjeet Singh Sidhu.
any can help simple application create for nokia 7610 and codes of simple application. please please----------
surjeet_sidhu2007@hotmail.com
surjeet singh
|
|
|
|
|
I am working on a project that requires customization of a mobile device (a smart phone seems logical) to run a simple program. The program only needs to prompt the user (Enter a number btw 0-9) and then send a message that contains information about the user (pre-stored on the phone) as well as the value just entered. The message could be simple SMS messaging to another mobile user or an email account. This application DOES NOT have to be portable to other devices. I'm looking for advice on the choice of particular devices and programming environemnts to do the above. I don't know JAVA and it has been over a decade since I did any C or C++ programming so I would prefer the simplest programming environemnt possibe (VB?). Any suggestions are most welcome.
|
|
|
|
|
I have a multithreaded COM object I want to convert to Pocket PC. I have added the build type and appropriate build options but I find that there is no _beginthread function.
Does the pocketPC support multiple threads and if so, can you point me to an example.
Hell I thought it was funny .....
|
|
|
|
|
_beginthread is a function in the desktop C runtime which wraps up the underlying CreateThread operating system function. On the desktop, you should always use _beginthread or _beginthreadex to ensure that the C runtime is properly initialised.
On Windows CE, the C runtime is integrated into the OS, as part of the core system DLL coredll.dll . CreateThread handles initialising the C runtime for the new thread in addition to its other tasks. Therefore _beginthread is not necessary and is omitted. You should use CreateThread .
|
|
|
|
|