|
Hi all,
I am using ADOCE. My requirement is to open a connection to a database (Test.sdf) in the Pocket PC. The problem is _Connection::Open throws an exception "File not found" even though I am giving the right path. My question is, What is the exact format format in which the connection string has to be passed to the _Connection::Open() function ?
Any help would be appreciated.
Regards,
Amit
|
|
|
|
|
From the adoce31.tlh file (generated using the #import directive, we can read the method prototype as:
HRESULT Open (
_bstr_t ConnectionString,
_bstr_t UserID,
_bstr_t Password,
long Options );
All parameters are optional. The ConnectionString parameter states the connection string(that can be optionally set via PutConnectionString ) has a very specific format. For "Pocket Access" databases, use Data Source=\\FolderName\\DbName.cdb . Top open SQL CE databases, use:
_Connection::PutProvider(_T("Microsoft.SQLSERVER.OLEDB.CE.2.0"));
_Connection::Open(_T("Data Source=\\FolderName\\DbName.cdb"));
You can optionally do everything in one step:
Open(_T("Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\\FolderName\\DbName.cdb"));
Regards,
João Paulo
|
|
|
|
|
Hi,
I am giving the connection string as "Data Source = history.sdf" but still the same problem persists. Could this be because this format is only applicable for *.cdb file and not *.sdf ? I am having Test.sdf on my pocket PC as the query analyzer gave only one option (SDF) while creating the database.
Many thanks for your reply.
Regards,
Amit
|
|
|
|
|
Use a full path name on the connection string. The Pocket PC does not allow for relative path names, nor does it recognize a current directory. Check my samples: they all start with a '\'.
Regards,
João Paulo
|
|
|
|
|
Hi there João,
I have tried giving "Data Source = \\history.sdf" and have ensured that this file is present in the root directory (listed as "My Device" as seen from the file explorer in the pocket PC). Still the same problem persists. Could there be any thing else I can try ?
Regards,
Amit
|
|
|
|
|
If you did set the correct provider, I can only guess that the file is corrupted. Use the SQL CE query analyzer to open the database file and browse it.
Regards,
João Paulo
|
|
|
|
|
Hi João,
I'm really sorry for the inconvenience I'm causing you with this. Please bear with me. Now after a lot of hardcoding it is finally working. The problem was with the parameter passing.
My actual requirement is to create a number of connections to the database in the beginning itself and store them in an array so they can be used by a no. of threads. At present, after creating the first connection, when it attempts to create another, _Connection::Open() throws the exception "Cannot create a file when that file already exists". Is there some restriction with ADOCE ?
Regards,
Amit
|
|
|
|
|
Hi all,
I am developing an application using eVC4.0. I'm getting a linker error saying "error LNK2001: unresolved external symbol "class _variant_t vtMissing ". In one section of MSDN, I found that vtMissing is supplied by #import . I have imported arm\adoce31.dll. Do I need to include any other library also ??
Regards,
Amit
|
|
|
|
|
I just realised...the adoce31.dll I am using is located is located under "Embedded Tools 3.0" directory and not the "Windows CE Tools" which comes with eVC4.0. There is no separate adoce31.dll with eVC 4.0. Could that be a reason ?
|
|
|
|
|
Hi,
I'm developing an application on embedded VC, I'm getting these linker errors when building.
FinalHookDlg.obj : error LNK2019: unresolved external symbol __imp_fnOrig referenced in function "public: void __cdecl CFinalHookDlg::OnRun(void)" (?OnRun@CFinalHookDlg@@QAAXXZ)
FinalHookDlg.obj : error LNK2019: unresolved external symbol __imp_fnDup referenced in function "public: void __cdecl CFinalHookDlg::OnHook(void)" (?OnHook@CFinalHookDlg@@QAAXXZ)
ModuleInstance.obj : error LNK2001: unresolved external symbol "public: __cdecl std::exception::exception(class exception::exception const &)" (??0exception@std@@QAA@ABV01@@Z)
ModuleInstance.obj : error LNK2001: unresolved external symbol "const type_info::`vftable'" (??_7type_info@@6B@)
ModuleInstance.obj : error LNK2019: unresolved external symbol "public: virtual __cdecl std::exception::~exception(void)" (??1exception@std@@UAA@XZ) referenced in function "public: virtual __cdecl std::logic_error::~logic_error(void)" (??1logic_erro
r@std@@UAA@XZ)
ModuleInstance.obj : error LNK2019: unresolved external symbol "public: __cdecl std::exception::exception(char const *)" (??0exception@std@@QAA@PBD@Z) referenced in function "public: __cdecl std::logic_error::logic_error(class logic_error::basic_str
ing<char,struct std::char_traits<char="">,class std::allocator<char> > const &)" (??0logic_error@std@@QAA@ABV?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@1@@Z)
MIPSII_FPDbg/FinalHook.exe : fatal error LNK1120: 12 unresolved externals
Error executing link.exe.
.... and some more are there.... not pasting here since it'll make this msg very long...
Could anyone help me in solving these?
I'm using one function, which is defined in a LIB. I included that .lib and the corresponding .dll file in my project and also gave the 'path' in 'Tools -> Options -> Directories'.
Still I'm getting the error,
FinalHookDlg.obj : error LNK2019: unresolved external symbol __imp_fnOrig referenced in function "public: void __cdecl CFinalHookDlg::OnRun(void)" (?OnRun@CFinalHookDlg@@QAAXXZ)
here, fnOrig function is inside a .lib file.
i gave the statement,
extern "C" __declspec(dllimport) void fnOrig();
before i called this function...
there is no compiler error... but it's giving linker error...
and one more thing... that is .... the same code compiled and executed in normal VC++. (Windows NT / 2k)
but.. here in WinCE, it's giving these problem..
can anyone help me...?
thanks in advance..
Regards,
Jinoj
|
|
|
|
|
In the project settings (Alt+F7), you have to explicitly state the library name on the Linker tab.
Regards,
João Paulo
|
|
|
|
|
I make soft for smartphone in evc4.
And it has not a customer wizard application,I can not make a awx file for my IDE.How could I do this?
lost my way
|
|
|
|
|
Are there any secrets, gotchas, CE bugs, or any other minutia I should be aware of before I try to create a modelss dialog box on PocketPC2002?
------- signature starts
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
"You won't like me when I'm angry..." - Dr. Bruce Banner
Please review the Legal Disclaimer in my bio.
------- signature ends
|
|
|
|
|
Hello all,
My requirement is to be able to update my SQL server DB once I connect the Pocket PC to the workstation. When I select "Export Database Tables" from the ActiveSync menu, it lists out some default tables on the PocketPC. I am not able to see my tables on the same. Any help would be greatly appreciated.
Thanks in advance.
Regards,
nigs_krec
|
|
|
|
|
I cant seem to find any documentation on the process of compling a souce file to a .prc file. As you might have guessed I very new to PalmOS development and am interested in learning mroe about it. There seem to be a number of intermediate steps involved in the compilation process but I am not too sure how it all works. I am somewhat familier with the regular version of gcc, so if anyone could offer a few tips or point me in the right direction that would be great.
Nate
|
|
|
|
|
I have a dialog that is asserting during the OnInitDialog method. The framework is sending the dialog an nID=1. I don't have a single #define or a control that is defined as 1. The framework seems to be sending this nID value each time a dialog is opened. In most cases nothing happens, but in this one dialog it asserts during the ddx routines.
Any ideas why on this one dialog asserts?
Thanks,
-Eric
|
|
|
|
|
Please show us a little bit of your code!
Regards,
Daniel.
--
FIND A JOB YOU LOVE, AND YOU'LL NEVER HAVE TO WORK A DAY OF YOUR LIFE.
|
|
|
|
|
This may be a dumb question, but what does everyone use to create their documenation for their ppc apps? I want to include some kind of online documentation for my application, but I don't think the standard .hlp files will work on the ppc correct?
Is it just best to create an html type file?
Thanks,
-Eric
|
|
|
|
|
Does anyone know how to put a watch on the battery level so that if it hits below a certain level it triggers an event???
Also is there any way to register with the OS to get this info as a real-time notification??
Any help is appreciated
Connie
|
|
|
|
|
I believe you will have to pool it, just like the system does.
Regards,
João Paulo
|
|
|
|
|
I don't know what pooling is. Can you explain a little?
Thanx
Connie
|
|
|
|
|
Pooling means constantly looking for the info you want. This can be done by setting a timer (like the task manager - or NavBar - does) and, on each event, check the battery status.
Regards,
João Paulo
|
|
|
|
|
Great Thanks for the info I'll start looking into it.
|
|
|
|
|
João Paulo Figueira wrote:
I believe you will have to pool it, just like the system does.
That's how I have it set up in my apps... but surely that can't be the only way? My timer message checks every 5 minutes, but even then, I think that's waste, especially when my "battery is low" value is 30%.
It would make sense to subscribe to some notification system Oh well.
It would also be nice to know when the device was going to be turned off. It's pretty easy to get the "device is turned on" notification, which is why I'm confused why there's no "device is going to be turned off" notification.
The kindest thing you can do for a stupid person, and for the gene pool, is to let him expire of his own dumb choices.
[Roger Wright on stupid people]
We're like private member functions
[John Theal on R&D]
We're figuring out the parent thing as we go though. Kinda like setting up Linux for the first time ya' know...
[Nitron]
|
|
|
|
|
Hello,
I am developing a database application for pocket PC. In my code, if I give a
<b<code>>#import "C:\Program Files\Embedded Tools 3.0\wce300\Pocket PC 2002\dataaccess31\target\arm\adoce31.dll" no_namespace rename("EOF", "EndOfFile")
statement, it gives compiler error
error C2501: 'IUnknownPtr' : missing storage-class or type specifiers .
I tried to look for this problem on the web but there was no satisfactory explaination despite of this being a well known problem. Could anyone please help me out ?
Thanks in advance.
Regards,
nigs_krec
|
|
|
|