ERROR - MYSQL CONNECTION ADO

[sal21]

Option Explicit
Private Sub Command1_Click()

Dim CON As ADODB.Connection
Set CON = New ADODB.Connection

CON.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=DESTOP-TQPVR2M;USER=root;PASSWORD=luca90;OPTION=3;"
CON.CursorLocation = adUseClient
CON.Open

End Sub

Have error...

[HansV]

Are you sure that the name DESTOP-TQPVR2M is correct? Shouldn't it be DESKTOP-TQPVR2M ?

[sal21]

Are you sure that the name DESTOP-TQPVR2M is correct? Shouldn't it be DESKTOP-TQPVR2M ?

NOW changed in LOCALHOST, have new error...

[HansV]

Sorry, I can't help you with that. Try searching google with mysql authentication plugin

[sal21]

Sorry, I can't help you with that. Try searching google with mysql authentication plugin

resolved my self.
changed the user in "standard" autetication, and not with caching_sha2....."

now all work perfect.
Tks.