I am trying to setup a remote database connection to a server running MySQL version 5.0.96. When I execute I get the following error.

Any assistance is appreciated.

![ERROR MESSAGE](https://i.stack.imgur.com/4tQpl.png)

Here is my connection code:
Public Function opendb()

```
Dim oConn As ADODB.Connection
Dim Server_Name As String
Dim User_Name As String
Dim Password As String
Dim Database_Name As String

Server_Name = Sheets("_config").Range("B2").value
User_Name = Sheets("_config").Range("B3").value
Password = Sheets("_config").Range("B4").value
Database_Name = Sheets("_config").Range("B5").value

Set oConn = New ADODB.Connection
oConn.Open "DRIVER={MySQL ODBC 5.0.96 Driver};" & _
    "SERVER=Server_Name;" & _
    "DATABASE=Database_Name;" & _
    "USER=User_Name;" & _
    "PASSWORD=Password;" & _
    "Option=3"

```

End Function