Hi Dennis,
>You CAN NOT, as far as I know, connect to a MySQL database, through ASP (or
>any other program, I believe), without having at least the MyODBC driver
>installed on the server.
This is not entirely correct. ODBC is merely just one more way to connect
to MySQL. MySQL just like many other databases in the industry has an API
which can be used to connect to the server with out going through all the
Microsoft imposed protocols such as ODBC & ADO.
A good example of this is PHP (http://www.php.net) . In general, PHP does
not use nor require ODBC to be installed in order to access a MySQL
database.
So is the case for Zeos (http://www.zeoslib.org/) which is a free set of
components for accessing MySQL (and other databases) directly by means of
the API calls rather than ODBC (for Delphi & C++ Builder).
In terms of Microsoft's software, which all support ActiveX, there is at
least one COM object that I know of that can connect directly to MySQL
without using MyODBC. Such component is called MySQLX and can be found in
http://www.scibit.com .
Regards,
Jorge
MySQL Development Team
__ ___ ____ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\____/ Mexico City, Mexico
<___/
----- Original Message -----
From: "Dennis Salguero" <[EMAIL PROTECTED]>
To: "VVM Ravikumar Sarma Chengalvala" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 7:06 PM
Subject: Re: ASP and my sql??
> It depends on what you mean by "without using ODBC".
>
> You CAN connect to a MySQL database without a DSN name, you can just
declare
> an IP address and a DB name, but I'm pretty sure that this method still
uses
> the MySQL ODBC driver and it must be installed on the server.
>
> You CAN NOT, as far as I know, connect to a MySQL database, through ASP
(or
> any other program, I believe), without having at least the MyODBC driver
> installed on the server.
>
> <PLUG>
> I wrote a case study for ASPToday on ASP and MySQL integration. You can
view
> the synopsis and the article by going to:
> http://www.asptoday.com/content/casestudies/20010302.asp
> </PLUG>
>
> Good Luck,
>
> Dennis
> **********************************************
> Beridney Computer Services
> http://www.beridney.com
>
> ----- Original Message -----
> From: "VVM Ravikumar Sarma Chengalvala" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, May 30, 2001 1:03 PM
> Subject: ASP and my sql??
>
>
> > Hi,
> > I wonder to know of any other ways to connect to mySQL
> > from ASP without using ODBC....
> >
> > Regards,
> > Ravi
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
