[OT - sorta, maybe?] SQL alternatives

S

Steven Burn

Okay.... long story short, I'm currently using an Access DB for the site's
I've developed that require one. What I was looking to do was convert them
to SQL database's, unfortunately this is not an option as my host doesn't
provide them (atleast, not for free anyway) so I'm looking for alternatives
as Oracle, SQL, MySQL etc etc, are not available.

Server's are all running Windows Server 2003

Suggestions please anyone.....?

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!
 
M

Manohar Kamath [MVP]

Steven,

Is this database read-only? Or, do you update that as well? Plus, why do you
want to move away from Access, if none of the other options are available?
Looks like Access might be your best option.

On the other hand, if you have a read-only database, and want to move away
from Access, you could look into XML files. However, this might be tedious
in both creating and maintaining.
 
W

William Morris

Steven Burn said:
I actually love using Access. My reason for enquiring is because of the
comments made at;

http://www.ukbusinessforums.co.uk/viewtopic.php?p=4543#4543

I'm pretty sure he's talking rubbish as I've never had a problem yet, but to
be honest, would rather not take the chance, aswell as the storage
limitations that Access has.

Oh and, nope...... they're not read only ;o)

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!


Access should absolutely NOT be used for an enterprise solution. Have a
look at

http://www.aspfaq.com/show.asp?id=2195

I'm surprised that your host doesn't provide at least MySQL, which is a free
database. There really isn't a substitute for SQL databases if you're
looking for that kind of functionality.

- Wm
 
S

Steven Burn

Nice article ;o)

As for MySQL, they provide it for the Linux servers, but not the Windows
servers unfortunately :eek:(

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!
 
S

Steven Burn

hehe, so I noticed (after reading the article referenced by Mr Morris)

Unfortunately, it seems I'm screwed as far as anything else is concerned as
I simply can't afford to have support for them added.

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!
 
A

Aaron [SQL Server MVP]

? How much are you paying now? There are tons of other hosts out there
that will allow MSDE and/or MySQL on a Windows machine.

Why would they support MySQL on Linux but not on Windows?

--
http://www.aspfaq.com/
(Reverse address to reply.)
 
S

Steven Burn

I'm currently paying £90 per year (covers the costs of all of my site's
(approx 50GB) w/unlimited bandwidth)

As the why's....... I've no idea unfortunately :eek:(, just been told MySQL is
included as standard with Linux, and only available for Windows at the extra
cost of £70 per year.

The host I'm using is Fasthosts but, going through Inspiratech 2000 Ltd
(Fasthosts reseller) as it doesn't cost as much.

Fasthosts - www.fasthosts.co.uk
Inspiratech 2000 Ltd - www.inspiratech.uk.com

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!
 
J

Jeff Cochran

[Response to suggestion to change hosts...]
Rofl....... if only :eek:\ (not an option atm as I can't afford it)

So, you have a host that doesn't have any database alternatives to
Access, you can't use Access, and you can't change to a host with
alternatives.

Have you considered a few dozen Valium and a bottle of gin to end your
misery...?

Jeff

PS: Please don't be foolish enough to follow my advice here... :)
 
W

William Morris

Jeff Cochran said:
[Response to suggestion to change hosts...]
Rofl....... if only :eek:\ (not an option atm as I can't afford it)

So, you have a host that doesn't have any database alternatives to
Access, you can't use Access, and you can't change to a host with
alternatives.

Have you considered a few dozen Valium and a bottle of gin to end your
misery...?

Jeff

PS: Please don't be foolish enough to follow my advice here... :)

Yeah, no kidding! Gin is nasty stuff. Bailey's will go down smoother, and
doesn't taste of overripe shrubbery. :p
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OT - sending HTML email 2
[OT] Server 2003 + Access 23
[Perhaps OT] Zip 2
OT - Microsoft using Linux???? 1
use the oleDBCommand in ASP 2
Replace Function 6
Block "HEAD" method? 2
ATTN: Daniel Ng 5

Members online

No members online now.

Forum statistics

Threads
473,743
Messages
2,569,478
Members
44,899
Latest member
RodneyMcAu

Latest Threads

Top