|
As for OLEDB driver I'm not sure - most drivers can be found at http://www.firebirdsql.org/
When it comes to a GUI you have a lot of different ones to choose from both freeware and commercial, check out
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_contrib_download
This said the main focus for me is the small footprint combined with the excellent performance. This gives me the ability to rapidly and effortlessly transport the whole db or only a subset of it to a new location (or locations) either as a new server installtion, standalone or embedded.
|
|
|
|
|
sormel wrote:
This said the main focus for me is the small footprint combined with the excellent performance. This gives me the ability to rapidly and effortlessly transport the whole db or only a subset of it to a new location (or locations) either as a new server installtion, standalone or embedded.
I think this can be the MS Access alternative that i've been searching for !!!
|
|
|
|
|
I'm currently testing firebird (in its embedded version) for one my project. The whole thing is great, but it really needs a GOOD gui, 'cause everything I've used so far is either useless or expensive.
If it really wants to spread and replace MSDE in many projects, that's something the open source community has to do. Okay, most of us use the "complete SQL server" tools to manage our MSDE engines so you can say that those tools are expensive, but hey, how many of us work in companies that don't have any SQL server licence ?
Michael CARBENAY
|
|
|
|
|
I so wish we had just one database to worry about. As things stand we have MS SQL Server 2000, Sybase SQL Server 12.5 and Oracle 9i all deployed and our products integrate with them using their native APIs. So there isn't any "primary database technology"... we only work with the common features of all three... however I voted for MS SQL Server 2000 because that's what I like to work on.
|
|
|
|
|
Using MS Sql-Server (MSDE) in my application installations, but I am now considering MySQL.
Looks neat...
|
|
|
|
|
Take a version of MySQL 4.0 or above. That's all I can say about MySQL. the older versions don't have foreign keys and stuff like that.
WM.
What about weapons of mass-construction?
|
|
|
|
|
Looks like stored procedures are only in starting at 5.0 (beta right now)
But that's okay: I dont use any stored procedures right now.
|
|
|
|
|
Apparently PostgreSQL is a lot better but I've not had any personal experience of it. Might be worth looking into if you're using it for business use.
--
Andrew.
|
|
|
|
|
I am also considering MySQL.
But the problem is I was not able to find a reliable interface to access MySQL so far.
MySQL works perfectly with PHP, but when I try some of OLEDB or ODBC drivers it always has lots of problems.
Can anyone suggest a reliable interface to access MySQL - OLEDB or ODBC provider?
Can you give me an URL to download it from?
Best regards,
Stefan
|
|
|
|
|
did you install the latest version of MDAC (Miscrosoft)? I had an issue with .NET / ODBC connection to MySQL until i updated to the latest MDAC (2.8 i believe, at the time).
Alternatively there is myOleDB: http://solutions.mysql.com/other/related-sites/?item=142[^]
I haven't tried this so i can't say whether its any good...
|
|
|
|
|
|
I've used ByteFX (which mysql bought and is now what that link is to). it works great. the guy who wrote it, wrote it completely in C# w/ no outside dependencies (other than #ziplib). its a great provider & I'd highly recomend it!
/bb|[^b]{2}/
|
|
|
|
|
|
or you could get the one mysql provides for absolutely free (which doesnt use any of .NET's standard clients, but does its standard ado.net implementation 100% as mysql intends). I can give anyone my paypal address if they're into throwing away money :P
/bb|[^b]{2}/
|
|
|
|
|
you might have a look at VistaDB!
|
|
|
|
|
i've been working for two companies in the last tow years and all is SQL server 2000 , can't wait for SQL server 2005
|
|
|
|
|
I am also waiting for it, but even if it comes up I will have to wait until at least nine months before I can start using it because it's unlikely that our clients will support it.
Regards,
Alexandru Savescu
|
|
|
|
|
I use SQL server 2000 in most of my projects. Sometimes if the customer asks for it, I can put in MsAccess (in rare ocasions) or MySQL. But those two aren't as good and complete as SQL server 2000.
Where access lacks power when used over a network with multiple users. MySQL lacks relational things like foreign keys (not anymore after 4.0).
I can't wait for SQL server 2005, it's promising and I think my customers are going to love it
I'll bear with you two!
WM.
What about weapons of mass-construction?
|
|
|
|
|
I also believe that SQL Server 2000 is the best among the list. Also Waiting for 2005 version.
Lav Pathak
Application Developer
Auxiliary Enterprises
Kalamazoo, MI
|
|
|
|
|
AbdKel wrote:
can't wait for SQL server 2005
because SQL Server 2000 is so good, or SQL Server 2000 is so bad?
Pandoras Gift #44: Hope. The one that keeps you on suffering. aber.. "Wie gesagt, der Scheiss is' Therapie" boost your code || Fold With Us! || sighist | doxygen
|
|
|
|
|