|
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
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
