Re: MYSQL with ASP driver
From: Laphan (news_at_DoNotEmailMe.co.uk)
Date: 03/16/04
- Next message: Wole: "Re: Using COUNT and ORDER BY in a SQL Statement"
- Previous message: Laphan: "Re: Best way to add a pic and a thumbnail pic when creating a content management system"
- In reply to: Jeff Cochran: "Re: MYSQL with ASP driver"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 16 Mar 2004 22:24:52 -0000
Many thanks for the info Guys
Rgds
Laphan
Jeff Cochran <jcochran.nospam@naplesgov.com> wrote in message
news:4051bc85.2566696975@msnews.microsoft.com...
On Thu, 11 Mar 2004 20:36:49 -0000, "Laphan" <news@DoNotEmailMe.co.uk>
wrote:
>Won't hold you to it, but can you let me know if you've had any problems
>using MySQL Db with the ASP-able MySQL ODBC driver?
Never had a problem. Don't use it, so that may be why... :)
Except for an iSeries/DB2 ODBC connection we've eliminated ODBC across
the board. Unfortunately, that one also supports several vendor apps
and the vendors can't or won't program to OLEDB.
>Taking on-board the advice you have given me in the past, I'm trying to use
>the OLE-DB drivers now, but if I use the MySQL option I'll have to go back
>to ODBC.
There is an OLEDB for MySQL:
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDB
ProviderForMySQL
>I don't have a lot of experience with MySQL, but I believe it is more of a
>cut down version of SQL Server (no stored procs until recently and no
>commit/rollback stuff) and actually less complicated to use - is this the
>case?
Not really. It's a different product, with many of the same
functions. Shouldn't be that difficult to use if you can handle MS
SQL.
>Many have said that MySQL is more reliable than SQL Server, but I'm not
sure
>how true this is.
Absolutely true. Except when it isn't. :)
These statements only apply to specific configurations, so it's
impossible to really make them across the board.
>Any advice you can give would be appreciated.
There are MySQL groups and mailing lists that can help too.
Jeff
- Next message: Wole: "Re: Using COUNT and ORDER BY in a SQL Statement"
- Previous message: Laphan: "Re: Best way to add a pic and a thumbnail pic when creating a content management system"
- In reply to: Jeff Cochran: "Re: MYSQL with ASP driver"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
