I have a mySQL db setup, which can be connected to through IIS
(testing the data source through a DSN). I can also connect to the
db through SQLyog (GUI interface for the mySQL db).

However, I cannot connect to the db via an ASP page. I've tried
numerous connection strings, along with trying to connect with a DSN -
all unsuccessfully.

The ASP pages reside on a Win2k box and the db is on a linux box.
The fact that I can connect to it shows that I *should* be able to
hit the db from within the ASP page. Any help would be appreciated.

Some connect strings I'm trying...

'this is the simplest way to make the connection and it *should* work
rather easily 'adoConn.Open "DSN=employees.frm.dsn"

' from damian
'adoConn.Open "driver={mysql};
database=company_phone_listing;server=192.168.1.3;uid=hr;pwd=hr;option
=1
6386;"

' oledb provider for mySQL
'adoConn.Open "Provider=MySQLProv;" & _
' "Data Source=company_phone_listing;" & _
' "User Id=hr;" & _
' "Password=hr"

' from able consulting
'adoConn.Open "Driver={mySQL};" & _
' "Server=192.168.1.3;" & _
' "Port=3306;" & _
' "Option=131072;" & _
' "Stmt=;" & _
' "Database=company_phone_listing;" & _
' "Uid=hr;" & _
' "Pwd=hr"

' from connectionstrings.com
'adoConn.Open "Driver=
{mySQL};Server=192.168.1.3;Port=3306;Option=131072;Stmt=;Databas
e=company_phone_listing;Uid=hr;Pwd=hr;"