🚀 go-pugleaf

Janne wrote:
> 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.  


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/

Janne wrote:
>  Hi everyone,
> I have the same problem as Wholly in the previous thread. 
> Now, unfortunately none of the MySQL download mirrors have the 4.0.24 
> version in stock any more, the earliest seems to be 4.1. Haven't been 
> able to google one out anywhere else either.
> So, what do I?
> 
> 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

You're using Microsoft already so keep it simple and go with the free MS 
SQL Server Express edition.

Mike

> You're using Microsoft already so keep it simple and go with the free MS 
> SQL Server Express edition.

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