ERROR - MYSQL CONNECTION ADO

Networking, connecting to the internet, wi-fi and home entertainment
User avatar
sal21
PlatinumLounger
Posts: 3674
Joined: 26 Apr 2010, 17:36

ERROR - MYSQL CONNECTION ADO

Post by 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...
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 71979
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: ERROR - MYSQL CONNECTION ADO

Post by HansV »

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

User avatar
sal21
PlatinumLounger
Posts: 3674
Joined: 26 Apr 2010, 17:36

Re: ERROR - MYSQL CONNECTION ADO

Post by sal21 »

HansV wrote:
29 Nov 2020, 16:19
Are you sure that the name DESTOP-TQPVR2M is correct? Shouldn't it be DESKTOP-TQPVR2M ?
NOW changed in LOCALHOST, have new error...
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 71979
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: ERROR - MYSQL CONNECTION ADO

Post by HansV »

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

User avatar
sal21
PlatinumLounger
Posts: 3674
Joined: 26 Apr 2010, 17:36

Re: ERROR - MYSQL CONNECTION ADO

Post by sal21 »

HansV wrote:
29 Nov 2020, 17:09
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.