Mobile

7-Nov-03 1:54

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

João Paulo Figueira7-Nov-03 2:30

7-Nov-03 2:30

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

nigs_krec7-Nov-03 2:53

7-Nov-03 2:53

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

João Paulo Figueira7-Nov-03 2:58

7-Nov-03 2:58

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

nigs_krec7-Nov-03 3:13

7-Nov-03 3:13

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

João Paulo Figueira7-Nov-03 3:19

7-Nov-03 3:19

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

nigs_krec7-Nov-03 3:48

Help with linker error for "vtMissing" !!

7-Nov-03 3:48

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

nigs_krec6-Nov-03 0:05

Re: Help with linker error for "vtMissing" !!

6-Nov-03 0:05

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

nigs_krec6-Nov-03 0:12

6-Nov-03 0:12

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 ?

Linker error in eVC

Jinoj5-Nov-03 17:55

Jinoj

5-Nov-03 17:55

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

Re: Linker error in eVC

João Paulo Figueira5-Nov-03 22:43

How to make a wizard for embeded vc4??

5-Nov-03 22:43

In the project settings (Alt+F7), you have to explicitly state the library name on the Linker tab.

Regards,
João Paulo

fftongzhi5-Nov-03 15:46

fftongzhi

5-Nov-03 15:46

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

Modeless Dialogs ???

#realJSOP5-Nov-03 6:37

#realJSOP

5-Nov-03 6:37

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

How to synchronise from PocketPC to a SQL server ?

nigs_krec5-Nov-03 3:12

PalmOS Compiling using prc-tools gcc

5-Nov-03 3:12

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

StalfoS4-Nov-03 23:15

StalfoS

4-Nov-03 23:15

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

Dialog Error

VanHlebar4-Nov-03 15:24

VanHlebar

4-Nov-03 15:24

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

Re: Dialog Error

Daniel Strigl4-Nov-03 19:12

Daniel Strigl

4-Nov-03 19:12

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. Wink | ;)

Documentation

VanHlebar4-Nov-03 9:27

VanHlebar

4-Nov-03 9:27

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

battery level notification

ibiteu24-Nov-03 5:38

ibiteu2

4-Nov-03 5:38

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

João Paulo Figueira4-Nov-03 6:33

4-Nov-03 6:33

I believe you will have to pool it, just like the system does.

Regards,
João Paulo

ibiteu24-Nov-03 6:35

ibiteu2

4-Nov-03 6:35

I don't know what pooling is. Can you explain a little?
Thanx
Connie

João Paulo Figueira4-Nov-03 6:39

4-Nov-03 6:39

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

ibiteu24-Nov-03 6:43

ibiteu2

4-Nov-03 6:43

Great Thanks for the info I'll start looking into it.