Connecting to database using VBA- “Data source name not found and no default driver specified” [closed]

Question

I'm having an issue connecting to my MySQL database from a VBA macro. (If this would be better served being asked in Stack Overflow, you can just tell me :) I have used this code

databasename = rando_db_name
Set oconn = New ADODB.Connection

oconn.Open "DRIVER={MySQL ODBC 5.1 Driver};" & _
"SERVER=xxx.xxx.xx.xxx;" & _
"DATABASE= " & databasename & ";" & _
"USER=test;" & _
" PASSWORD=rando_pw;" & _
"Option=3"

on a different computer in numerous other VBA programs, and it has worked fine. (The server is the IP of another computer at my desk; that's where all the databases are stored.) The problem is, trying to use the same code on a separate computer (my laptop) gives me the error message you see in the question title.It's preceded by [Microsoft][ODBC Driver Manager] if that helps at all.

Now, here's the thing I see as kind of odd- I know that I have a connection to the server, because I can open up Workbench (what I use for database management) and see and manipulate the databases, all from my laptop.

So to sum up, I guess I need to know, what is this error message telling me, why does this process work on one computer on the network and not another, and how can I fix it? Thank you for your time!

Quintis