asp <-> mysql connection string

[[o_O]]

I can't seem to get asp to interact with mySQL on my local machine.

Her is what i used when i was using SQL Server

<%
connString = ("Provider=SQLOLEDB;Trusted_Connection=yes;Server=yama;Initial Catalog=product;")
Set connection = Server.CreateObject("ADODB.Connection")
%>


I've never had to enter a u:p or setup a DSN when using sql server with asp or mysql with php..


:confused:

[oracleguy]

This is the connection i use in asp for mysql... maybe you can try this:


strConnection = "Driver=MySQL;server=DUPLICITY;user id=root;password=pwd;database=OLANA-MGR;"