can anyone here tell me or point me on the right direction on how to connect to a SQL Server CE database using an XDA II ? i want to create a database application that is working on the XDA II that uses SQL Server CE as its database. any help will be much appreciated. thnx in advance.
anyone here in the forum ...
that is actually a developer for the XDA ?
it's for both xda and xdaX
wallaby forums are only for xda and so forth
if you want to access a db using oleDB then which type of db as in access or mssql or mysql or.....
all comes down to the connection string
of cause the sql server will have to be avaible to the xda
as in you can access it using gprs or usb or bluetooth or wifi or....
Visual Studio.Net 2003 has support for developing against the .Net compact framework (I think you might need professional or above). This has plenty of information and samples for connecting to SQLCE.
You may be able to do it with the Embedded VB using a connect string but this is not something I have even looked at!
Hope this helps,
Denver
thnx for the reply
i am currently studying VB.Net and reading on some of the white papers regarding Mobile Development but i still have yet to find an article that explains/shows how to connect to a SQL Server CE database using VB.Net running on a PocketPC Phone (particularly the O2 XDA II). i probably need to do more research about this but if anyone can provide more insights regarding this, i would really appreciate it.
Related
How can I programatically initiate a GPRS connection on an XDA (using EVB)?. I have a program which works when the connection is up (started using explorer) but fails when down. Would I do it using the TAPI?
Martin
I think you should have a look at the Connection Manager API.
I don't have any EVB sample code for you, but take a look at the PocketPC 2002 SDK sample CMHELPER usualy found at this path if you have eVC and the SDK installed:
C:\Windows CE Tools\wce300\Pocket PC 2002\samples\mfc\CMHELPER
BTW, you can download the SDK from www.pocketpc.com ...
here is the solution
I also was lookinf for this solution forever and never found it so i wrote the software myself. Here is the dll that you need to connect to the internet through evb it connects to the default connection no problems.
http://xdaconnect.wastedbrains.com
have fun,
Dan Mayer
Not knowing anything about C++, is there a simple way to open a GPRS connection with just eVB?
danmanmayer, can you send me the sources?
Or maybe somebody knows URL where can I found info about it?
Thanks in advance
SapphireRAS does all this and more.
Connects/Disconnects via GPRS using eVB or VB.Net
Create and manages connections, locations etc.
See www.sapphire-solutions.co.uk
ok. this is a question a ask before deciding into developing such a program.
How difficult ( i develop in .net and delphi for pc) is to buid a program that will transform the xda into a proxy for the desktop.
It is possible to enable both ActiveSync and GPRS ... but the desktop to xda is the task I'm looking for.
This could be a better replacement for the wmodem.
It could help some pint out to the libraries required to use and if anyone thought about it ...
Hi all, good forum, makes interesting reading
I've got an xda mini-s and moved my 'data on the run' app and database over from my old WM2003 pda only to find that AS4.1 no longer converts access *.mdb's to mobile access *.cdb's
Does anyone know if this has a solution or workaround
tia
cozzykim said:
Hi all, good forum, makes interesting reading
I've got an xda mini-s and moved my 'data on the run' app and database over from my old WM2003 pda only to find that AS4.1 no longer converts access *.mdb's to mobile access *.cdb's
Does anyone know if this has a solution or workaround
tia
Click to expand...
Click to collapse
Have you looked at their website or their FAQ?
http://www.biomobility.com/faq.htm#ActiveSync4
Thanks for the reply,
yes I did look on the biomobility support faq but wondered if anyone had found a workaround as the conversion code is still not available.
I suppose I'll have to keep using my old PPC with WM2003 to do the conversion and copy the tables to the mini-S manually
Another stroke of MS genius :roll:
Has anybody on these forums got MSMQ setup on an XDA Mini S running Windows Mobile 2005?
I just can't get it to start the service despite trying every possible option given on Google Groups incl. manually starting the service in code.
If somebody has could they please explain how as I would be most grateful.
Thanks! :?:
Im planning on building an android app. Its like a 'mini' social networking site that users can upload their pics, messages etc but im having trouble knowing how to 'start off'..
Servers, SQL, PHP and those types are not my thing, i have never came close to them as I have never done anything relating to servers but now I need to get close to them.
This is where im having the confusion:
Should I build a website that is the social networking site and store everything in the server that the website it connected to and then from the app i build, the app can fetch data from the website (or the server if thats possible) OR can I just directly build the app and make it communicate with the server so that gets rid of the issue of building a website.
Ive done a little research and have gotten some information but not a clear answer. I think my server will be using SQL so will the app be able to communicate with the database in the server directly or do I have to create a middleman such as a PHP/XML/JSON server for the android app to understand the SQL server since this is probably the common answer ive gotten when researching about android communicating with databases? (http://fahmirahman.wordpress.com/2011/04/21/connection-between-php-server-and-android-client-using-http-and-json/
Which approach is the easiest since im completely new to server languages (if thats what you call them).
Thanks for the help.
Hi man!
BTW the easiest way is to setup a PHP page on a server which sends JSON objects when data is requested by the client. Of course if you're good enough you could create a REST API for your server. After you get data from the server simply load the objects via a http/https request via your client.
I strongly recommend you make the API for the same. I'm doing an Android project which involves the same.
Sent from my Nexus 4 using XDA Premium 4 mobile app
boggartfly said:
Hi man!
BTW the easiest way is to setup a PHP page on a server which sends JSON objects when data is requested by the client. Of course if you're good enough you could create a REST API for your server. After you get data from the server simply load the objects via a http/https request via your client.
I strongly recommend you make the API for the same. I'm doing an Android project which involves the same.
Sent from my Nexus 4 using XDA Premium 4 mobile app
Click to expand...
Click to collapse
Oh ok. Thanks for the reply. Right now, im learning SQL since thats what most servers use. Then I'll probably get a server and experiment with it, although I have no idea on how create an instant messaging app Im pretty sure theres guides on the interwebs though
Don't forget to make APIs so that you don't have trouble figuring out client side programming. It will save you a lot of trouble.
Please give a thanks if you think this post helped you!
Sent from my Nexus 4 using XDA Premium 4 Mobile App .
boggartfly said:
Don't forget to make APIs so that you don't have trouble figuring out client side programming. It will save you a lot of trouble.
Please give a thanks if you think this post helped you!
Sent from my Nexus 4 using XDA Premium 4 Mobile App .
Click to expand...
Click to collapse
Sorry but im a bit new to android programming. What does API mean? Is it like Android version 2.2, 2.3, 4.1, 4.3 etc? And how can I make an API?
TwilightLoz said:
Sorry but im a bit new to android programming. What does API mean? Is it like Android version 2.2, 2.3, 4.1, 4.3 etc? And how can I make an API?
Click to expand...
Click to collapse
Straight from*Wikipedia:
In computer science, an application programming interface (API) is an interface that defines the ways by which an application program may request services from libraries
Java contains many libraries in those packages (Swing, etc.), and*the API*is the interface by which we request services (perform actions, etc.).
Since we're using Java for Android we are actually using the Java API by using any of Java's classes. All of Android's custom classes like Activity etc are part of the SDK library.The API is just a hook so you can latch on to libraries.
So in fact what you can do to create an API is a whole different topic altogether.
I suggest you Google it.
I'm thinking maybe I'll write a tutorial on this on xda for all members amateurs or pros alike.
Yeah I think you should write a tutorial. It'll help the community.