SprintDB CDB online sync - Windows Mobile Development and Hacking General

Hello everyone.
I have developed a DB for WM using SprintDB Pro from Kaione.
What I want to do is to be able to synchronise it online through ODBC or some other kind of method with an Access DB located on a given server.
Has anyone tried this and had success?
The DB itself is in a CDB format, I only want to synchronise 2 tables from it, to be written to the Access DB once in every time period.
10x for the help

Related

where are mailsettings and/or hosts-file stored?

Hello,
I'm trying to figure out where the mail settings (in particular the SMTP server) is stored. I was thinking of using MobileProfiler to create different profiles, which I could use to change my SMTP server: if I connect via wifi, I need a different one than if I connect via gprs.
With TotalCommander, I searched through the registry and through the file system, but didn't locate anything.
Any thoughts on where this is stored (and if it is readable)?
Alternatively, I was looking for a "hosts"-file (like in Windows, which links hostnames to ip addresses), as one can modify this to get ip-address to change as one wants. But again no luck...
So, is there a place were this ip/hostname information is stored?
Thanks!
Jörg
V J said:
Hello,
I'm trying to figure out where the mail settings (in particular the SMTP server) is stored. I was thinking of using MobileProfiler to create different profiles, which I could use to change my SMTP server: if I connect via wifi, I need a different one than if I connect via gprs.
With TotalCommander, I searched through the registry and through the file system, but didn't locate anything.
Any thoughts on where this is stored (and if it is readable)?
Click to expand...
Click to collapse
It is. Please see my WinCE database & Messaging-related articles. I've described most of this stuff at http://www.pocketpcmag.com/blogs/index.php?blog=3&p=231&more=1
Alternatively, I was looking for a "hosts"-file (like in Windows, which links hostnames to ip addresses), as one can modify this to get ip-address to change as one wants. But again no luck...
So, is there a place were this ip/hostname information is stored?
Thanks!
Jörg
Click to expand...
Click to collapse
http://www.freewareppc.com/utilities/pockethosts.shtml
Thanks!
Haven't read your article yet in full detail (just glanced quickly), but does that pmailfolders file also deal with the SMTP servers? (I currently have not yet downloaded mails to this device, and I can't seem to find the databasefile (despite the fact that all settings are all set)
If it does, is it possible to change its contents from e.g. MobileProfiler:
http://www.iaccarino.de/silvio/stuff/MobileProfilerReadme.htm
without corrupting the databasefile?
(I'm not a software developer, I just would like to be able to switch/choose my smtp server)
The hosts-file utility does seem like an easier way out, but I'll have to read up more on it. I could my a file for each smtp profile I have (in each file I would put same server name, different ip address), but then I need a way telling the device which of the files to use now. MobileProfiler allows for files to be copied (they illustrate it for Opera-settings), so perhaps.......
Oh, do you know if it is WM5 compatible?
For the time being, do you know an easy workaround? On my Symbian S60 phone, every message had "Sending options", which included the account via which it was sent. I just changed the option to the server I needed to use for the active internet connection, and I could send the file. I can't do this trick on my TyTN...
Jörg
V J said:
Thanks!
Haven't read your article yet in full detail (just glanced quickly), but does that pmailfolders file also deal with the SMTP servers? (I currently have not yet downloaded mails to this device, and I can't seem to find the databasefile (despite the fact that all settings are all set)
If it does, is it possible to change its contents from e.g. MobileProfiler:
http://www.iaccarino.de/silvio/stuff/MobileProfilerReadme.htm
without corrupting the databasefile?
(I'm not a software developer, I just would like to be able to switch/choose my smtp server)
The hosts-file utility does seem like an easier way out, but I'll have to read up more on it. I could my a file for each smtp profile I have (in each file I would put same server name, different ip address), but then I need a way telling the device which of the files to use now. MobileProfiler allows for files to be copied (they illustrate it for Opera-settings), so perhaps.......
Oh, do you know if it is WM5 compatible?
For the time being, do you know an easy workaround? On my Symbian S60 phone, every message had "Sending options", which included the account via which it was sent. I just changed the option to the server I needed to use for the active internet connection, and I could send the file. I can't do this trick on my TyTN...
Jörg
Click to expand...
Click to collapse
You should have started right with this
The Messaging databases are pretty hard to (easily) change in WM5 and there are no tools (that I know of) that would do what you need.
Therefore, you REALLY want to check out alternate browsers; most importantly, Qmail. The latter has an XML-based config file mechanism; this means your thirs-party profiler tool only needs to do some very simple file copy/rename operations to completely and easily switch between SMTP servers. Highly recommended!
Please also check out my Mailer Roundup and other, newer mail-related articles; I've published several articles on alternate clients.
Cool, thanks!
Weird though that all these devices (WM5, Symbian, ...) consider a SMTP server to be a property of the mailbox, rather than of the access point. Surely I'm not the only one who needs to change SMTP servers for different access points.
Again, thanks for the help, I'll search for a mailclient that offers better support for this (I'll check out Qmail too).
Jörg
I'm now running QMail, and this seems to sort out all of my problems.
In it, I can still change the account by which a mail is sent (so I can go back to using dummy-accounts like I did before), but I no also have the option to go for the more advanced profile setup using MobileProfiles.
Thanks!!!
(it made the device so much more usable for me)
Jörg

Attachments from Outlook 2003 do not show up in WM6 Outlook

Been playing with a couple of T-Mobile Wing devices for evaluation as an offered product for our corporate customers...
My team has found a few flaws right out of the box everyone should be aware of:
1. Attachments sent from Outlook 2003 to a POP email account accessed by the Wing will not show up on the wing unless the user who created the message and the attachment selects "Plain Text" in Outlook. Very annoying for all Outlook based companies.
2. File Explorer will not connect to any network resource via Wi-Fi even if the user puts in an explicit IP address and share name as follows: \\10.0.0.7\SharedDrive
Permissions on the shared folder do need to be set to Everyone and Full Access if the device accessing the share is not a domain user. None the less, the Wing will respond with "The network path cannot be found" despite being pingable from the device hosting the share.
3. Synchronizing contacts and email to Outlook via ActiveSync and a USB cable has been quite reliable with no observed limitations however synchronizing a calendar for 3 months forward & back is simply not possible. It'll hang ActiveSync (wcescomm) on the host PC every time even with as few as 20 calendar entries in Outlook behind and ahead of the current date. This was tested very thoroughly on Windows XP, 2000 Pro and Vista with multiple Wing devices as it was a deal killer for our customers.
So far we're holding off on allowing these or recommending these to our users. We still recommend the XDA IIs for people that really need this type of functionality.

sync over network impossible? (Activesync Filesync Ethernet synchronize)

Hi all,
I just bought an HTC Universal. Till now I had an old Wallaby and I thought it would be time to get up to date and join the great new future of mobile devices. Since the Xperia X1 is not on the market yet I decided to buy this Universal for the meantime. I didn't want to wait anymore.
Now I think I'll have go back to the old times
I couldn't believe it but it seems to be completely impossible to keep some files in sync without a cable these days!!!
Am I the only person on the world who wants to edit a simple Word document while I'm on the road?! Shouldnt that be the most basic mobility you would expect from such a device these days?!
Is it possible that even with the expensive evel Exchange Server you can't sync files, only contacts, calenders and appointments?!
If anybody has a solution or alternative or workaround PLEASE tell me! I was searching for days now and didn't find anything
Bluetooth is always a possibility.
1.: When I say "on the road" I'm not talking about 10 meters away from my Workstation. To walk around in a circle of ten meters is not mobility for me
2.: Bluetooth (XP)+Activesync doesn't work with Ranjus last ROM. Only with other ROMs which then don't allow to run Skype. So I had to decide: Skype or Bluetooth.
Hi there,
I think you got something wrong;
1. Exchange Active Sync is ONLY Exchange Active Sync.
So need to put your word document in an email as attachment. This is NOT Filesync. Never was ...
What you need to do is accessing your network via GPRS/UMTS ... (e.g. vpn) and browse a network share, get a document and edit it. Beware, this means an enourmous amount of data to be transfered. Be sure to have a mobile flatrate.
2. Though Bluetooth isn't an option for you, you should not complain about roms you decided to use on your own. Go and get the original rom. You can use Bluetooth AND Skype with it.
BTW: Xperia will NOT solve your problem, you definitely need vpn for what you want to do. Or, sync your files via bluetoth while in the office and edit on the road. Send back to the office by mail ...
Best regards,
Yea, use a VPN or use a FTP or use another HostingTool.
I use my own FTP with ssl, works well fine with Resco Explorer+FTP Plugin,TotalCommander Mobile,Orneta FTP,....

WM6 & ActiveSync 4.5 does not support database synchronization

I need to synchronize my Touch Cruise with Microsoft Access on my desktop (Windows XP) but who develops database (SprintDB, f.e.) writes me:
"there is no way to synchronize database files on Windows Mobile 6 because Microsoft ActiveSync 4.5 does not support database sync"
In fact i can not to find anymore Pocket Access
There is some experienced that can help me to resolve this problem?
Database Sync
gianluigicz3 said:
I need to synchronize my Touch Cruise with Microsoft Access on my desktop (Windows XP) but who develops database (SprintDB, f.e.) writes me:
"there is no way to synchronize database files on Windows Mobile 6 because Microsoft ActiveSync 4.5 does not support database sync"
In fact i can not to find anymore Pocket Access
There is some experienced that can help me to resolve this problem?
Click to expand...
Click to collapse
If you have room on your device, you can set the database to sync under "Tools/Settings/Options" by placing the database in the "Files" folder to be sync'ed. I often do this for Excel files that I need to keep a current copy on my phone. (I have XP Pro and ActiveSync 4.5.)
Good luck!
Dean
drbowden said:
If you have room on your device, you can set the database to sync under "Tools/Settings/Options" by placing the database in the "Files" folder to be sync'ed. I often do this for Excel files that I need to keep a current copy on my phone. (I have XP Pro and ActiveSync 4.5.)
Click to expand...
Click to collapse
I just try it but WM6 do not know the extension ".mdb" (Micoroft Access) and the file is invisible by device (maybe must to have extension .cdb)!
Moreover i nedd to sybcronized it because the tables change day by day (hour by hour !)
I've just checked the sprintdb site, and a new version has been released, 4.0.
According to them there is a new conversion database utility. The screenshot shows the conversion from mdb to cdb, but I don't know if it is possible the contrary (just browsed it) and also synchronisation.

Outlook sync via Outlook Web Access without using web browser?

Hi
I used to be able sync to my work Outlook email via ActiveSync / Outlook Mobile Access (OMA). However, yesterday my work IT department disabled OMA on my Exchange server as they do not support anything other than the blackberry. Despite my protestation they are refusing to re-enable OMA. This leaves me with a big issue!
Does anyone on here know of a third party application that can sync outlook emails and calander using Outlook Web Access (OWA)?
I have found an application called Chronobis which is able to sync from OWA but only one way i.e. deleted items on Chronobis will not delete from my Outlook inbox and calendar appointments added won't sync to my outlook calander (or so I believe). Whilst this is a good start it really doesn't get me to where I need to be.
I am desperate to sync my work outlook emails to my new HTC HD2 (its the main reason I got it)!
Anyone got any other ideas / know of any other applications?
Would really appreciate any suggestions.
Thanks in advance.
Yes, you can use a service called Seven.
Thanks for your response.
I've had a look and it seems this could do the job! Seems that the only way to get it was to join the beta programme which I've done but when I put my the vendor in it doesnt give me the HD2 as an option.
Any ideas what handset I should choose that will work with the HD2?!
I've also read compatibility issues with Manilla 2.5 in their forums. Has anyone managed to get this working successfully on an HD2? Also, are you able to move emails to your different folders using this app and have them sync with the exchange?
Is this the best / only app out there for my requirement?
Sorry for all the qus!
Thanks again.
ActiveSync uses OWA. Put in webmail server, username, password and works.
OWA still works, like afterburn said, i got my calendar, email and tsks to synch. lol now all my contacts are on my university email accounts, pretty cool tho.
no need for thirdparty, active sync does it.
dont know what OMA is. but what you want is exactly what OWA gives you.
dont set your owa using HCT SENSE/MANILA SETTINGS. do it through normal out look ad account way. HTC tick boxes for tasks, calendar and other stuff are greyed out and only email is available.
but on the standard outlook mobile all the settings are there.
need a run through of how to set it up?
Thanks for your responses guys.
OMA is office mobile outlook. It is a setting within the exchange server which either allows or disallows a mobile device to access emails through the mail app. Having OWA does not mean that you will be able to access your emails from a mobile device (except through the mobile browser).
Activesync uses OMA rather than OWA so at the moment I'm stuck!
As a result I need an app that syncs via OWA.
Seven seems to be able to do it but I could do with any answers to my qus above.
Happy to be proved wrong on this but one day it was all working fine and the next my exchage server settings had been changed and it stopped working.
Any exchange server admins on here who can confirm my thinking is correct?
Gooner4_1998 said:
I've also read compatibility issues with Manilla 2.5 in their forums. Has anyone managed to get this working successfully on an HD2?
Click to expand...
Click to collapse
I'm using Seven on HD2. There were compatibility problems with custom ROMs on other devices based on leaked Leo Manila.
Why don't you use Blackberry Connect on your Wm device? That way, you can sync the same way as Blackberry devices. Of course that requires you to have BB access rights, but since they are so BB happy, you may be able to get that.
You can get it here: http://www.htc.com/us/mobile/connect/8925/install/default.html
Of course it is not specific for the HD2, and I have no idea if it'll work, but it is worth a try.
BB connect sounds like a good idea, wasn't aware it was a possibility, thanks.
I actually have a BB from work so I know that I am set up for it. However, I work for a company that are very keen on security so there is no way they will give out the settings I would need (its set up by the IT department and then just given to you).
Is there any way to get the info / settings I need from my current blackberry? Ive had a look on it and can't see anything obvious.
Just checked through some documentation on BB connect and unfortunatley it requires that I install ActiveSync and BB Connect on a computer connected to my works network.
As I dont have admin rights on my work laptop I won't be able to do this (unless anyone knows how to install programs without being an administrator!).
Looks like Seven might be the bset solution!
Vangrieg, which handset did you choose to set up for the HD2?
Thanks
I admin an exchange server, the most common reason for OMA not working is if there isnt a valid ssl cert for the domain, but i can confirm that as you mentioned, it will deffo not work if mobile access is turned off on the user account (there are 2 seperate options for web and mobile access)
i dont see any decent reason why a server admin would disable it, he must be on a power trip or sommert!
Thanks lancemate.
Could the valid ssl cert be the reason even if others in my company are still able to access as before? Its only affecting me. I've set up one of my collegues mail accounts on my phone to see if it still worked and it did without any issues.
When I called IT they said they hadn't changed any of my settings so I had assumed that OMA was the issue. I asked them to check and to re-enable and they told me they were unwilling to even look at my settings!!! Our IT department has been moved to India which makes it even harder to get any help!
Could an ssl cert suddenly just expire?!
Is there anyway of me to get a valid ssl cert for the domain witout going through IT to see if this is the issue?!
Been doing some more research and want to see if getting an ssl certificate onto my phone will make it work. Absoloutely no idea if it will work but its the last thing I can think off!
Is it possible to download the SSL certificate from my OWA site?
If I double click on the padlock in the bottom left corner I can get the certificate details up on the "details" tab (although there are loads of files and I don't know what I'm looking at!). When I click "copy to file" the export wizard come up but I have no idea where to go from there!
Anyone able to offer any assistance please?
Also, I'm sure this is a stupid question but would I need to put this certificate on my phone or could I use a different one?!
Thanks
It cant be an SSL Cerificate issue if your Colleague's account works on your device.
It MUST be that OMA is disabled on your account or something else is horribly wrong. As mentioned above i cant see any reason why an Exchange administrator would disable OMA.
Can you connect to your account using activesync on a different device to check whether its the phone or settings on server side?
To help you with using Blackberry Connect as a possible solution here are some resources on how to run programs that require admin level on machines you havent been given admin rights to. Some methods cover your tracks completely and others simply let you create/amend and delete windows accounts and associated rights in whatever way you need.
i would suggest using the first link to create a bootable usb stick that loads a modified linux command prompt. You can then use this to give yourself local admin rights.
http://pogostick.net/~pnh/ntpasswd/
http://www.jms1.net/nt-unlock.shtml
http://internetbusinessdaily.net/how-to-hack-a-window-xp-admins-password/
I've tried to set up on 2 other phones, bith with no joy so I'm guessing its the server side rather than the phone.
Is there no way that its anything to do with the ssl certificate? Are they set up company rather than by user? Will my suggestion of putting a certificate on my phone definately not work (if I could even find out how to export it from OWA)?!
I also cant see why the OMA would have been diabled so thinking it must be something else!
Thanks
I share Gooner's concerns and look forward to finding a solution. 1) My company has not yet enabled mobile devices to sync via Outlook Web Access. 2) Blackberry Connect does not yet work on HD2. There is a thread for BBC on this very same forum.
I am confident that a solution will soon emerge for 1) and/or 2).
Audio Oblivion said:
It cant be an SSL Cerificate issue if your Colleague's account works on your device.
Click to expand...
Click to collapse
Well, sometimes you need to install the certificate manually on your device to make it work. That's the case where I work - we use a self-signed certificate.
I use zarafa as a direct replacement for exchange, it syncs my emails,calendars, contacts etc.
It allows push email as well.
Hi JMes
After looking around I have found it appears that there are 2 services that will allow you to sync a mobile device using OWA, even if it is not set up for OMA.
Seven - Currently in beta but others have had success with this service on an HD2. I believe that it will sync Calendar, Tasks and Email.
Emoze - Also allows you to check outlook via OWA and offers a free service or a paid for service. Paid for service allows you to remove the "sent from emoze" tag allows attachemnts to be sent up to 2mb (rather than 100kb). Think it costs 10 euros a year.

Categories

Resources