Re: MYSQL with ASP driver
From: Jeff Cochran (jcochran.nospam_at_naplesgov.com)
Date: 03/12/04
- Next message: Jeff Cochran: "Re: Best way to add a pic and a thumbnail pic when creating a content management system"
- Previous message: Tom Kaminski [MVP]: "Re: Maximum Number of Database Users and Roles"
- In reply to: Laphan: "MYSQL with ASP driver"
- Next in thread: Laphan: "Re: MYSQL with ASP driver"
- Reply: Laphan: "Re: MYSQL with ASP driver"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 12 Mar 2004 13:41:51 GMT
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#OLEDBProviderForMySQL
>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: Jeff Cochran: "Re: Best way to add a pic and a thumbnail pic when creating a content management system"
- Previous message: Tom Kaminski [MVP]: "Re: Maximum Number of Database Users and Roles"
- In reply to: Laphan: "MYSQL with ASP driver"
- Next in thread: Laphan: "Re: MYSQL with ASP driver"
- Reply: Laphan: "Re: MYSQL with ASP driver"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|