[SOLVED]Excel, VBA to MySQL?

[Chrissy]

I use an Oracle database and this is how I connect to our DB (except I use Msdaora for my provider)... maybe if you do some changing around it will work for you.

Dim Conn As ADODB.Connection
Dim rsRec As ADODB.Recordset
 
Set Conn = New Connection
 
Conn.ConnectionString="Provider=MySQLProv;Database=astramedia;Uid=root;Pwd=Password;"
Conn.Open
 
Set rsRec = New ADODB.Recordset
rsRec.CursorType = adOpenKeyset
rsRec.LockType = adLockOptimistic
rsRec.ActiveConnection = Conn

[Fr0mi]

Thanks for the reply Chrissy!

Unfortunately I continue to get errors. Here is the correct translation of the last error:

Run-time error '-2147467259(80004005)':

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

I followed some help on the Internet regarding to create a System DSN and not a User DSN. However this did not change anything and the error message stays the same.

Using the method suggested by Chrissy i get a different error:

Run-time error '3706':

Unable to find the specified provider. It is possible that it has not been installed correctly.

So, I guessed changing Provider to Driver will give me different result.. And yes it throws me back to exactly the same error message as before (first one quoted)..

I am running out of ideas..
Could this be because I am running the Database on the same PC that I want to connect from?

Regards, thanks for further help!