|
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
|
|
|
|
|