Database systems - General Questions and Answers

Hello,
at first i want to say sorry for my english
i want to develope a small app which shows the next bus and tram connections in this area where i'm living. For this i have to store a lot of timetable informations of all of the busses and trams. I plan to use a database system to store thie informations.
which database systems exists for windows mobile? its possible to use sqllite? or do you have a better idea how to store the informations?
regards
kai

Use microsoft sql sever 2005 compact instead.
http://www.microsoft.com/Sqlserver/2005/en/us/compact.aspx

Related

Universal WM6 ROM and Enterprise Policies

Hi all,
I would like to discuss about the use of Universal with Windows Mobile 6 in professional life...
Could be the base system compliant with general security policy for firms?
Let me know what's your point of view...
mamiware said:
Hi all,
I would like to discuss about the use of Universal with Windows Mobile 6 in professional life...
Could be the base system compliant with general security policy for firms?
Let me know what's your point of view...
Click to expand...
Click to collapse
All of the Windows Mobile 6 ROM's I have used fully support the security policy stuff that is enforced by Exchange when using the device for "Direct Push" email (for what its worth).
I have also found that if you add Blackberry software it works well enough with there policy software if that is your enterprises ‘thing’.
As for your unique company policy, only you and your IT guys can judge that. Just about EVERY company has a different view on what is important.
Support for Exchange policies, a few custom CABs and support for our device management tool mean that using Mobile 6 (or 5) in our enterprise is a non issue. Our only issue with the Universal is the fact that strictly speaking Mobile 6 is a licence violation on the device . Not the case with the Vox’s, TyTN2’s and other native Mobile 6 devices we have.
Your biggest hurdle is that most IT departments in any sizeable company are not going to let non company kit onto there networks, and for a lot of company’s that will extend to non approved software/ROM images etc. being banned.
I guess security enhancements with WM6 are not so... "strong".
As IT Security Integrator, i'm very waiting for Exchange 2007 SP1, that should enforce AS Policies even more than non-sp1 release.
I advise you and your IT Admin (i think they already did, though) to have a look to Exchange SP1 release notes.
There are literally hundreds of enterprise applications out there for management of mobile devices that support everything from symbian phones, to pda's, to windows mobile phone devices.
Some of the better ones are SOTI, Afaria, and Pointsec.
They give remote access to handle remote package management, as well as locking the device and access to applications by user, or user group too.
I thought he was talking about Activesync security policy.
Thank you for all replies...
But does Exchange 2003 store any information about your device? I'm thinking about Windows Mobile 6 Universal issue... And what about contacting Microsoft to buy a license upgrade (without any software delivery from them)?
I'm confused: what do you mean with "But does Exchange 2003 store any information about your device? I'm thinking about Windows Mobile 6 Universal issue... "
If you're talking about ROM Upgrades to Crossbow and license issue, well it's just a lack of support from Manufacturers. Afaik microsoft is providing WM6 license upgrade for free, but providing customers with WM6 rom on old devices would mean no market for new devices. Microsoft ships upgrades to OEM only however.. Not to final customers.
However Exchange 2003/2007 should not store any information regarding devices. I mean, any information relevant. It recognize the device assigning it a unique Idetifier at first synch (SID). I could have a deep look about that with exchange 2007, though. Just tell me what you're looking for.
Ok... If Microsoft is providing WM6 license upgrade for free... why cooked ROM are not so... "legal"?
My problem is: I would like to use my device in my professional life... and I would like to use it the best way I can! This means I need WM6... The problem is that HTC does not provide an official upgrade, but we know that we can develop our ROM... So... How can I legally install my WM6 cooked ROM on Universal? Should I buy some license from someone? Or I can simply flash my device with my ROM and run it without caring about Microsoft license because the upgrade is free?
What about the SD-card encoding "thing"? It should be compliant with any security policy, provided you only lose the card, not the whole device, since in that case, the card can't be read, right?
Yeah... The SD encoding it's fine for policies but... the question is... the encryption key is store in the device (and is deleted with an hardreset) or is created from some device hardcode data? To answer this question we can only try to encode-hardreset-access data... and see if we can still read sd files... (i'll try next weekend)
Anyway... another issue is... how encrypt all data store in device memory? is there any good (light and clean) plugin (driver or application) that can encrypt all the contacts and calendar and, above all, exchange login details?
new symantec mobile suite 5 should do that and make device super-compliat to most (all?) enterprise policy... i'd like to buy it but I do not find any way to place order through the internet!
mamiware said:
Yeah... The SD encoding it's fine for policies but... the question is... the encryption key is store in the device (and is deleted with an hardreset) or is created from some device hardcode data? To answer this question we can only try to encode-hardreset-access data... and see if we can still read sd files... (i'll try next weekend)
Anyway... another issue is... how encrypt all data store in device memory? is there any good (light and clean) plugin (driver or application) that can encrypt all the contacts and calendar and, above all, exchange login details?
new symantec mobile suite 5 should do that and make device super-compliat to most (all?) enterprise policy... i'd like to buy it but I do not find any way to place order through the internet!
Click to expand...
Click to collapse
Hi,
You could change shell paths so that all user data is stored on the SD.
Although I have not tried it, I believe it's simple enough to move all databases to the SD Card.
Cheers,
Beasty

Creating programs for WM

Is this pretty tough to do? For example if I wanted to create a video service for WM devices that connects to an existing website and uses a searchable database how much programming knowledge would I need? Or what kind of programming. Obviously since I am having to ask this I would not be doing the programming but I am just curious. Also I would have access to the sites database.

Apache + php + mysql running on Windows Mobile?

Hi!
Is there a way that Apache + mysql + php could run on Windows Mobile?
I've searched the forums but I haven't found anything useful.
Thanks.
Not that I've seen. Care to enlighten us with a possible reason you need a webserver in a phone ?
Well... it would be useful in some scenarios
Id put 50euro in for someone to get them working. Means a lot of my Web Apps could work off like and then I just have sync page to save on roaming chargess.
maybe something like this,
but it only support SQLite3 and a subset of all php functions.
http://mobileleap.net/hph/
I remember way back being able to run apache at least.
http://www.rainer-keuchel.de/wince/apache-ce.html
There was also a version of asp http://www.modezero.net/PocketASP/
snachez said:
Not that I've seen. Care to enlighten us with a possible reason you need a webserver in a phone ?
Click to expand...
Click to collapse
Do folks really need a reason why?
I think the answer is, 'cause it would be cool!
Having the ability to test database queries
would be great for students like me.
Imagine while in the bus, or train, or waiting at the doctors and having the ability to create tables and all!
Answer...
Here is your answer..
apache II v1.0 on mobile phones http://www.google.de/search?hl=de&q=apache+on+windows+mobile&btnG=Suche&meta=&aq=f&oq=
apache php mysql would be great to have an always accessible mediawiki as described in my comments here :
http://carrypad.com/2010/02/22/airlife-100-thoughts-6-days-online-battery-and-pricing/#comments
PocketHTML;
http://www.isquaredsoftware.com/pockethtml.php
or
http://www.freewarepocketpc.net/ppc-download-hyperedit.html
For on the fly html edits.
And here an introduction to ASP.NET Mobile;
http://www.geekpedia.com/tutorial120_Introduction-to-ASP.NET-Mobile.html
Have fun,
Senax
How are you going to access the applications deployed on the web server in your phone? I dont think there is a way to get static IP for phones. This is a strange thread.
I was thinking something like bluetooth PAN, Celio Redfly or the phone itself.
But also I am thinking the wiki should be mirrored on the web so that the access to the wiki is not dependent on the 3G connexion. Seems to be doable with mysql, at least from the phone mysql db to the webserver mysql db. I guess I'd need sthg to mirror data from the webserver to the phone, maybe OpenVPN or sthg else with mysql I don't know ...
Use 2D barcodes on your webpage to obtain applications easily via
(Use your phone) http://www.i-nigma.mobi/ 2D Barcode Reader
VPN Mobile;
http://www.pocketpcfreeware.mobi/download-vpn-mobile.html
Total Commander (free for smartphones/PocketPC/handhelds) has inbuild FTP.

Online database available from PocketPC

Hi !
I have my own server at home, in order to have access to my files outside my home. This is very convenient.
I would like to have an online database (with forms like you can have with MS Access, but Online) so that I can organize my information (foreign language vocabulary, DVD list, todo list, ...). I can install it on my server, and I would like it to be easily accessible from my PocketPC (via Internet, or even better via an specific application on the PocketPC ).
Do you have some suggest for an existing application offering this ?
I have good knowledge (I have already worked with .NET at work).
Regards, Chris
This is very interesting to me. Are you familiar with SQL Server mobile?
I know SQL Server 2005/2008 good.
I have never really used SQL Server Mobile, but I have read about it. Why ?

app development for LAN and internet

I am new to today's device apps. However have taken a big project which I am not sure is deliverable!! I want to develop two cross-platform application (desktop-windows/mac/android, mobile-windows,iOS/iPAD/IPOD etc), lets call them site-access and remote-access.
LAN(Option1, site-access) Front end: HTML/CSS/JavaScript Database:H2 Database access language:GO programming language webserver/web application server: Go programming language server running on a pc in company (company server). I am hoping that I could use JavaScript to trigger some functions/libraries in GO to query H2 database? Will it really work like that?
LAN(Option2) Front end:HTML/CSS/JavaScript Database:H2 webserver/application server:Apoche Tomcat database access language: Java servlet/Node.js
In this case, I am hoping that I would use javascript to communicate with node.js running in back end that will then communicate with Apoche Tomcat over servlet. Will it work?
remote-access (hosted on google app engine) Front-end:HTML5/CSS3/JavaScript Employee seamlessly easily use remote-access icon on devices to connect to company server- backend running under architecture 1/2 above- and access files off company server? I am hoping that I could use some additional database access conditions for remote-access app using GO programming language to design simple login features? I am sorry about my naivety in web-development. But your input will surely put me in the right direction. Thank you

Categories

Resources