A more general question:
I am completely new to (building) databasedriven websites, but for
various reasons I really need to do that now. If anyone could push me in
a good direction I would greatly appreciate that: what I would want to
do is deploying a (free) database engine along with an aspx application
to an intranet server for use within a world wide enterprise. The whole
thing is very experimental at this stage, so I don't want to really
involve the IT-dpts too much, quite yet, or generate cost in any other
way. The server I have access to is an IIS 6 machine with .Net 1.1
running, and I'm using BDS2006 pro. I think capacity for maybe 100
simultanous connections should be plenty. The amount of data won't be
much to start with, but scalability is allways good of course.
I thought the MySQL-route looked very attractive, but if I can't get
hold of a compatible version of the DBengine, well, then I need some
other hint. I am (a lazy but) reasonably litterate person, so if anyone
could give me just a push in the right direction...
cheers,
Janne
--- posted by geoForum on http://delphi.newswhat.com
Hi Janne,
I can't help you with the first bit, but I can highly recommend a DB for
you.
Firebird 1.5.
it is compatible with Interbase 6, (it is actually the Interbase 6 open
source love child) and you can access it using the interbase drivers in
native W32 and .NET in the BDP.
There are also proprietry drivers which will support firebird future
versions which may differ from the Interbase counterparts.
I use Firebird for everything. It is free, powerful, almost no
maintenance, uses standard SQl.
I run numerous windows applications and ASP.NET web sites using it.
You can also deploy it 'embedded'. Which it isn't really, but means
there is no install, just deploy a DLL. Doing it this way does however
limit to a single connection at a time.
--
Robin.
Australian Bridal Accessories := http://www.bridalbuzz.com.au
Turbo for Noobs (a work in progress) := http://turbofornoobs.blogspot.com/
You're using Microsoft already so keep it simple and go with the free MS
SQL Server Express edition.
Mike
And, of course, you get the pleasure of using Microsoft's first class
ADO.NET provider, which supports connection pooling properly, and just
works, instead of the hacked together lame excuse that is BDP 2.5.
Mike