Database Develop

Advice on web hosting plz

I need some advice on where to get some web hosting.. I basically need LOADS of disk space, LOADS of bandwidth
Needs to be relatively cheap though, im not rich :?
Thanks.

Erm this may not be exactly what you're after, kind of depends what you want.
I use a little proggy called no-ip (www.no-ip.com). It's free and creating your own website with WHATEVER name you want (as long as it's not taken) is FREE. ALSO you no NOT need to pay your service provider for a static IP address.
no-ip turns your computer (at home) into an internet server itself & the no-ip website automatically resolves your selected website name to the dynamic IP of your PC. Using your PC as a web server means that you can use WHATEVER web services YOU want for FREE. (I use Apache for my website itself - when I can be arse to run it that is)
Oh, and another thing, the amount of webspace you can have is limited purely by the available disk space on your PC, i.e. HUNDREDS of megabytes - again for FREE.
The only down side is that you (obviously) have to keep your PC on all the time.
The cool thing about this (for others reading) is that before I go to work, I fire up my PC & clickiity click no-ip into life, turn off the monitor & sod off to work. When I'm at work & in a lull period, I CAN REMOTE DESKTOP my PC at HOME from WORK. Ha!!!! No more restriced websites & site monitoring - Who-hoo! (Oh, that's only as long as someone else, e.g. the bloody wife - isn't using the PC as well)
Andy

Thanks for your reply...
I cant be doing with all the hassle really m8.. I have found these:
www.simtu.com
I have signed up to them on the advanced plan, 25GB of space and unmetered bandiwdth lol

Time to check: Are you using the right transfering tool?

There are a lot of tools for people to transfer large files, but it could be confusing and frustrating to pick which one to use. Use this to get a feel for what’s available and what will work best for you.
With the development of the global economy and the high technology, more and more people are contacting each other on internet. For example, savvy businessmen are doing business by internet. Friends can also transfer their favorites to each other to reach entertainment. Such as transferring movies, etc. Everyone knows transferring by software is an ideal format for transferring large files. But there are so many transferring tools, and everyone faces the problem of selecting which one is the fastest and suitable one to use. The speed and function are varies widely. Therefore, that means to select the right transferring software is important for people.
Compared with other softwares, Qoodaa has the character that the others don’t have:
1.Fast transferring Speed(sending & receiving files with full speed access).
2. Transferring large files offline.
3. High security with encrypted transfers and password protection.
4. Low cost.
5. Plus a ton of features.
Qoodaa was compared to “Black Horse” and it has become the fastest transfer tool in the world currently.
Choosing Qoodaa is your right choice!
Start files now, pls go to: http://www.qoodaa.com/ to download now!!!

Financial/Banking software?

I have been very happy (well at least not terribly disappointed) with MS Money 2006 and Money PPC 2006 on my Tilt, but it's time for a change. I just bought a Fuze; it should be here tomorrow, and I need to install something to keep track of my checking account register. It also needs to sync with some sort of desktop software, so I don't have to start from scratch each time I flash a new ROM. Does anyone have any suggestions?
By the way, I searched for financial and then banking; I didn't see anything. I apologize if I'm forgetting something; I've been awake for a very long time, so it wouldn't surprise me.

A few I've tried are SPB Finance and CashOrganizer. Both are VERY similiar and sync to your desktop Quicken or Money programs. And both cost money. I've tried several free finance programs but I couldn't find one with the capabilities that SPB or Cash Organizer had. SO...that being said, I ended up purchasing Cash Organizer.
http://www.spbsoftwarehouse.com/products/finance/screenshots.html?en
http://www.inesoft.com/eng/index.php?in=premium.html
HTH!

I use Quicken at home and pocket quicken on the road http://www.landware.com/pocketquicken/

You can also try Bankarama. Works pretty good and easily enter data without all the complications of 500 different hoops

Cash Organizer 2008
I use Cash Organizer 2008. It has a great planner, budget tools, you can export to Excel both your register as well as your budget etc. It will sync to Money and Qucken but after having gotten comfortable with using it on my PDA I decided that I did not need to use Money any longer. Daily (or almost daily) I download my bank statement from the web on my device and quickly update my registry in Cash Organizer. I keep backup copies to protect myself against the loss of my PDA and now rely solely on my PDA for all my finance needs. I have tried Splash Money and Spb Finance but do not like them as well.

Thanks for the responses; I ended up getting SPB Finance, and so far I'm really impressed!

I use Ultrasoft Money on my Fuze with Microsoft Money Plus on my laptop.

Do any of these let you put your default curreny as £. I know it's a small thing, but seeing $ all over my money annoys me.

Does anyone know of a financial software that works well with RealVGA? Pocket Quicken was unreadable and Cash Organizer only filled a quarter of the screen...

AceMoney
I use AceMoney on both the PC and the PocketPC. There is a lite PC version that allows for only one account that is free. The full version is $ and the PPC version is $, but they work great. They are basic, but do lots of what the big boys do.
It doesn't sync automatically though. Whenever I make changes on one platform I make sure to copy the file to the other as soon as possible.
www.mechcad.net
I've had a few issues here and there over the years, but the developer always seems to help me out.
I've tried others and I keep coming back to this one.

Android Access Database

Here we go:
I use a number of Microsoft Access Databases for my work, and each one is intensely coded and designed and basically run like actual programs. What I am looking for is to be able to take these databases with me. Now understanding that Microsoft and Android are two completely different beasts, what I really am looking for is the ability to take the tables (I use all Back-end database so all my tables are in a completely separate file then all my forms, queries, and reports) and the data with me and be able to run them in a program on Android that keeps the relationships and fields and all of that sort of stuff.
Now what would be great is the ability to use forms (even if special forms for android need to be made), run queries, and even be able to run reports and print as PDFs.
now I know how to code in VBA, hence the extensive coding I have done in Access, so anybody willing to WORK WITH in creating an Android Program to basically be an extension of Microsoft Access please contact me. Please not I use the words WORK WITH loosely, while I am trying to learn how to Program for Android, I currently do not have a computer that I can use to develop programs for android on, and well I would be only able to create the "Hello World" starter program and this project seems a slight bit more complicated. But what I can bring to the table is real world experience in testing and using the program day in and day out, a number of already existing Microsoft Access Databases ranging from Complex to Simple that I use every day. Really a program that can run Microsoft Access Tables on Android would be really useful to me and I am willing to do anything to help make this happen.

kronos82 said:
Here we go:
I use a number of Microsoft Access Databases for my work, and each one is intensely coded and designed and basically run like actual programs. What I am looking for is to be able to take these databases with me. Now understanding that Microsoft and Android are two completely different beasts, what I really am looking for is the ability to take the tables (I use all Back-end database so all my tables are in a completely separate file then all my forms, queries, and reports) and the data with me and be able to run them in a program on Android that keeps the relationships and fields and all of that sort of stuff.
Now what would be great is the ability to use forms (even if special forms for android need to be made), run queries, and even be able to run reports and print as PDFs.
now I know how to code in VBA, hence the extensive coding I have done in Access, so anybody willing to WORK WITH in creating an Android Program to basically be an extension of Microsoft Access please contact me. Please not I use the words WORK WITH loosely, while I am trying to learn how to Program for Android, I currently do not have a computer that I can use to develop programs for android on, and well I would be only able to create the "Hello World" starter program and this project seems a slight bit more complicated. But what I can bring to the table is real world experience in testing and using the program day in and day out, a number of already existing Microsoft Access Databases ranging from Complex to Simple that I use every day. Really a program that can run Microsoft Access Tables on Android would be really useful to me and I am willing to do anything to help make this happen.
Click to expand...
Click to collapse
I think we must have the same job
Android utilizes an sqlite database engine and it looks like sqlite already offers a conversion utility HERE. The real question would be how to get the data in and out of the phone. Regarding forms, they definitely would need to be custom built.

Thanks this is deffenetly a start, From what I can tell this This Looks to be the most promising, It looks like all you would have to do is put a MS Access Database file on your SD CARD and have a program access it. That way you copy it back and forth. Unfortunately it doesn't support Access 2003, but I can save down. I also got a lot of learning to do in programing Java programs.
Forms would be as simply as making a program, this is great thanks much

kronos82 said:
Here we go:
I use a number of Microsoft Access Databases for my work, and each one is intensely coded and designed and basically run like actual programs. What I am looking for is to be able to take these databases with me....
Click to expand...
Click to collapse
I would like to say, "yes, please!" to this idea. I currently use Smart List to Go (the descendant of ThinkDB) on my Palm TX. The TX is dying, and I've been shopping for a replacement. HanDBase exists for the iPhone, but I don't want an iPhone. So I've been focused on WinMo - not by choice as much as by necessity.
And android option would be very welcome around my computers.

benmyers2941 said:
I think we must have the same job
Android utilizes an sqlite database engine and it looks like sqlite already offers a conversion utility HERE. The real question would be how to get the data in and out of the phone. Regarding forms, they definitely would need to be custom built.
Click to expand...
Click to collapse
androids sqlite its for applications to access and store data using java code.
try the pocket office app

Freedomcaller said:
androids sqlite its for applications to access and store data using java code.
try the pocket office app
Click to expand...
Click to collapse
Exactly and we're talking about creating an app that would enable manipulation of an sqlite database. Essentially all that would be needed would be to create a ui framework wrapper for the existing api in android. Not the least monumental task I've heard of an individual taking on but not the most either.
The versions of pocket office that I've seen for android do not currently support Access databases as far as I'm aware. If I'm wrong could you post a link and save everyone some trouble?

aaaaaaaaaaaaaaaaaaa

kronos82 said:
Thanks this is deffenetly a start, From what I can tell this looks to be the most promising, It looks like all you would have to do is put a MS Access Database file on your SD CARD and have a program access it. That way you copy it back and forth. Unfortunately it doesn't support Access 2003, but I can save down. I also got a lot of learning to do in programing Java programs.
Click to expand...
Click to collapse
Jackcess library is now patched to support android (will be in 1.2.2 release). Also seems to support 2000, 2003 and 2007 formats now.
Works great for me.

View jackcess site. Couldn't find anything on support for android. I'm using htc desire and would really like to find program to view ms access file. Can you tell me how you do it?

As I remember reading worked as on PC, while writing had some problems.
This forum prevents me from linking directly, but if you click tracker/patches on Jackcess project, check Android Compatibility Fix - ID: 3101578
The changes are in trunk and will be in the 1.2.2 release. I've added some
notes which will eventually make it to the FAQ page on the website
detailing the compatibility steps:
- Set the system property "com.healthmarketscience.jackcess.broken
Nio=true"
- Set the system property "com.healthmarketscience.jackcess.resour
cePath=res/raw/"
- Copy the *.txt, *.mdb, and *.accdb files from the
"com/healthmarketscience/jackcess/" directory in the Jackcess jar to the
"/res/raw" Android application directory.
- Before executing any Jackcess code, set the current Thread's context
classloader, e.g.
"Thread.currentThread().setContextClassLoader(Database.class.getClassLoader())".
Click to expand...
Click to collapse
Until this version (1.2.2) is released you need to build lib yourself.
You also need commons-lang and commons-logging from apache commons.
Before you use Jackcess in Android code, you set
Thread.currentThread().setContextClassLoader(
getClass().getClassLoader());
System.setProperty(
"com.healthmarketscience.jackcess.brokenNio",
"true");
System.setProperty(
"com.healthmarketscience.jackcess.resourcePath",
"res/raw/");
Click to expand...
Click to collapse
and copy those resource files to res/raw
Then you can work as on PC, for example open /sdcard/yourprogram/file.mdb
Jackcess has no GUI, it's a library to read/write access files.

Getting an Access file into Android
I keep a lot of information on a Psion Revo, which has just turned its face to the wall and is giving up the ghost, and have always backed the information up on to my pc as an Access file. It looks easier to get this into a format acceptable to Android by converting the Access .mbx file into an Excel .xls file. This can be searched readily by Column and Values. Maybe this deals with too simple a need for most enquirers to the forum, but if it helps somebody then so much the better.

hi all i have beenlooking for something the same for some time now and just the other day i came accross this site cellica.com
the android app is free and the desktop application has a 5 day trial period or its $50 to buy it works great the only thing you can not do is create a report from the phone
i have emailed support team and they said they will be adding it on in the future.

Any Updates???
I currently build and use databases in MS Access and was wondering if there are any updates on this topic now that Tablets are in use now. Looking to get the Motorola Xoom (2nd version) in the future, but would love to be able to use a program that I would be able to access my MS Access databases while "on-the-go".
Anyone? This would be huge (I believe), since we now have tablets.
Thanks a bunch,
~Kilch~

Access to MS Access by Android
Hi,
I'm also looking to get on-the-go access to my Access databases on my Android HTC Tattoo.
The file is on it, I just need a tool to access it in read-only / search mode, but judging from the previous comments, there doesn't seem to be an oversupply in applications.
The "convert to Excel format" may be OK for me. I want to use a 3 language Access DB (dictionary) on my phone, so I'll try the Excel solution.
It would be nice if we had an ACCESS reader though...
John

Panacea Database
I know XDA frowns upon excessively hawking your own products here, but I do seem to be directly answering more than one of the reply questions, it just happens that the answer is an application my company released.
The Panacea Database application can handle Access from Access 2000 to Access 2007. It has also worked so far on every Access 2010 database we've tested, and we've received no complaints in that department yet. We release updates from time to time as we improve its functionality and features, often guided in our priorities by user e-mail and market comments. Our next update will be focused on improving screen layout for a variety of Android devices - from small QVGA smartphones, to large WXGA tablets. After that we may move onto other functionality.
In the interest of fairness, I'll point out arafa1209's post. He mentions Celicca Database, which is the only other application that I know of that deals with Access databases on Android. It has features Panacea does not have (yet) - ability to work with forms, ability to create and modify databases, ability to connect to your PC etc. Like us, they also send out updates improving their app regularly. So you can compare the apps, and use which one fits your needs better (or use both). If anyone knows of any others they can post here as well, but these are the only two I know of currently.

Just tried Panacea. Although it is more basic and annoyingly doesn't remember the last files you'be opened necessitating finding the file each time you open the app I prefer it for the simple reason you don't have to convert the Access database to another format.

amwebby said:
doesn't remember the last files you'be opened necessitating finding the file each time you open the app
Click to expand...
Click to collapse
If you update the app, this should be fixed, the last version should have this feature.

Got the update last week. Certainly goes a long way to making it more user-friendly. Keep up the great work!

Since the last update it seems to be broken. Although it remembers the last database I cannot open a table within any database.
Edit: It appears the file was corrupted. Loaded a new file and all working again.

Any news in this topic.
I tried panacea Database, works fine. But not very effective. Searching data is a must for me however I didnt manage to find a search option. When I search for tables, it cant even locate the tables by names.

[Q] WP8, Phone>Documents & Text files

Hi all, just a quick question regarding the functionality of Wp8 that I am fighting with, that I need to resolve or another WP phone is going back to the supplier [I did the same with WP7].
First off, apologies if there's an answer that I haven't managed to find.
I currently have an HTC HD2 running very nicely on WM6.5, however, it's been creaking a bit recently & I'd decided with a favourable review of WP8 that I read the other day suggesting that finally the device can be plugged into a PC & seen as a USB drive, that the time was right to move forwards.
Now that I have the Nokia Lumia 820 & WP8 however, I still don't think I can get it to do what I need it to do.
ALL I would like to do, is be able to copy text files from PC to WP8, & then display them on the phone with text wrap switched off.
Easy hey? Well if so, I haven't worked out how to do it yet!
I plug the phone into my PC, & an Explorer window fires up on the PC [XP] showing 'SD card' & 'Phone'. Drilling down one level on the latter gives Documents, Music, Pictures, Videos etc.
The only way I can get to see the Documents folder on my Phone appears to be via Office Mobile, under 'places' > phone. It appears to be very fussy about what it allows to be displayed there - I can see .PDF, .DOC, .XLS & .TXT files [but not .LOG. .ONE, .ZIP etc (which remain 'hidden')].
When I tap a .TXT file, I have no choice of how to open it, Office Mobile pounces & that's that. Having got this far, all I would now like to do is switch off text wrap [so that it'll view in a usable manner] because there doesn't appear to be such an option.
I have scoured the Store, & the best I've found is 'Text Reader', though this requires that I load it via email [upload a file to Hotmail or wherever with a .LOG (or similar) suffix & away you go, which it then downloads & stores in its own sandbox]. Ok, but faffy.
I believe that other progs might enable transfer via the cloud [Skydrive or whatever], but because of the nature of the data [& the fact that I don't want my data in anyone else's hands], this is out too.
I've spotted a couple of other quirks.
Office Mobile also does not allow you to display the folder hierarchy that may exist in Phone>Documents, just giving a flat filesystem, which makes finding a file in thousands, say, horrible. All I'd like to do is exactly duplicate the hierarchy that exists on the PC [& then I am always looking for things in the same place on either device].
I have also noticed that Office Mobile Word sometime hangs part way through a file. e.g. on loading a 1mb file, & searching for a text sequence I know to be on the last line, it hangs on a line part way through the file [say a 1/3 of the way in]. Not great, & I have the odd file that's c.10mb so I dread to think with that.
Words fail me, & once again I am hugely disappointed with MS. Please, please get the odd decision right & maybe WP will be at the top of the pile again as it was with [the sometimes awful, but very functional] WM.
I am hoping that someone will explain an easy way to do this, & that I can finally move forwards from WM6.5. Android concerns me re privacy & I don't like iPhones, so not much choice really! Stuck waiting for MS to provide basic functionality or [worse] a potential need for a future jailbreak to make the thing work properly!
Here's hoping. Many thanks for reading.

First of all, nobody who knew what the hell they were talking about said that WP8 displays as a USB drive (properly called USB Mass Storage). It's an MTP device, like most media players (or indeed WP7, though that had an extra layer of encryption around it). MTP doesn't display the actual filesystem; although the hierarchical display that it presents *may* mirror a real filesystem, it's under no obligation to do so.
The dearth of supported file types in WP7 was a real pain, but it could be fixed by tweaking the registry. In WP8 it's still a pain, but now third-party apps can (officially) register to handle file types. However, as you point out, there's no real way to browse the phone, and the Office hub only shows the filetypes it recognizes. We *might* be able to fix that, if we could get registry write permission, but that's not possible right now. With that said, I don't know if it would be possible for another app to register the (for example) .txt extension; the phone does offer the ability to choose what app opens a given file type.
For what it's worth, Bluetooth file transfer to the phone works fine, and the files will open in whatever app is registered to the file's extension. You can then save them into the app's storage (Documents, for Office apps). This may be a better way to transfer your data.

In WP8 you can build Apps that associate themselves with certain filetypes (identified by the ending). If your App is associated with a certain file type the App can also open files of that type from anywhere on the SD Card.
So for example if you put a *.log file onto the SD Card any App that is associated with the ".log" ending can read it (the Explorer functionality for the SD Card would have to be implemented by the App itself but it is supported). This does not work with the integrated storage though. With integrated storage you would still have to receive it via E-Mail, SkyDrive, etc.
Now for the caveats:
- Apps can't be dynamically associated with File Types. If you want to open "*.log" files the App developer has to associate his App with the filetype in it's manifest. If several Apps exist for a given filetype the user will be asked which one to use.
- There is a quite extensive list of file types that are reserved for the OS or built in Apps. Any file type that is reserved in that way can't be associated with third Party Apps. This contains Office documents (except PDF, TXT files and lots of media file types). The complete list can be seen here: http://msdn.microsoft.com/en-us/library/windowsphone/develop/jj207065(v=vs.105).aspx
- Apps can only read from the SD Card but they can't Change data there.
Now as for your Problem: someone could build an App that supports e.g. Log-Files and you could use your Lumia 820 with an SD Card to pretty much work the way you intend to with those files. It's not really trivial though, given that 10 MB big plain Text-Files regularly lead to Trouble even on PC text Editors (the developer has to be smart on how to handle These "huge" files, so just some midnight hack job won't do).
What are your further requirements? Search pretty obviously. But what are all the filetypes you would need? Would you need editing capability?
Just trying to understand the compelete picture of your requirements. Perhaps you can tell us what kinds of files you use and for what purposes.

Thanks for taking the time to reply.
@GoodDayToDie
Re 'seen as a USB drive' - That's me being careless with words, what I meant to say was the ability to local sync over a USB cable, & then access the copied files on the device. I didn't think that you could do this with WP7 [without frigs], & had high[er] hopes for WP8.
I might have a look at Bluetooth FT as a method for getting the [bulk] data over locally, as I won't be doing it via the cloud [email or Skydrive]. Thanks for the advice.
@StevieBallz
Thanks for the MSDN reference - Very interesting.
Ok, so the apps can potentially access the data on the SD card but not write to it - As an aside, I thought I read something the other day that said data on the SD card was limited to Pictures, Videos, Music etc, as a security measure. That's interesting too then, though anything I want to be 'secure' I'd keep in the internal storage anyway.
Re the comment re 'Trouble even on PC text Editors'. Yes, I tried way back on WM2003 to get a file displayer going, but immediately hit problems with [I think] a 32KB limit on the textbox display. I've just made do with WM6.5's Word displayer since, which offers basic functionality.I keep meaning to go back to the coding, but haven't managed it yet [I think Visual Basic was missing for a while with WP, if indeed it's there yet (I thought I'd read it was with VS2012?)].
Re my 'requirements'. Just to be able to search [large-ish] text files & have the o/p displayed in a manner that's readable [no word-wrapping]. I realise editing is a whole new ball game, so read-only would be good enough. Longer term, I'd like the ability to have many text files open at once - On the desktop I use "Programmer's File Editor", & something like that [if only as a viewer] I'd find invaluable on the smartphone/PDA. I also have many thousands of files on my desktop [PDF, DOC, RTF, HTM, TXT etc] & ideally I'd like access to those on the go as & when needed, via a hierarchical file system on the mobile device, with the structure exactly mirroring the PC's file system, so that I'd search for & find data in the same places regardless of which device I was using [Why thousands? Might be 100s+ actually, & these could be electricity bills, sales receipts, insurance documents - anything - the stuff of life really].
I'll continue with my testing of Office Mobile Word's displaying & searching of text files. I've found it patchy & not consistent so far, but am going to have to move from WM6.5 eventually [more's the pity], & don't really want the hassle of sending the device back again.
Many thanks for your advice so far.

Device returned, many thanks for your help. Maybe WP9 then?

5v17 said:
Device returned, many thanks for your help. Maybe WP9 then?
Click to expand...
Click to collapse
Judging by the ideas picked up for review on dev user voice, situation may drastically improve with the next SDK update.