Online database available from PocketPC - General Topics

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 ?

Related

Share a folder on your device, via SMB/CIFS?

I want to share a folder on my PPC, which i could access on my PC through WiFi, with the simple windows sharing protocol - SMB/CIFS.
i.e: i want to be able to browse my PPC with the address: \\HTCUniversal\Storage Card\Music ....
I'm wondering, how could it be that there is no app/service that will provide this???
It seems like a really basic and simple request, but yet i've found no solution to this.
I found "Mocha FTP Server", but it doesn't quite do the job, because i have to run it manually everytime i want to browse my ppc, so its not that comfortable.
If only i could run such an app as a small service - it would be perfect.
Any ideas?
There are many free SMB implementations on the net under GNU/GPL license, maybe someone could port it to a windows mobile platform?
smb is known simply as "Microsoft Windows Network".
http://en.wikipedia.org/wiki/Server_Message_Block
smb and it's server samba is just what linux work call what windows world call
"microsoft network"
use total commander to connect to shared drives you may have to add
the pda as a valid user on the shares though
thanx for your reply, but you must have misunderstood my question.
in a nutshell - I want a samba/SMB/ms windows network server on my ppc (NOT a client).
i want to access folders on my ppc, through my pc, using Wifi.
not the other way around...
doh! my bad
sure it's possible but preciously few of such server services have been implemented on wm that i know off
not sure if it's because lack of demand
lack of mem and cpu juice(i mean an arm 400Mhz cant hold any kind of cantle to an old 400Mhz p4 or amd cpu)
or if it's the fact that batt power and stablity and lack of a device which make everybody else time out due to power saving settings
maybe the people who would be poking at that bear are busy making linux useable on these pdas

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.

Database systems

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

c# to mysql with new toy

Hi All,
I recently got a new toy, in the form of a pocket PC (mda varrio 3), and want to learn how to program for it in c# using Visual Studio 2008. I have experience of C, Pascal, PHP etc and have a few questions for you all:
1) I have websites with a mysql database and was wondering if c# was good for accessing the data on these websites within an application (not web browser) on my phone?
2) I’m struggling to find basic step by step tutorials that will help me write such an application. Could someone please point me in the correct direction?
3) Are there good websites with lots of c# sample program applications that I can see the code? I have looked on the Microsoft site, but the c# samples seem to be lacking.
Sorry if these questions have been asked before, I had a quick look and couldn’t find what I was looking for ….
Thanks in advance,
Reggie.
Hi,
Connecting from the Phone Directly to MySQL is a bad idea, ideally you should create some sort of webservice or remoting middle tier(afaik .net 3.5 CF supports this). The reason I say this is that the connection string will have to be embedded in the device and anyone with a bit of know how will reverse engineer it and be able to access you MySQL Server.
That said, connecting to MySQL in C# is easy: have a look here for some .net articles : http://dev.mysql.com/usingmysql/dotnet/ (just port the VB to C#).
Thanks
Dave
reggie4 said:
Hi All,
I recently got a new toy, in the form of a pocket PC (mda varrio 3), and want to learn how to program for it in c# using Visual Studio 2008. I have experience of C, Pascal, PHP etc and have a few questions for you all:
1) I have websites with a mysql database and was wondering if c# was good for accessing the data on these websites within an application (not web browser) on my phone?
2) I’m struggling to find basic step by step tutorials that will help me write such an application. Could someone please point me in the correct direction?
3) Are there good websites with lots of c# sample program applications that I can see the code? I have looked on the Microsoft site, but the c# samples seem to be lacking.
Sorry if these questions have been asked before, I had a quick look and couldn’t find what I was looking for ….
Thanks in advance,
Reggie.
Click to expand...
Click to collapse
If you install the Windows Mobile 5.0 or 6.0 SDK (it was an option when you installed Visual Studio, assuming you didn't install the "express" version), or you installed it afterwards, you'll have a directory in C:\Program Files (or your equivalent) for the SDK (for example, on my machine the 5.0 SDK is here:
C:\Program Files (x86)\Windows Mobile 5.0 SDK R2
Under there you'll have everything you'll need to get started. Especially interesting should be the contents of the Samples folder (PocketPC is for devices with touch screens).
Good luck, and have fun!
any c# guide how to connect to mysql would work
.net works the same in 99% of cases on pc and ppc
Thanks Rudegar, I thought as much - but couldn’t find a simple step by step guide including Visual Studio 2008 with example code.
Thanks godefroi, I have had a look in here, but there aren't many c# samples and I can't find one c# to mysql sample.
Thanks DaveShaw, I didn’t explain myself well enough. I have a website with a mysql database on it (on web server) and I wanted to be able to update the site from the net (eg my laptop) and when I am out and about (from my phone). I wanted to write an application that runs on my phone that can read and write data to its own local database (or this web database depending on signal) and then synchronise the local and the web database when 3G signal becomes availabile.
I hope i have explained myself more clearly?

SQL database editor?

Hey everyone,
So I was just thinking over what I would love to do with my Transformer/Dock combo and one thing came to mind.
I can connect to my office via VPN, access our company intranet and use various web based tools but there's one thing I'm missing: SQL access.
I use GUI tool that lets me have several DB connections open and run SQL in a window along with seeing the results of the query. I can drop or truncate tables, etc also.
So my question is: Does anything like that exist for Android and more specifically, Honeycomb so there's a bigger screen?
Thanks,
-Bob
How about phpMyAdmin or similar installed on one of the SQL servers. Or using remote desktop/VNC to remote control a PC with the MS SQL tools on it.

Categories

Resources