Hi Ashutosh,
You can try a tool like MySQLX which was specifically developed for MySQL
and ASP, see: http://www.scibit.com/MySQLX
or any of the other ASP API interfaces in the mysql Contrib section.
Regards
Jacques
http://www.scibit.com/mysql
-Original Message-
From: ASHUTOSH SHARMA
Our solution to this was installing myODBC on the NT Server and connecting
in this fashion:
Dim Conn_STRING
Conn_STRING =
driver={mysql};database=dbname;uid=uname;pwd=password;option=16386;
set rsRecordSet = Server.CreateObject(ADODB.Recordset)
rsRecordSet.ActiveConnection = Conn_STRING
This